[sqlite] Where did the release announcements go?

2014-04-03 Thread Patrick Herbst
I depend on the sqlite-announce list to get updates on new releases. But it seems they haven't been posting there for the last couple releases. Why not? The archive shows the last announcement came for the 3.8.3.1 release. ___ sqlite-users mailing

Re: [sqlite] Where did the release announcements go?

2014-04-03 Thread Patrick Herbst
> > This is the right place to go. Here you find announcements of new > versions, planned updates and bug-fixes even before they arrive at > > Recent SQLite News No, I think they're all supposed to show up in sqlite-announce; not sqlite-users. 3.8.4.3 was announced in sqlite-announce. Very

[sqlite] New Optimizations in 3.7.16 -- Explain please?

2013-03-25 Thread Patrick Herbst
Can someone give me a case where the new changes make a difference in relation to the following two changes: (from http://www.sqlite.org/releaselog/3_7_16.html) - Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator. - Allow indices to be

[sqlite] Q: When to use sqlite3_shutdown ?

2013-04-01 Thread Patrick Herbst
When is there a need to use sqlite3_shutdown? I don't really see a clear explanation of when/how its needed. Any tips, please? Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New Optimizations in 3.7.16 -- Explain please?

2013-04-03 Thread Patrick Herbst
> Can someone give me a case where the new changes make a difference in > relation to the following two changes: > > (from http://www.sqlite.org/releaselog/3_7_16.html) > - Enhance virtual tables so that they can potentially use an index > when the WHERE clause contains the IN operator. > - Allow

[sqlite] Strange Corruption Issue

2018-06-18 Thread Patrick Herbst
I'm using sqlite in an embedded application, running on SSD. journal_mode=persist so that it is more resilient to loss of power. I'm seeing corruption. I'm using sqlite to log events on the system, and the corruption is well in the middle of a power session; not at the tail end of log when a