[sqlite] Controlling the lifetime of shared-cache, in-memory SQLite databases.

SQLite has the useful ability to provide an in-memory database that can be shared by multiple connections in the same process by opening the DB with the following syntax: rc = sqlite3_open("file:memdb1?mode=memory=shared", ); I'm testing a database having this configuration in a unit

[sqlite] Format of sqlite-users digests.

the product and value the community; just bringing this up as a question. Randall Smith ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unsigned

>>> Date: Tue, 21 Aug 2018 16:46:48 +1000 >>> From: D Burgess >>> >>> Is there a historical reason why sqlite does not have a UNSIGNED type to go >>> with INTEGER? I would like to enthusiastically second not only this as a feature request, but also request

Re: [sqlite] Unsigned

>>> From: D Burgess >>> You can just store [large integers as] binary blobs and interpret then in >>> the client, no? Or do >>> you need to do arithmetic on them? BLOBs are useful for storage of binary info (e.g., a file), but they are not human readable and

[sqlite] Best practices for forward conversion of database formats?

This is not strictly a SQLite question, though in my case it is. Any application that involves a "persistent" database, i.e., one where the data is long-lived and expected to exist and evolve over time, sooner or later has the issue of moving customers from a V1 database to a V2 database.

[sqlite] Round-tripping SQLite back and forth between text representation.

I'm curious if there is some standard or normal way to convert a SQLite DB to a text representation, and then recreate the DB content from the text. Naively, this seems hard or impossible as a general problem, but perhaps I am missing something. Thanks in advance for any advice or

[sqlite] Round-tripping SQLite back and forth between text representation.

ordering effectively random? My underlying question is "can text-comparing two DB dumps be used to determine what has changed?" Thanks again for any insights. Randall Smith ___ sqlite-users mailing list sql

Re: [sqlite] Round-tripping SQLite back and forth between text representation.

On 2018/07/10 8:27 PM, Randall Smith wrote: > One follow-up: Do you know if the dump output is "deterministic" over > time? That is, if I diff two dumps taken at different times, will the > unchanged material be in the same order and so on? Or is the ordering > eff

[sqlite] "Tagging" SQLite tables with attributes for introspection.

I'm writing some code to do processing of some (but not quite all) of the tables in my SQLite database. I could make this a lot easier and more general purpose if I could somehow attach an attribute to the various tables that indicated whether that table should be processed. Other than, say,

Re: [sqlite] Tips for index creation.

One feature that would be useful for the sqlite3 command shell would be a mode where the duration of the operation is reported after the operation runs (".timing"?). This would make it easy to compare different approaches for writing a query, formulating and using different indices, etc. Of

[sqlite] "Pickling" an in-memory SQLite database.

Hi, guys. I have an application that allows me to embed a (potentially large) block of data into its application file at close, and read the block back on open. It would be convenient and attractive for me, for a plugin I am writing for this application, to be able to use an in-memory SQLite

[sqlite] SuperSQLite: a supercharged Python SQLite library

this really annoying since one wants transaction handling to very simple and predictable so that the right thing happens under all circumstances. I, too, would be interested to hear from people who have real experience with it. Randall Smith ___ sql

[sqlite] Recursive CTE as correlated subquery?

I have an application for doing recursive data lookup as part of a larger query. For example, for each node in a tree, are there any children of the node that have some property? In non-recursive settings, one would use a conventional correlated subquery that references the node id from the

[sqlite] Multiple ATTACHments to the same DB?

Hi, all. I am developing a setup where multiple independent slave SQLite databases are periodically synching with the same master database. It would be convenient if I could ATTACH the slave and master DBs to each other during the synch so I could run the synch as a single transaction and so I

[sqlite] Getting "chunked" output from a large SELECT operation.

I'm having a situation where the results of a large SELECT operation are apparently too big to fit in memory. Obviously I could jerry-rig something to work around this, but I have a vague recollection that SQLite provides a nice way to get the results of a query in "chunks" so that the memory

[sqlite] Safe to use SQLite over a sketchy network?

any experience or insight I would appreciate it. Randall. Randall Smith BB-106G (office) BB-172D (lab) 858-775-5017 (cell) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo