Re: Bash

[Greg Wooledge]

On Wed, Apr 15, 2020 at 01:05:31PM -0400, Jeffrey Walton wrote:
> Well, I can't speak for others, but in the past I wanted to do
> something simple like create a SQLite database:
> 
>     ATTACH DATABASE 'mydb.db' AS 'mydb';
>     CREATE TABLE IF NOT EXISTS mydb.username
>     (
>         id INTEGER PRIMARY KEY AUTOINCREMENT,
>         fname VARCHAR,
>         lname VARCHAR,
>         email VARCHAR,
>         date DATETIME
>     );
> 
> and insert some values:
> 
>     INSERT INTO mydb.username (fname, name) VALUES ("JOHN", "DOE");
> 
> I quickly learned Bash was the wrong tool for the job. At the moment,
> I think it is easier to create a *.sql file and redirect it into the
> SQL interpreter.

I found Tcl to be extremely well-suited to this.  I used it as the basis
of the web site <http://paste.wooledge.org/> (link to source code is
there too).