In my previous tutorial, I discussed about how to extract strucured expense data from images, store it into a SQLite DB and use Metabase to perform expense analytics. In this tutorial, I would like to ...
Modern SQLite (and SQLCipher) database viewer/editor for VS Code: table browsing, Monaco-powered queries, ER diagrams, and quality-of-life tooling for JSON/BLOBs and large tables. Beta note: features ...
Relational databases are a key component of the software landscape. SQLite is a simple but versatile implementation with a variety of use cases. Node 22.5 introduces a node:sqlite module that ships ...
In my last article I wrote about accessing a PostgreSQL database in C/C++. In this article, I'm going to discuss performing the same functions in C against an SQLite database. Unlike Postgresql and ...
Alex Garcia announced the much-anticipated release of sqlite-vec v0.1.0. This new SQLite extension, written entirely in C, introduces a powerful vector search capability to the SQLite database system.
SQLite is suitable for apps that require reliable storage and small but frequent updates. DuckDB can handle large datasets and analytical SQL workloads efficiently. Matching database design to ...
Sometimes the best option is the simplest, even when it comes to databases. While many developers reach for Postgres or MySQL by default, might it be better to take the more lightweight approach to ...