No. See http://sqlite.org for what SQLite is and why what you want does not work. On the upside, it is not hard to read SQL line by line in Perl and feed that to DBD::SQLite. See DBIx::RunSQL. | [reply] |
I use SQLite Manager which is a Firefox plugin. I just installed the Perl DBD::SQLite module and this thing in the browser. I've never tried to run command line SQLite mainly because I just haven't needed to do so. | [reply] |
Scratch_DB seems to be exact what I need ... but unfortunately does not work on ActivePerl because of String::Escape.
DBI::Shell is too complex for a newbie.
Thank you!
| [reply] |
but unfortunately does not work on ActivePerl because of String::Escape
Sure it does, just fix the makefile, delete MY::postamble
| [reply] [d/l] |
huh? What do you mean by "command line interface", and how does that differ from "stand-alone application"? | [reply] |
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.
| [reply] |
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] |