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

Connecting to an SQLite database The sqlite3 that we will be using throughout this tutorial is part of the Python Standard Library and is a nice and easy interface to SQLite databases: There are no ...

For example, if you have a table named SALES_DATA containing the sales data with the columns YEAR, PRODUCT and SALES. To calculate the total sales in a year, the GROUP BY clause can be used to group ...

SQLite is a lightweight, disk-based database that doesn’t require a separate server process and allows accessing the database using a nonstandard variant of the SQL query language. Python provides an ...

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

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