News for hackers. Stuff that matters.
Re:Exciting SQLite Improvements Since 2020 by OliverJones on Friday April 28, 2023 @04:46PM (#35746905)
The clustered primary key (NO ROWID) setup that came in with SQLite version 3.8.2 (2013-12-06) makes it very fast indeed when used for a large persistent key-value store.

And later improvements have just continue to accrue.

This from a guy who just implemented a persistent object cache with it, and was blown away by how well it works. And my requirement was all SQLite versions 3.7 and later, so there's conditional code. (ROWID or not, UPSERT or not).

Not to mention there are probably ten or more of these databases in your mobile phone. We haven't heard, at least I haven't, about any monstrous day-1 vulnerabilities in this code.

A really good design choice, SQLite is, if your application can live with its local file system requirement.

Re:Exciting SQLite Improvements Since 2020 by dashmeet on Friday April 28, 2023 @06:12PM (#35747758)
I wonder how this compares to using redis for key value caching purposes?

Definitely reduces the need for another dependency if that’s your thing and it fits your needs

Re:Exciting SQLite Improvements Since 2020 by meepmorp on Friday April 28, 2023 @08:20PM (#35748750)
Why use redis at all if you don't need shared cache?
Re:Exciting SQLite Improvements Since 2020 by OliverJones on Sunday April 30, 2023 @06:16AM (#35761195)
I'm working on comparisons between redis and SQLite for object caching. So far things look favorable.

I did this project for WordPress, because object caching helps performance (and therefore carbon footprint) a lot and cheezy hosting services don't offer redis. But most of them have SQLite.

Oddly enough, SQLite is really slow on the one BSD hosting service I've tried.