News

We’ll take a look at SQLite, including where and when to use it and how it compares to alternatives such as MySQL, MariaDB, and other popular embedded databases. The most common and obvious use ...
Dapper—the open-source and lightweight “micro ORM” I’ve written about often— supports many databases including SQL Server, MySQL, SQLite, SQL CE, and Firebird. By using Dapper in your ...
Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...
SQLite is a simple yet powerful embedded SQL ... How to Sequence Names in MySQL How to Sequence Names in MySQL. Sequences in MySQL help ensure that values aren't... How to Copy a MySQL Database ...
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 ...
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.
SQLite databases can be modified in such a way that they execute malicious code inside other apps that rely on them to store data, security researchers have revealed. In demos presented at the DEF ...