What is a DBAPI ?

 DB-API

DB-API


DB-API definition:

- We will sometimes want to interact with our database and use its results in a specific programming language.
 
- To build web applications or data pipelines in a specific language like (Ruby, Python, Javascript, etc.).

- That's where DBAPIs come in.


A DB-API: 

- A DB-API provides a standard for one programming language (like python) to talk to a relational database server.

- Is a low-level library for writing SQL statements that connect to a database. 

- Also known as database adapters.

- Different DBAPIs exist for every server framework or language + database system.

- Database adapters define a standard for using a database (with SQL) and using the results of database queries as input data in the given language.

-- Turn a selected (SELECT * from some_table;) list of rows into an array of objects in Javascript for say a NodeJS adapter; or a list of tuples in Python for a Python adapter.


Examples across languages and server frameworks:

- For Ruby (e.g. for Sinatra, Ruby on Rails): pg.

- For NodeJS: node-Postgres.

- For Python (e.g. for Flask, Django): pyscopg2.

Comments

Post a Comment

Popular posts from this blog

Connections and Sessions in TCP/IP

Image
 Connections and Sessions in TCP/IP TCP/IP is a connection-based protocol: - To start any communication a connection must be arranged. - Open a connection to start communications. - Close a connection to end communications.  - Meaning all communications between parties are arranged over a connection. - A connection is established before any data transmission begins. - Over TCP/IP , we'll always need to establish a connection between clients and servers in order to enable communications.  Moreover: Deliveries over the connection are error-checked, If packets arrive damaged or lost, then they are resent (known as retransmission). It's really important that we continually monitor what connections are opened and closed. between a recipient and sender because the more connection that we have open The more performance-based issues we may run into.  We will always need to establish a connection from a client application to a Postgres server Or MySQL server over TCP/IP in order to int
Read more

What Is Relational Databases

Image
What Is Relational Databases  Definitions : -   A database is a collection of data. -    A database system is a system for storing collections of data in some organized way. -    It uses a structure that allows us to identify and access data  in relation  to another piece of data in the database. -    Often, data in a relational database is organized into tables. What is a Relational Database Management System (RDBMS)? -    A relational database management system (RDBMS) is a program that allows you to create, update, and administer a relational database. -   Most relational database management systems use the SQL language to access the database. What is SQL? - SQL ( S tructured  Q uery  L anguage) is a programming language used to communicate with data stored in a relational database management system. - Every relational database system (PostgreSQL, SQLite, MySQL, etc) has its own "flavor" of SQL it implements. - Because they are not 100% compliant with SQL standa
Read more