Re: [sqlite] Is it possible to dump a sqlite db that has an associated -wal file?

On Saturday, 15 February, 2020 19:27, Peng Yu wrote: >I am trying to see what tables are available in sqlite_master from >firefox cookies sqlite3 fire. >~/Library/Application >Support/Firefox/Profiles/jaseom4q.default-1480119569722/cookies.sqlite >But the error message says "Error: database

Re: [sqlite] WITHOUT ROWID tables

> > To determine if table XYZ is a WITHOUT ROWID table, run "PRAGMA > index_info('XYZ');". If you get back one or more rows, then XYZ is a > WITHOUT ROWID table. If you get back no rows, then XYZ is a rowid > table. > Confused...What if I made an index on a ROWID table? CREATE INDEX "Z" ON "DOC"

Re: [sqlite] system.data.sqlite example code?

I think this is an informative post and knowledgeable. I would like to thank you for the efforts you have made in writing this article Packers and Movers in Delhi - [url=https://www.aryawartapackers.com]packers and movers in delhi[/url] -- Sent from:

Re: [sqlite] WITHOUT ROWID tables

On 15 Feb 2020, at 3:14pm, sky5w...@gmail.com wrote: >> To determine if table XYZ is a WITHOUT ROWID table, run "PRAGMA >> index_info('XYZ');". If you get back one or more rows, then XYZ is a >> WITHOUT ROWID table. If you get back no rows, then XYZ is a rowid >> table. >> > Confused...What if

Re: [sqlite] Can I search all tables and columns of SQLite database for a specific text string?

You can do it in Tcl (reusing Jose's example tables) like this: package require sqlite3 sqlite3 dbcmd ~/tmp/grbg.db dbcmd eval "create table table0 (id INTEGER PRIMARY KEY, t0a, t0b, t0c, t0d)" dbcmd eval "insert into table0 (t0a, t0b, t0c, t0d) values ('text in here', 'Shelby 2002', '2 plus 2

Re: [sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

Regardless of whether you decide to store GUIDs as text or binary, things will be easier if you set your connection string appropriately. BinaryGUID is the parameter you want to change. See https://www.connectionstrings.com/sqlite-net-provider/store-guid-as-text/ For performance binary is

Re: [sqlite] WITHOUT ROWID tables

Wouldn't be something like SELECT sql FROM sqlite_master WHERE tbl_name='?' AND type='table' contains "WITHOUT ROWID" be sufficient? Just being curious. - Original Message - From: sky5w...@gmail.com To: SQLite mailing list Sent: Saturday, February 15, 2020, 18:06:47 Subject:

Re: [sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

On 15 Feb 2020, at 8:12pm, J Decker wrote: > memcmp is harder than strcmp? > and with blob I suppose you don't have 'if UTF8 or UTF16 do > different things' so should compare slightly faster? It's not cut-and-dried, but you can take things into consideration. Once data is in a database it

Re: [sqlite] WITHOUT ROWID tables

Does sqlite3_table_column_metadata(db,dbName,tblName,"rowid",0,0,0,0,0)==SQLITE_OK return false if table tblName is a without rowid table? https://sqlite.org/c3ref/table_column_metadata.html -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___

Re: [sqlite] WITHOUT ROWID tables

On February 15, 2020 2:14:30 p.m. EST, Thomas Kurz wrote: >Wouldn't be something like > >SELECT sql FROM sqlite_master WHERE tbl_name='?' AND type='table' >contains "WITHOUT ROWID" > >be sufficient? > >Just being curious. > >- Original Message - >From: sky5w...@gmail.com >To: SQLite

Re: [sqlite] WITHOUT ROWID tables

Ok, not ideal. Still confusing, but I see the difference. For my code, I know the schemas. I guess a SQL builder could offer up query options to the user browsing new databases. On Sat, Feb 15, 2020 at 11:26 AM Simon Slavin wrote: > On 15 Feb 2020, at 3:14pm, sky5w...@gmail.com wrote: > > >> To

Re: [sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

On Fri, Feb 14, 2020 at 7:36 AM Simon Slavin wrote: > On 14 Feb 2020, at 2:59pm, Andy KU7T wrote: > > > Do you suggest me keeping storing TEXT (and declaring the column as TEXT > instead of GUID) or storing and declaring BLOB (and remove HEX)? > > TEXT. Makes sorting and searching easier. >

[sqlite] Is it possible to dump a sqlite db that has an associated -wal file?

Hi, I am trying to see what tables are available in sqlite_master from firefox cookies sqlite3 fire. ~/Library/Application Support/Firefox/Profiles/jaseom4q.default-1480119569722/cookies.sqlite But the error message says "Error: database is locked". I see a cookies.sqlite-wal file in the same

Re: [sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

While that is nice, it is likely completely irrelevant. The issue appears to be the flamboyant conversion of data being performed by dotSnot (.NET). The fact that data can be stored in several different formats inside the database, and then converted to what dotSnot calls a "GUID" is all very