Re: [sqlite] What is the most commonly used file extension for sqlite3 database files?
On 2019/03/23 6:06 PM, Peng Yu wrote: Hi, I see a variety of extensions for sqlite3 database files, such as .db, .db3, .sqlite3 and .sq3. Is there a most commonly used/accepted convention for the extension? Thanks. It's a convention-less thing, as others have mentioned. However, I can answer the most-used question as far as Windows environments go: The sqlite tool I maintain has a nifty little function that can search any folder on a drive (including subfolders) and list all the SQLite files it finds, so if I point it in Windows to the current user's root and start a search, all the sqlite files pop out, and I do this fairly often on random computers as a source of amusement. Due to the above, I have seen a LOT of sqlite files in my life used by a lot of applications, and I can tell you that the vast majority of them are all .db files. Skype uses it, Adobe has it, most downloadable DB's use it (chinook.db for instance). I have seen others: .sqlite and .sqlitedb are favourites too. Sometimes there are obscure ones, like the downloadable Geo-names file being a .qmv file (no idea why). Still, the majority are .db files. HTH, Ryan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] What is the most commonly used file extension for sqlite3 database files?
On 23 Mar 2019, at 16:06, Peng Yu wrote: > I see a variety of extensions for sqlite3 database files, such as .db, > .db3, .sqlite3 and .sq3. Is there a most commonly used/accepted > convention for the extension? Thanks. I use none at all. No extension is actually needed. -- Cheers -- Tim ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] What is the most commonly used file extension for sqlite3 database files?
I use .db cuz it is a database. You are free to call your files whatever you please (as is everyone else). You would have to take a very wide poll of the millions of users of SQLite3 to discover all the file extensions they use, since a name is just a name and nothing more than a name and has meaning only in the eye of the beholder ... It is dim sum -- whatever your heart desires ... --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Peng Yu >Sent: Saturday, 23 March, 2019 10:06 >To: SQLite mailing list >Subject: [sqlite] What is the most commonly used file extension for >sqlite3 database files? > >Hi, > >I see a variety of extensions for sqlite3 database files, such as >.db, >.db3, .sqlite3 and .sq3. Is there a most commonly used/accepted >convention for the extension? Thanks. > >-- >Regards, >Peng >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] What is the most commonly used file extension for sqlite3 database files?
Am 23.03.2019 um 17:06 schrieb Peng Yu: Hi, I see a variety of extensions for sqlite3 database files, such as .db, .db3, .sqlite3 and .sq3. Is there a most commonly used/accepted convention for the extension? Thanks. In the DatenBurg Environment, "*.sqlite" is used. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] What is the most commonly used file extension for sqlite3 database files?
Hi, I see a variety of extensions for sqlite3 database files, such as .db, .db3, .sqlite3 and .sq3. Is there a most commonly used/accepted convention for the extension? Thanks. -- Regards, Peng ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users