GitHub

under-doc/underdoc-tutorial-expense-analytics-mcp-sqlite

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

EsraCesur4/SQL-SQLite-with-Python-Country-Pokemon-Data

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

Intro to Node’s built-in SQLite module

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

Accessing SQLite in C

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

DuckDB vs SQLite: Features, Performance, and How to Choose the Right Database

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

SQLite in Production: 10 examples out in the wild

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