[sqlite] SQLite Amalgamation in a GIT repo

I found that there aren't any up-to-date GIT copies of just the amalgamation on github. So, I wrote up some simple steps whereby anyone could make their own. On a project that uses GIT and either git subtree or git submodules, this is a very handy way to keep SQLite up-to-date. http://blog.paddle

[sqlite] create temporary virtual table

r releases some external resources, it can probably be safely > created in the temp database and cleaned up by SQLite on exit. Of course, > if you explicitly DROP it when you are done with it, the xDestroy methods > will be called and all should be as normal. > Peter > > >

[sqlite] create temporary virtual table

I see there is no way to create a temporary virtual table. One idea I had was to create a second, in-memory db and attach that, then create the virtual table over there. Currently I have it working where as soon as I open the db, I use sqlite_master to find any left over virtual tables from befor

[sqlite] Suggestions for Fast Set Logic?

Thanks all for the interesting discussion, you've given me a lot to think about. I've worked with SQLite for 10+ years, but I still consider myself something of newbie compared to the folks here, which is why I asked. One thing is clear -- our lack of routine calls to ANALYZE might be a huge reas

[sqlite] Suggestions for Fast Set Logic?

data_id from keywords natural join n2mkeyworks where keyword = > 'chocolate'); > > will return all the data tuples associated with the keyword ('once' or > 'bonca') and 'chocolate' > > > > -Original Message- > > From: sqlite-users-bounce

[sqlite] Suggestions for Fast Set Logic?

I want to build an application that can search for specific documents based on a lot of criteria from a user (e.g. matching keywords, text, etc...). And then to combine these results using boolean logic ... For example, keyword 'animal' AND rating > 3 Each document has an integer id. My strategy

[sqlite] Did A Recent Windows & Update Affect SQLite???

Hi Mark I echo the suggestion that you make sure your HDD is working properly by doing a disk scan of some sort. It's dangerous to start trying other solutions if the drive is about to fail! While you're at it, it's probably a good idea to make sure your backups are up to date -- and by backup I

[sqlite] static malloc_zone_t* _sqliteZone_

27;s platforms. > > On Mar 3, 2015, at 7:27 PM, Andy Rahn wrote: >> >> Hi SQLite users; >> >> I have a question about _sqliteZone_ in mem1.c. I notice that the >> address of this static variable is used in a call to >> OSAtomicCompareAndSwapPtrBarrier

[sqlite] static malloc_zone_t* _sqliteZone_

Hi SQLite users; I have a question about _sqliteZone_ in mem1.c. I notice that the address of this static variable is used in a call to OSAtomicCompareAndSwapPtrBarrier on MacOS and iOS. That system call is declared in OSAtomic.h, which includes a note about the pointer alignment of its argument