python sqlite3 | SQLite database | python advanced topic

Publié le: 25 mai 2021
sur la chaîne: Code4You

370

Filename extension : .sqlite3, .sqlite, .db

Python module :
https://docs.python.org/3/library/sql...
https://docs.python.org/2/library/sql...

https://en.wikipedia.org/wiki/SQLite

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.

https://www.sqlite.org/index.html

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
db_file = "mydb.db"

db = sqlite3.connect(db_file)
sql_conn = db.cursor()

sql_conn.execute('select * from student')
tab_data = sql_conn.fetchall()
print(tab_data)

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

db.close()

Sur cette page du site, vous pouvez voir la vidéo en ligne python sqlite3 | SQLite database | python advanced topic durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Code4You 25 mai 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 370 fois et il a aimé 9 téléspectateurs. Bon visionnage!

682