SQLite
SQLite is a small, fast, embeddable SQL database engine that supports by most of SQL92. It supports transactions with atomic commit and rollback, subqueries, compound queries, triggers, and views. The configuration part is so simple that no setup or administration needed.
To say more about it’s features like the transactions are atomic, consistent, isolated and durable (ACID) even after system crashes and power failures. A complete database is stored in a single cross-platform disk file. The native C/C++ API is simple and easy to use. It is faster than popular client/server database engines for most common operations. Database files can be freely shared between machines with different byte orders and bindings for other languages are also available. Customization of the database is easy as source code is easily available and well commented.