Re^2: SQLite command line

Sorry if I express myself wrong. What I need is the follows. I have several files with 30+ columns which I need to import into the database. Of course I could write a create instruction and then insert into (..these 30 fields again ..) values. Using the command line I could just load file into a table.
Scratch_DB seems to be the very thing I need for this but it seems not to run on ActivePerl.

Comment on Re^2: SQLite command line

Replies are listed 'Best First'.
Re^3: SQLite command line by ikegami (Patriarch) on Jan 31, 2012 at 21:47 UTC
is it possible to access the command line interface of SQLite SQLite is an application programming interface (API). `sqlite3` is a command line interface to a SQLite database. Did you mean "is it possible to access a command line interface to SQLite?" Did you mean "is it possible to access `sqlite3`?" Either way, the answer is surely the same: Yes, `sqlite3` is available for Windows. Using the command line I could just load file into a table. That should read "Using `sqlite3`, I could just load file into a table.". Excellent. Exactly what you need. Update: Rewritten.	[reply] [d/l] [select]
Re^4: SQLite command line by Anonymous Monk on Feb 01, 2012 at 14:53 UTC
I know now how I should ask in the first time :-) If sqlite3 is in the standard Perl distribution. The answer is obviously no. Thanks!	[reply]
Re^5: SQLite command line by ikegami (Patriarch) on Feb 01, 2012 at 19:56 UTC
If sqlite3 is in the standard Perl distribution. "Is sqlite3 in the standard Perl distribution?" No. Considering that neither DBI nor DBD::SQLite (what DBI uses to access SQLite databases) is in the standard distribution, this should be no surprise. Furthermore, it's not in the DBD-SQLite distribution either. There's no reason to bundle the two clients, and lots of problems in trying to.	[reply]