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 ...

A database is a structure where we store the necessary information for our applications, websites, or, more generally, for our programs. To access a database, we need a DBMS (Database Management ...

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 ...