Can I use MySQL API for C++?

[Rob Dizzle]

I am working on a project which requires the linking of the programing language with the database. I am having better knowledge about the C and C++ programming language. Also I know bit of PHP and Java, but I think I have good knowledge of C/C++. If anyone tell me some API or library files for linking with the programing language will be really grateful for me. Also I want to know that Can I use MySQL API for C++.?? Please help me soon..!!

[Viensterrr]

You can surely use MySQL API for C++ which is known as mysqlcppapi. mysqlcppapi is a C++ wrapper for the MySQL C API library. I would like to tell you the strong points of the MySql++ project :

• Instead of deciding on an interface, MySQL++ provides too many ways to do things which proves as an obscures for the design.
• Speed is the main feature of the MySQL++, you can say that MySQL++ is aggressively optimised for speed. The only thing is that once your design is matured then only optimisation should happen and that should be targeted. Premature optimisation obscures the design and prevents it from improving.
• Also MySQL++ uses preprocessor macros to an extent that is unacceptable in a C++ library.

[void]

There are some new functionality, which are included in library of MySQL++. Some of the functionality are as follows :

1. The FieldInfo::sql() method will prepare a field value for a MySQL query.
2. The FieldInfo class can generate the text needed to create a field in a MySQL query.
3. The Connection can supply a list of tables and the field information for any table.

You can also download this application from the Web.

[CodGuru]

You can use the MySQL C++ Wrapper which is a set of C++ classes for working with the MySQL library. So the answer is you can use MySQL API for C++. Here is the coding for that :

#include "mysqlplus.h"
#include <STDIO.H>

void main()
{
   sql_connection_c connection( "database", 
           "localhost", "root", "mypassword" );
   sql_query_c query( &connection );
   sql_result_c *sql_result = 0;
   if ( !query.execute( "select * from customers" ) )
   {
      printf( "oops... didn't execute!!\n" );
      return;
   }
   sql_result = query.store();
   int n_fields = sql_result->n_fields();
   for ( int idx = 0; idx < n_fields; idx++ )
   {
      sql_field_c sql_field = sql_result->fetch_field( idx );
      printf( "field %d [%s]\n", idx, sql_field.get_name() );
   }
}

[Warner]

I think that for running the program mentioned by the 'CodGuru' you will require the download of MySQL headers and library files. If you want to build your own binary RPMs, then you will have to run the following command as root :

# rpmbuild --rebuild /wherever/it/is/mysql++-3.0.9-1.src.rpm

MySQL++ should work on any platform that has a Standard C++ compiler and the MySQL C API development files. Also MySQL++ works best with MySQL version 4.1 or higher. MySQL++ is free software, licensed under the GNU LGPL. MySQL works out of the box with Visual C++ 2005 and 2008.

[Allan.d]

MySQL builds under Solaris and under Borland C++ Builder. The only major feature that doesn’t work out of the box is the Specialized SQL Structures. It can’t work as-is due to a compiler limitation. To build any program using MySQL++, at minimum you must link to the MySQL++ library and also to the MySQL C API library that MySQL++ is built upon. The current version of MySQL++ has no known memory leaks. In MySQL++, the main user-facing classes are mysqlpp::Connection, mysqlpp::Query, mysqlpp::Row, mysqlpp:toreQueryResult, and mysqlpp::UseQueryResult.