We are big fans of using SQLite for anything of even moderate complexity where you might otherwise use a file. The advantages are numerous, but sometimes you want to be lean on file storage. [Phiresky ...

In my last column, I introduced SQLite, an amazing little database engine written and provided entirely in C source code. I showed you how to begin wrapping it up in modern C++, producing a correct ...

Microsoft has long offered a compact alternative to the mainstream editions of SQL Server, but the SQL Server Compact Edition appears to be losing steam. It's not particularly compact and has lost ...

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

SQLite is a simple yet powerful embedded SQL database engine. Unlike other database systems, SQLite does not need to run on a server, and all information is stored in a single file on disk. SQLite is ...

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

For background on this project, see Google Drive to SQLite on my blog. If you use Google Drive, and especially if you have shared drives with other people there's a good chance you have hundreds or ...

First, ensure that you have SQLite installed on your system. Python comes with SQLite support out of the box, so no additional installation is required. You can start using SQLite in your Python code ...