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

In this lesson, we'll cover the importance of specifying datatypes, and the different types of data you can store in a SQLite database. Describe data typing and how it allows for operations to be ...

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 faster SQLite writes for heavy ingest. Turso’s Rust engine adds MVCC and async IO, hitting roughly 200,000 writes each second.

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

This Ansible Role installs SQLite on Debian-based OSes (Debian, Ubuntu). More specifically, it compiles and installs the shell command sqlite of SQLite from the official source code. It enables access ...

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