Interacting with databases using SOCI C++ library
It's often the case that applications need to be interacting with databases. All database vendors provide some libraries (which in database world is referred to as drivers) for client applications providing a programming interface.
If you are developing an application in C++ you can choose C or C++ interfaces that library vendors provide. But these interfaces are very different from vendor to vendor. If you want your application to interact with multiple database from different vendors, it becomes very difficult to write your application code. If only a single database is intended then it doesn't matter, you can still use vendor specific libraries.
Microsoft in 1992 introduced ODBC to address this problem. Unfortunately, not all database vendors support ODBC interface. The same issue in Java world is addressed using JDBC specification.
SOCI library gives a consistent interface to work with multiple databases with a clean syntax. It also supports OBDC to work with ODBC supported databases.
In this video I show you how to build and use SOCI to interact with databases from your C++ applications.