About the Author

Paul DuBois is a writer, database administrator, and leader in the Open Source community. He is currently a Senior Technical Writer at MySQL AB. In addition to MySQL, he is also the author of MySQL and Perl for the Web, MySQL Cookbook, Using csh and tcsh, and Software Portability with imake.

We are always looking for interesting articles about MySQL! Have you written something and would like to it published here? Please contact us via feedback form »

Paul DuBois - Writing MySQL Programs Using C

Many web developers view development of C programs as a bit of a black art. Development of programs in a compiled language such as C is vastly different from the development of applications in a scripting language. To familiarize more developers with the MySQL C API, we present a three-part series of articles tailored to developers looking to get into C program development with MySQL. This first article is the full chapter from Paul DuBois' industry-standard work, MySQL, Fourth Edition, from Addison-Wesley. The second article, from Mark Schoonover, to be published next week, will cover development with the C API using the Eclipse CDT to write a sample program. The third article, also from MarkSchoonover, will go into more depth and expand the example program usingmore advanced features of the API.

The chapter covers a lot of ground, covering the following topics:

Starting development with the C API for MySQL
How to write client programs that communicate with the server over secure connnections using the Secure Sockets Layer (SSL) protocol.
How to write applications that use libmysqld, the embedded server library.
How to send multiple statements to the server at once and then process the result sets that come back.
How to use server-side prepared statements.

Comments?

Read and post comments on this article in the MySQL Forums. There are currently 1 comments.