[maemo-developers] SQLite

[From: Graham Cobb]

On Friday 26 February 2010 07:00:09 Fred Lefevere-Laoide wrote:
> Sqlite is available in the extras repository as a lib (gpe and others depnd
> on it)

The libs are available for both sqlite2 (although the library is called 
libsqlite0) and sqlite3 (the library package is called libsqlite3-0).  In 
general, new code should use sqlite3.  Databases are not compatible between 
sqlite2 and sqlite3.

However, the command line utility is ONLY available in the Diablo repository 
for sqlite2.  This is the package called "sqlite" (which installs a program 
also called "sqlite").  The sqlite3 command line program has not been made 
available by anyone for diablo.

So, if you want to use the command line utility you need to use sqlite2.

Graham