Hi,
I'm using SQLite in WAL mode in the following scenario:
- One writer which continuously writes new rows and deletes older ones
- Multiple readers performing queries
Writer and readers are running each in a separate process.
The (Inactive) Journal Size limit is set to 100MB by pragmas and in
n
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
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
_
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
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.
__
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.sq
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...
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
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
> -- -- -- -- -- --
9 matches
Mail list logo