python sqlite3 | SQLite database | python advanced topic
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()
Смотрите видео python sqlite3 | SQLite database | python advanced topic онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Code4You 25 Май 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 314 раз и оно понравилось 9 людям.