None of these are news to the HN community. Write-ahead logging and concurrency PRAGMAs have been a given for a decade now. IIRC, FTS5 doesn't often come baked in and you have to compile the SQLite amalgamation to get it. If you do need better typing, you should really use PostgreSQL.

However, I will concede, and the article doesn't mention at all, far less are aware that you can build HA, cross region replicated SQLite using purely OSS software provided you architect your software around it. Now that would be a really good `Modern SQLite: Features You Didn't Know It Had` article!

Another interesting discussion point is how far self hosted PostgreSQL and pgBackRest can get you to a near-zero data loss high RPO, RTO setup. Its simply amazing we can self host all this.

▲

sgbeal 5 hours ago | parent | next [-]

> Write-ahead logging and concurrency PRAGMAs have been a given for a decade now.

All of the listed features except for strict tables and generated columns have been in SQLite for 10+ years, and those two are certainly not new. The JSON APIs were not made part of the standard distribution until 3.38 (2022-02) but were added in 3.9 (2015-10) and widely used long before they were upgraded from an optional extension to a core feature.

- Generated columns: 3.31 (2020-01)

- Strict tables: 3.37 (2021-11)

	▲	subhobroto 2 hours ago \| parent [-]
		> All of the listed features except for strict tables and generated columns have been in SQLite for 10+ years, and those two are certainly not new Correct. As I mentioned in my GP, these features have been around a long, long, long time and in the current age of AI that would happily tell you these features exist if you remotely even hint at it, I would assume one would really have to go out of their way to be ignorant of them. It doesn't hurt to have an article like this reiterate all that information though, I just would have loved the same level of effort put into something that's not as easily available yet. A gap exists, and the article doesn't mention at all, about actually configuring solutions like litestream, rqlite, dqlite (not the same!) to build HA, cross region replicated SQLite using purely OSS software provided you architect your software around it. Now that would be a really good "Modern SQLite: Features You Didn't Know It Had" article! Another interesting discussion point is how far self hosted PostgreSQL and pgBackRest can get you to a near-zero data loss high RPO, RTO setup. It just blows my mind that we can self host all this on consumer grade hardware without having to touch a DC or "the cloud" at all.

▲

happytoexplain 5 hours ago | parent | prev | next [-]

There are plenty of people in the HN community who don't know much about SQLite. Tech is a big, huge, enormous, gigantic domain.

▲

123abcdef 4 hours ago | parent | prev | next [-]

I’m afraid you overestimated my knowledge

▲

esafak 2 hours ago | parent | prev [-]

https://www.explainxkcd.com/wiki/index.php/2501:_Average_Fam...