SQLite has had JSON support for a while. However recently it added a killer feature: generated columns. (This was added in 3.31.0, released 2020-01-22.) This makes it possible to insert JSON straight into SQLite and then have it extract data … Read more
Demystifying the “Local-Only” Myth of SQLite Historically, SQLite has been relegated to the role of an embedded database for mobile clients, IoT devices, and local development environments. Conventional wisdom dictated that for any serious production-grade web application, a client-server database … Read more
Date: 2026-07-15 Git: https://gitlab.com/mort96/blog/blob/published/content/00000-home/00017-sqlite-editions.md SQLite is an amazing database engine. I use it as a database for plenty of embedded projects, and I don’t think it’s an exaggeration to call it the industry standard for local data storage. Some server … Read more
I read Prefer STRICT tables in SQLite by Evan Hahn last week, and it got me thinking. Here is someone treating SQLite as a database you put real, typed, production data into. Which raises the obvious question: how far does … Read more
LoC Recommended Storage Format Small. Fast. Reliable.Choose any three. LoC Recommended Storage Format SQLite is a Recommended Storage Format for datasets according to the US Library of Congress. Further information: As of this writing (2018-05-29) the only other recommended storage … Read more
What is Rivet? Rivet Actors are a serverless primitive for stateful workloads. Each actor has built-in state, storage, workflows, scheduling, and WebSockets — everything needed to build the next generation of software.
How SQLite Is Tested Table Of Contents The reliability and robustness of SQLite is achieved in part by thorough and careful testing. As of version 3.42.0 (2023-05-16), the SQLite library consists of approximately 155.8 KSLOC of C code. (KSLOC means … Read more
We absolutely love SQLite here at DB Pro. You’d be hard-pressed to find anyone who actively dislikes it. Sure, it has limitations, and I do mean limitations, not weaknesses. SQLite can absolutely be used in production when it’s deployed properly … Read more
SQLite is a powerful database engine, but due to its design, it has limitations that should not be overlooked. Jellyfin has used a SQLite-based database for storing most of its data for years, but it has also encountered issues on … Read more
Why Is SQLite Coded In C Table Of Contents Note: Sections 2.0 and 3.0 of this article were added in response to comments on Hacker News and Reddit. Since its inception on 2000-05-29, SQLite has been implemented in generic C. … Read more