[sqlite] Can't create empty database

Googling on how to create a sqlite database (empty one) it appears I need only do 'sqlite3 test.db'. However, when I try that I get: ->sqlite3 test.db SQLite version 3.7.13 2012-06-11 02:05:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> however, no database

Re: [sqlite] Can't create empty database

atabase" that contained the 100 byte 'SQLite format 3' database header structure together with any internal tables such as 'sqlite_master' and not just an empty file. Regards, LA On 06/25/2012 10:01 AM, L Anderson wrote: Googling on how to create a sqlite database (em

Re: [sqlite] Can't create empty database

Oliver Peters wrote: Am 25.06.2012 10:01, schrieb L Anderson: Googling on how to create a sqlite database (empty one) it appears I need only do 'sqlite3 test.db'. However, when I try that I get: ->sqlite3 test.db SQLite version 3.7.13 2012-06-11 02:05:22 Enter ".help"

[sqlite] JDBC Drivers--which one?

I have found both the Xerial and Zentus SQLite JDBC Drivers on the net. This leads me to wonder are there other JDBC drivers for SQLite and if so what are they? Also, what are the pros and cons of the available drivers? Which one is the recommended one for use with SQLite? Thanks, LA _