Sqlite is admirable in the way it uses broad standards and run on just about anything which can switch electrons. It is tidy practise and simply good business to maintain that most desirable condition.

P Kishor wrote:
On 11/28/06, John Stanton <[EMAIL PROTECTED]> wrote:

If you use an extension greater than 3 chars you violate rules for some
existing file systems and reduce portability.  You can also make it
difficult to parse the extension when it is used to type the file.


we are going a bit off-thread here, but violating the file system rule
(in this case, Windows) is precisely why I use an extension greater
that 3 chars. For example, .db extension is used by several other
programs -- Windows itself uses .db extension for thumbnails it
generates for pictures inside a folder. I want to get above that
riff-raff. The stupid system just lists my databases as "SQLITE File."
Good enough for me.

As far as portability is concerned -- my world revolves around Unixes,
in particular Mac OS X, some Linux variants, and Windows. I have never
had any portability issues with foo.sqlite.


In medecine the Hippocratic Oath requires "First, do no harm".  Not a
bad principle for IT design also.


I think, in good health, the first principle should be, don't expose
yourself to ills. By making my extension illegible to anything but
SQLite, I am not even getting in the fray.


P Kishor wrote:
> 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]
>> -----------------------------------------------------------------------------
>>
>>
>>
>
>


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------






-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to