Linux: If the extension is not working out-of-the-box, it may be necessary to install sqlite3 in your system (on Ubuntu: sudo apt install sqlite3) Note: The extension includes precompiled binaries for ...

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

Python context managers to query a SQLite file stored on S3. It uses multiple HTTP range requests per query to avoid downloading the entire file, and so is suitable for large databases. All queries ...

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

Love it or hate it, the capabilities of your modern web browser continuously grow in strange and wild ways. The ability for web apps to work offline requires a persistent local storage solution and ...

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

Community driven content discussing all aspects of software development from DevOps to design patterns. SQLite is an incredibly lightweight and remarkably popular SQL-compliant database. In fact, it’s ...