python sqlite3 | SQLite database | python advanced topic

Filename extension : .sqlite3, .sqlite, .db

Python module :

SQLite is a relational database management system (RDBMS) contained in a C library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.
SQLite generally follows PostgreSQL syntax. SQLite uses a dynamically and weakly typed SQL syntax that does not guarantee the domain integrity.

Initial release 17 August 2000; 20 years ago
Developer(s) D. Richard Hipp

D. Richard Hipp designed SQLite in the spring of 2000 while working for General Dynamics on contract with the United States Navy

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day
The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through the year 2050.

Example code:

import sqlite3

# print(tab_data)

for id, name in tab_data:
print('{0} {1}'.format(id, name))