I like using .sqlite as the extension (or .sqlite3). That way no Windows program will want to mess with it... usually 3 letter extensions are grist for the mill
On 11/27/06, John Stanton <[EMAIL PROTECTED]> wrote:
Use anything you like. Version 3 Sqlite is easy to recognize if you use .db3. RB Smissaert wrote: >>sqlite3 mydatabase.db3 > > > I always use the extension .db > What is the difference between db3 and db or maybe db2 etc.? > > RBS > > > -----Original Message----- > From: Kees Nuyt [mailto:[EMAIL PROTECTED] > Sent: 27 November 2006 22:49 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Saving tables > > On Mon, 27 Nov 2006 12:43:24 -0800 (PST), you wrote: > > >>I typed exactly what you typed there and i get >>SQL error: no such table: bar >>my command window doesnt have : "sqlite3 foo.sqlite" like yours > > > If you don't include a database name after the sqlite3 command, > sqlite uses the "memory" database, which ceases to exist after > you exit the program. > > So, use the following commamnd to create and open your database: > sqlite3 mydatabase.db3 > > and then issue the SQL commands at the prompt to create and > populate the table. > > Every time you want to reuse that database, you have to open it > in the same way: > sqlite3 mydatabase.db3 > > HTH ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
-- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ ------------------------------------------------------------------------------------------------------- collaborate, communicate, compete ==================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
