Re: [sqlite] Shared memory cache files on disk?

On Wed, Aug 29, 2018 at 1:11 AM Keith Medcalf wrote: > SQLITE_USE_URI > > If this is not defined then URI's are not parsed. > > https://www.sqlite.org/uri.html > Thank you, that helps a lot! ___ sqlite-users mailing list

[sqlite] Shared memory cache files on disk?

Hi there, I've been using in-memory SQLite database for the automated tests in an application I'm writing. I did most of the initial development on macOS and things worked as I expected, but when I ran the tests on my Linux box it left behind files like "file:test-3210?mode=memory=shared". On my

Re: [sqlite] Pragma notnull for integer primary keys?

Ping -- I thought this might be a bug. Can someone confirm or explain why it's not? Regards, Dirkjan On Tue, Aug 7, 2018 at 7:34 AM Dirkjan Ochtman wrote: > Yesterday I started a new project with SQLite. I wanted to create some > simple integer-based primary keys and used an ORM to ge

[sqlite] Pragma notnull for integer primary keys?

Yesterday I started a new project with SQLite. I wanted to create some simple integer-based primary keys and used an ORM to generate code. I then noticed that the primary keys were generated as Nullable types. I asked on Gitter and someone pointed me to this bit of documentation: "According to