Home / Questions / 72902
Accepted
Jogofus
Asked: 2020-05-25 15:21:51 +0800 CST 2020-05-25 15:21:51 +0800 CST

Database connection from C++

  • 772

I am trying to study how to connect a program (in terminal) in C++ with a database. At first it doesn't matter what type of database it is (if MySQL, .mdb). I've searched everywhere and can't find a solution. What I see the most is how to connect it through visual studio, and I don't use it for anything, only Sublime. Where can I find any reference/guide/documentation about this?

c++

2 Answers

  1. Best Answer

    The C++ standard does not currently provide any standard mechanism for accessing databases. It is for this reason that to cover this feature you need to resort to third-party libraries (or program your own system).

    To access the databases you have at your disposal a multitude of libraries, each one with its advantages and disadvantages:

    • Specific drivers: Normally, each database server makes a library available to programmers that allows them to connect with their engine. These libraries can be based on ODBC, COM or SQL although they do not have that obligation and can provide a free interface. The main disadvantage of this system is that you need to purchase a driver for each type of database you want to connect to (MySql, PostgreSql, SQLite, ...)
    • Third-party libraries: These libraries usually present a homogeneous interface for access to different databases. Normally these interfaces are mounted on the drivers mentioned in the previous point. An example can be found in the Qt library, which offers an interface that allows you to connect to any database... yes, it only provides you with a limited set of drivers (see previous section).
    • 1

  2. You could do it with sqlite, it's much easier since it's a file.

    https://www.sqlite.org/cintro.html

    Cheers,

    • -1