python sqlite3 | SQLite database | python advanced topic

Veröffentlicht am: 25 Mai 2021
auf dem Kanal: 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()

Auf dieser Seite können Sie das Online-Video python sqlite3 | SQLite database | python advanced topic mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Code4You 25 Mai 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 370 Mal angesehen und es wurde von 9 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

13,343

456