The extension doesn't actually matter. You could call it .bob for all SQLite cares. .db and .db3 are just conventions used to differentiate an SQLite 3 database from an older database.
-- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -------------- Original message ---------------------- From: "RB Smissaert" <[EMAIL PROTECTED]> > > 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 > -- > ( Kees Nuyt > ) > c[_] > > ---------------------------------------------------------------------------- > - > To unsubscribe, send email to [EMAIL PROTECTED] > ---------------------------------------------------------------------------- > - > > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------