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

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

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

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] 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

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...

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'); >

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 > -- -- -- -- --