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
Re: [sqlite] BUG - LEFT JOIN + IFNULL
On 3/23/19, Marek Šrom wrote: > I'm using 3rd party wrapping library for delphi, it was a bug in it. The > problem was that Sqlite3_ColumnDeclType for last column returns null (don't > > know if it is ok or not?)... > The library was setting column type from the first row value - it was > NULL... > > And the library was misinterpretting the non null values then... I fixed > this by settting correct column type with first non-null value of that > column... Columns in SQLite do not necessary store the same value. Depending on the declared datatype of the column, some columns can return different datatypes (TEXT, BLOB, REAL, INTEGER, NULL) for different rows. To be fully correct, the library needs to call sqlite3_column_type() for every column on every row and respond accordingly. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is there a way to select using cid?
On Fri, 22 Mar 2019 16:34:20 -0500, Peng Yu wrote: > There are cid's for each table. Is there a way to use "select" with > cid's instead of their names? Thanks. > > $ sqlite3 dbfile < create table test (id integer primary key, value text); > insert into test (id, value) values (1, 'abc'); > .mode column > .headers on > select * from pragma_table_info('test'); > EOF > cid nametypenotnull dflt_value pk > -- -- -- -- -- -- > 0 id integer 0 1 > 1 value text0 0 Why on earth would you want to do that? Eric -- ms fnd in a lbry ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is there a way to select using cid?
Peng Yu wrote: > There are cid's for each table. Is there a way to use "select" with > cid's instead of their names? > > select * from pragma_table_info('test'); > cid nametypenotnull dflt_value pk > -- -- -- -- -- -- > 0 id integer 0 1 > 1 value text0 0 This cid value is generated on the fly by table_info, and not used anywhere else. You would have to run "SELECT name FROM pragma_table_info(...) WHERE cid = ?" and then construct the actual SQL query with the returned column name. Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users