Database Systems with SQL - Full Course - Database Systems - MySQL APIs for Programming Languages - JDBC DB-API ODBC PDO APO.NET API

An application programming interface is a connection between computers or between computer programs. It is a type of software interface, offering a service to other pieces of software. A document or standard that describes how to build such a connection or interface is called an API specification. JDBC as the database API for Java, DB-API is the database API for python. MySQL connectors implement APIs between a MySQL database and popular programming languages. Features Although there are many database APIs, they do have some similar features: Connection management Preparing queries Executing queries with single/multi-row results Call stored procedures Architecture API developers implement database APIs in programming language source code. There are two layers to the API: driver - connects directly to the database. driver manager - connects the application to the driver. Besides relational databases, there are also database APIs for non-relational data such as data from a CSV file or Excel spreadsheet. A different driver is typically required for each data source types. Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!