I am working on a program that parses a webpage to get its input data. The page some contains information from an SQL database. Unfortunately the webpage was actually made with another goal in mind and as a result is not optimal for my application. Because the data in the database is more complete and better structured I would like to change my program to connect directly to the database.
I think I basically need three steps:
- connect to the database (over the network)
- execute a select query (I have no reason to modify or delete data in the database)
- process the result
While I am convinced this should be possible in C++11, I don't have any idea about how to do this.
I currently use the cUrl library to retrieve the webpage and SQLite for local storage, I hope it can also be helpful for the connection with the database.
Could you please help me get started with this challenge?