DZone

Introduction to SQLite and Embedded Databases

SQLite is a small, self-contained, client/embedded database written in the C Programming language and can be summarized using the following points:

• Application library.
• Directly writes to disk.
• Cross-platform, stable, and the most widely deployed and used database engine.
• Zero configuration.
• Automatic recovery.
• Public domain license.

In this article, we are going to see many of these features in action. Features such as data replication, network access, etc., are intentionally absent from SQLite since it was built for a much more lightweight use case. SQLite databases are very useful in constrained environments such as mobile devices, lightweight desktop apps, IoT devices, and games.

Source: DZone