python sqlite3 | SQLite database | python advanced topic

Pubblicato il: 25 maggio 2021
sul canale di: 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()

In questa pagina del sito puoi guardare il video online python sqlite3 | SQLite database | python advanced topic della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Code4You 25 maggio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 370 volte e gli è piaciuto 9 spettatori. Buona visione!

682