Which option to select to use sql in C++
I want to connect and use `sql` database within my `C++` application . My application need to store some data _(can be stored in form of tables)_ which will be growing continuously and need to be shared between different processes - so I need a database. I selected `sql` because it is recommendable for beginners and I need multiple writer so no `SQLite`.   

On searching I found following options _(These options may include ORMS, APIs , and Drivers  and may be some of these options shouldn't be even included - i.e I was totally wrong understanding that option; then please correct me)_:

 1. [SQLAPI++][1] - [Source][2](ALSO OFFICIAL SITE)  
 2. [MySQL Connector/C++][3] (Some advantages are also given there.) - [Source][4]  
 3. [MySQL++][5]
 4. [CppDB][6]  
 5. [SOCI][7]  
 6. [Libodbc++][8] (Runs on top of ODBC)  
 7. [Database Template Library][9] - [Source][10]
 8. [Oracle Template Library][11]
 9. Using sql.h with ODBC:  
      Choices for ODBC:  
       a. [MYSQL Connector/ODBC][12]  
       b. [EasySoft ODBC][13]  
       c. [Some Others][14]  
    
 
Some SO's threads which help me to find these choices: [T1][15],[T2][16], [T3][17], [T4][18].  

__My Questions__:  

 1. _Which_ option to use and _when_? _Advantages/Disadvantages_ of these options? _(May be based on `performance`, `learning curve`, `compatibility`, `present support`.)_ Is there any __benchmark__ or __suggestion__ for selecting among these options. _(I really don't know about these options, so may be some of these options required to group together to make them work i.e may be some of the options are __inter-dependent__.)_   
 2. What are the required set of tools for these options.  
 3. If using any `ODBC` dependent library, then which `ODBC` to use. _(There are many ODBCs mentioned in the link 'Some Others' above.)_
 4. Any source for learning them. _(For some of the options I have already mentioned a source.)_
 5. Is there anything else that I have missed, entirely?
 6. What if my application is in __`C`__? _(This is because I also need to develop an application in C which uses `sql`)_

  [1]: http://www.sqlapi.com/index.html
  [2]: http://www.crazyengineers.com/community/threads/database-connectivity-using-c-c-tutorial.23155/
  [3]: http://dev.mysql.com/doc/refman/5.6/en/connector-cpp.html
  [4]: http://dev.mysql.com/tech-resources/articles/mysql-connector-cpp.html
  [5]: http://tangentsoft.net/mysql++/
  [6]: http://cppcms.com/sql/cppdb/
  [7]: http://soci.sourceforge.net/
  [8]: http://libodbcxx.sourceforge.net/
  [9]: http://dtemplatelib.sourceforge.net/
  [10]: http://www.codeguru.com/cpp/data/data-misc/fileinformation/article.php/c10629/Accessing-Your-Database-with-C-Is-as-Easy-as-DTL.htm
  [11]: http://otl.sourceforge.net/
  [12]: http://dev.mysql.com/downloads/connector/odbc/
  [13]: http://www.easysoft.com/products/data_access/odbc_oracle_driver/index.html
  [14]: http://www.unixodbc.org/
  [15]: http://stackoverflow.com/questions/205802/best-portable-way-to-connect-to-sql-server-using-c
  [16]: http://stackoverflow.com/questions/296205/recommended-c-database-abstraction-layers
  [17]: http://stackoverflow.com/questions/440069/database-access-libraries-for-c
  [18]: http://stackoverflow.com/questions/813296/how-do-i-use-a-database-in-c
Which option to select to use sql in C++
===

I want to connect and use `sql` database within my `C++` application . My application need to store some data _(can be stored in form of tables)_ which will be growing continuously and need to be shared between different processes - so I need a database. I selected `sql` because it is recommendable for beginners and I need multiple writer so no `SQLite`.   

On searching I found following options _(These options may include ORMS, APIs , and Drivers  and may be some of these options shouldn't be even included - i.e I was totally wrong understanding that option; then please correct me)_:

 1. [SQLAPI++][1] - [Source][2](ALSO OFFICIAL SITE)  
 2. [MySQL Connector/C++][3] (Some advantages are also given there.) - [Source][4]  
 3. [MySQL++][5]
 4. [CppDB][6]  
 5. [SOCI][7]  
 6. [Libodbc++][8] (Runs on top of ODBC)  
 7. [Database Template Library][9] - [Source][10]
 8. [Oracle Template Library][11]
 9. Using sql.h with ODBC:  
      Choices for ODBC:  
       a. [MYSQL Connector/ODBC][12]  
       b. [EasySoft ODBC][13]  
       c. [Some Others][14]  
    
 
Some SO's threads which help me to find these choices: [T1][15],[T2][16], [T3][17], [T4][18].  

__My Questions__:  

 1. _Which_ option to use and _when_? _Advantages/Disadvantages_ of these options? _(May be based on `performance`, `learning curve`, `compatibility`, `present support`.)_ Is there any __benchmark__ or __suggestion__ for selecting among these options. _(I really don't know about these options, so may be some of these options required to group together to make them work i.e may be some of the options are __inter-dependent__.)_   
 2. What are the required set of tools for these options.  
 3. If using any `ODBC` dependent library, then which `ODBC` to use. _(There are many ODBCs mentioned in the link 'Some Others' above.)_
 4. Any source for learning them. _(For some of the options I have already mentioned a source.)_
 5. Is there anything else that I have missed, entirely?
 6. What if my application is in __`C`__? _(This is because I also need to develop an application in C which uses `sql`)_

  [1]: http://www.sqlapi.com/index.html
  [2]: http://www.crazyengineers.com/community/threads/database-connectivity-using-c-c-tutorial.23155/
  [3]: http://dev.mysql.com/doc/refman/5.6/en/connector-cpp.html
  [4]: http://dev.mysql.com/tech-resources/articles/mysql-connector-cpp.html
  [5]: http://tangentsoft.net/mysql++/
  [6]: http://cppcms.com/sql/cppdb/
  [7]: http://soci.sourceforge.net/
  [8]: http://libodbcxx.sourceforge.net/
  [9]: http://dtemplatelib.sourceforge.net/
  [10]: http://www.codeguru.com/cpp/data/data-misc/fileinformation/article.php/c10629/Accessing-Your-Database-with-C-Is-as-Easy-as-DTL.htm
  [11]: http://otl.sourceforge.net/
  [12]: http://dev.mysql.com/downloads/connector/odbc/
  [13]: http://www.easysoft.com/products/data_access/odbc_oracle_driver/index.html
  [14]: http://www.unixodbc.org/
  [15]: http://stackoverflow.com/questions/205802/best-portable-way-to-connect-to-sql-server-using-c
  [16]: http://stackoverflow.com/questions/296205/recommended-c-database-abstraction-layers
  [17]: http://stackoverflow.com/questions/440069/database-access-libraries-for-c
  [18]: http://stackoverflow.com/questions/813296/how-do-i-use-a-database-in-c