I recently published a tutorial describing the different available methods to store data locally in an Android app. However, due to article length constraints, I could not adequately cover creating ...

A simple project demonstrating CRUD operations (Create, Read, Update, Delete) in Python using SQLite. This project is perfect for beginners looking to understand how to work with a lightweight ...

A simple web-based viewer for SQLite databases. This application allows users to load a .sqlite file, view the structure of tables, and display their data in a user-friendly interface. It provides ...

SQLite is a powerful, embedded relational database management system in a compact C library, developed by D. Richard Hipp. It offers support for a large subset of SQL92, multiple tables and indexes, ...

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

Lift the hood on most business applications, and you’ll find they have some way to store and use structured data. Whether it’s a client-side app, an app with a web front end, or an edge-device app, ...

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