Chapter 12. ODBC
On the Web, the www.sourceforge.net site hosts about 30 myriads of open source projects. One day we extracted the projects in sourceforge's category “DBMS Front End” and looked to see what the vendors were using to communicate with the DBMS engine. Table 12-1 shows the results.
As you can see, Table 12-1 shows that, as an API for DBMSs, ODBC is the clear leader. It's been #1 since Microsoft brought out ODBC 1.0 in August 1992. The other APIs (especially JDBC) have their niches, and we'll certainly talk about them later in this book. But in any discussion of database programming, the ODBC API should get pride of place, and that's what we'll talk about in this chapter.
Table 12-1. APIs Used by DBMSs
| API | Number of Projects |
|---|---|
| ODBC | 62 ... |
Get SQL Performance Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
