Tntdb

Tntdb is a c++-class-library designed to provide easy and efficient access to various databases. Its interface is independent of any specific database, and driver classes load dynamically. The primary objective of Tntdb is to provide convenience to its users in accessing databases. Moreover, you do not have to worry about resource leakage, as Tntdb automatically deallocates any objects used directly that are allocated on the stack when they go out of scope.

Tntdb provides interface objects that act as a wrapper to reference counted instances, facilitating their copying at your discretion. It is worth noting that when an object goes out of scope, all its resources are appropriately freed. Furthermore, error handling is exclusively done with exception handling, and all exceptions are derived from std::exception. By using the try-catch statements, you can have full error handling.

Where possible, Tntdb leverages the advantages of STL, and in areas where STL is not feasible, Tntdb provides STL-inspired and compatible interfaces. Tntdb is suitable for application programming, but it is not a generic database tool. It does not provide schemaquery or any other feature that allows you to know how your tables look like. Therefore, it is essential to have an idea of your table's structure before using it for normal applications.

For database access, you use SQL, and Tntdb does not provide any wrapper classes like active result sets or databound controls. Instead, it offers you better control over the database, and you can utilize any SQL tricks you know to optimize your database. Furthermore, Tntdb serves as a thin wrapper, ensuring a minimal performance penalty compared to direct access to the C-API.

The project started several years ago as a PostgreSQL-wrapper, and later a SQLite-3-wrapper was added. Currently, Tntdb offers a working MySQL and PostgreSQL driver class. Although the SQLite-3-wrapper is included in the project, it is still in its early design study phase and not dynamically loaded like other drivers. The public headers include documentation that can be generated using Doxygen, while the demo-directory features some small examples.

In conclusion, Tntdb provides a flexible, efficient, and easy-to-use database interface for application programming. Its interface is independent of specific databases, and errors are easily handled through exception handling. Although it does not offer generic database tools, it allows you to utilize SQL and access your database more efficiently.