The SQLite database-management system offers many of the features found in large-scale commercial database software, including the ability to import Comma-Separated Variable (CSV) files. Many ...

Whether you want some quick and dirty data storage, or simply don’t have that heavy requirements for your local database system, SQLite is always a good choice. With its portable single-file ...

On the iPhone, the SQLite database vulnerability can be accessed thanks to a known bug in iOS’s Contacts app that has existed for four years now without a fix.

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema.

I'm trying to do some R&D on SQLite because I'd like to use it for a person project, but I've run into the problem that every database manager I try that supports SQLite seems to suck. hard. As in ...

I started out in Database Design early in my application development career. I still remember being issued with an official IBM stencil for drawing Entity Relationship Diagrams (ERDs). Change ...

SQLite has an incredibly small footprint. The database itself, its DLLs and the complimentary diff and analyzer tools are less than 15 MB in size. It's perfect for small mobile devices, advanced ...

Get started with the Room data persistence library, and learn how to create lifecycle-aware components using the Architecture Components Lifecycles library.

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