[sqlite] SQLite is a LoC Preferred Format for datasets

Thanks to Simon Willison for pointing out that SQLite is a Preferred Format for datasets according to the US Library of Congress. https://simonwillison.net/2018/May/28/library-of-congress/ -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] SQLite is a LoC Preferred Format for datasets

On 29 May 2018, at 7:42pm, Richard Hipp wrote: > Thanks to Simon Willison for pointing out that SQLite is a Preferred > Format for datasets according to the US Library of Congress. > https://simonwillison.net/2018/May/28/library-of-congress/ Obviously a good choice, which in no way makes it

[sqlite] sqlite3_deserialize - Any chance for failure?

Hi, I am using "sqlite3_deserialize" to read a database. sqlite3_deserialize API returns SQLITE_OK. But the "sqlite3_prepare_v2" API fails with error "no such table: moz_annos". I am adding a sample code fragment below. "dbBuffer" varibale is used to hold the database content and it contains

[sqlite] Version 3.24.0 feature freeze

We are planning to release SQLite version 3.24.0 soon. This is a "pencils down" announcement. From this point forward until the release, only bug fixes will be allowed on trunk. Our big overnight test runs are all passing. Please take an opportunity to review the change log

Re: [sqlite] [EXTERNAL] Re: database locked on select

Do the select and updates run inside a explicit transaction or they run in individual implicit transactions? pseudocode: - exec(BEGIN);// <- Do you have this? st_sel = prepare(SELECT ...); st_upd = prepare(UPDATE tab SET c1=?1, c2=?2, WHERE id=?3); while(step(st_sel) ==