Re: [sqlite] sql/tcl script

2012-01-16 Thread Simon Slavin
On 16 Jan 2012, at 8:11pm, Bill McCormick wrote: > I was sort of hoping it might be narrowed down to one of the documents on > this page: > > http://www.sqlite.org/docs.html > > Typing "script" and "command line" in the search box didn't help me find what > I was looking for either. Ah, I to

Re: [sqlite] sql/tcl script

2012-01-16 Thread Stephan Beal
On Mon, Jan 16, 2012 at 9:21 PM, Tim Streater wrote: > I'm using the PDO interface from PHP for SQLite3 with no problems. What > are you referring to? > Sorry for the confusion - i meant that those are languages which _do_ have sqlite3 bindings (but my wording implied the opposite). -- - s

Re: [sqlite] sql/tcl script

2012-01-16 Thread Tim Streater
On 16 Jan 2012 at 18:15, Stephan Beal wrote: > On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick wrote: > >> Is tcl the only scripting interface for SQLite? I'm just wondering what >> the options are. > There are few scripting languages which don't have an sqlite3 binding. Just > to name a few: >

Re: [sqlite] sql/tcl script

2012-01-16 Thread Bill McCormick
Simon Slavin wrote, On 1/16/2012 1:45 PM: On 16 Jan 2012, at 7:34pm, Bill McCormick wrote: Looks like pipes work as well (cat yoursql.sql|sqlite3 yourdb.db3). Also, can I safely delete the database file (yourdb.db3, using your example) if I just want to start again? It appears that I can. N

Re: [sqlite] sql/tcl script

2012-01-16 Thread Oliver Peters
Am 16.01.2012 20:34, schrieb Bill McCormick: Oliver Peters wrote, On 1/16/2012 1:02 PM: Am 16.01.2012 19:59, schrieb Bill McCormick: James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object cr

Re: [sqlite] sql/tcl script

2012-01-16 Thread Simon Slavin
On 16 Jan 2012, at 7:34pm, Bill McCormick wrote: > Looks like pipes work as well (cat yoursql.sql|sqlite3 yourdb.db3). > > Also, can I safely delete the database file (yourdb.db3, using your example) > if I just want to start again? It appears that I can. Not while an app has it open, but if

Re: [sqlite] sql/tcl script

2012-01-16 Thread Bill McCormick
Oliver Peters wrote, On 1/16/2012 1:02 PM: Am 16.01.2012 19:59, schrieb Bill McCormick: James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute that f

Re: [sqlite] sql/tcl script

2012-01-16 Thread Stephan Beal
On Mon, Jan 16, 2012 at 8:02 PM, Bill McCormick wrote: > I assume that you are *NOT* naming the few that don't, rather these > scripting languages *DO* have sqlite3 binding support. Yes, sorry - a bad choice of wording on my part. :/ -- - stephan beal http://wanderinghorse.net/home/stephan

Re: [sqlite] sql/tcl script

2012-01-16 Thread Oliver Peters
Am 16.01.2012 19:59, schrieb Bill McCormick: James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute that file from within sqlite using the ".read FILE

Re: [sqlite] sql/tcl script

2012-01-16 Thread Bill McCormick
Stephan Beal wrote, On 1/16/2012 12:15 PM: On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormickwrote: Is tcl the only scripting interface for SQLite? I'm just wondering what the options are. There are few scripting languages which don't have an sqlite3 binding. Just to name a few: - Perl - PHP -

Re: [sqlite] sql/tcl script

2012-01-16 Thread Simon Slavin
On 16 Jan 2012, at 6:59pm, Bill McCormick wrote: > James Pearson wrote, On 1/16/2012 12:28 PM: >> If it's just for setting up databases, tables, etc, why not just use a sql >> script? >> >> Throw all your database object creation sql into a file and then execute >> that file from within sqlite

Re: [sqlite] sql/tcl script

2012-01-16 Thread Bill McCormick
James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute that file from within sqlite using the ".read FILE" command. I think this is what I'm lookin

Re: [sqlite] sql/tcl script

2012-01-16 Thread James Pearson
If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute that file from within sqlite using the ".read FILE" command. On 16 Jan 2012, at 11:23, John Elrick wrote: Ruby also. On Mon, Jan 16,

Re: [sqlite] sql/tcl script

2012-01-16 Thread John Elrick
Ruby also. On Mon, Jan 16, 2012 at 1:15 PM, Stephan Beal wrote: > On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick >wrote: > > > Is tcl the only scripting interface for SQLite? I'm just wondering what > > the options are. > > > > > There are few scripting languages which don't have an sqlite3 bi

Re: [sqlite] sql/tcl script

2012-01-16 Thread Stephan Beal
On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick wrote: > Is tcl the only scripting interface for SQLite? I'm just wondering what > the options are. > There are few scripting languages which don't have an sqlite3 binding. Just to name a few: - Perl - PHP - JavaScript (v8 and SpiderMonkey engines

[sqlite] sql/tcl script

2012-01-16 Thread Bill McCormick
Is tcl the only scripting interface for SQLite? I'm just wondering what the options are. I'm trying to write a script to setup my database on new systems (create the db, add tables, etc.), but I don't have much experience using Tcl. My fist attempt is not going so well and I'm not finding hel