Recently in the development of video, wherein the video device access Management Server, streaming media Management Server, central server are involved in the operation of the database, but also need to be compatible with most versions of the database, including MySQL, SQLite, Oracle. The company used ADO to develop the database, but in view of the current need to be compatible with Linux, it is currently being developed using POCO framework-encapsulated database modules. According to the project I have made a simple study of the three frameworks of Soci, Litesql and Poco to determine which framework to choose. 1.socisoci is a C + + database access class library that currently supports MySQL, Oracle, PostgreSQL, SQLite, MS SQL, FireBird. Soci Github:https://github.com/soci/socisoci website:http:// Soci.sourceforge.netsoci is a need to download the source code after compiling the library, the compilation method can be see the source of the Doc folder under the installation.html file. Compilation considerations can be see blog http://blog.csdn.net/fengshuiyue/article/details/22164159 is a part of installation in the compiled content: 2. Litesqllitesql is a C + + database persistence framework that supports SQLITE3, MySQL, Postgresql;litesql is a C + + ORM (Object Relational mapping) Operational database Framework Litesql website:http:/ /sourceforge.net/apps/trac/litesql/ Note: Litesql vs. Soci A.litesql is an ORM framework. In general, the database information is written to XML in the given format, and the. cpp,. h files are generated using the tools provided with Litesql. SOCI is a layer of encapsulation of SQL access with a generic algorithm. The database operation needs to be done by writing SQL statements. B.litesql does not support access, SQL Server, SOCI supports ODBC, so SOCI supports a series of related things under Ms. C.litesql needs learning costs, and it's not easy for beginners to debug based on project situation, I initially chose Soci, but soci related documents are very few, different versions of SOCI estimate the way to generate dynamic link library is not very consistent, the generation of dynamic link library is not very convenient, So gave up the soci 3.Poco is actually a C + + library, similar to boost, but better than boost encapsulation, introduced in this section of Poco, because the final choice is to use POCO database operations to access the class library (SQLite, Mysql, ODBC) for database development. Poco database access class libraries refer to SOCI, but there are more documents to learn than SOCI, and it is easy to generate various versions of LIB files. Poco Website:http://www.libpoco.com/poco Documentation: http://www.libpoco.com/site/info/is an overview of the Poco library, We operate the database using the data interface in the red box and the MySQL, SQLite, ODBC Module for development.
Soci, Litesql, Poco database access class library comparison
