Introduction to pysqlite A crash course to accessing SQLite from within

pysqlite - A small, simple and fast database engine for your Python applications.
Gerhard Häring gh@ghaering.de - Python, Web- and database development.
Introduction to pysqlite
A crash course to accessing SQLite from within
your Python programs.
Based on pysqlite 2.0.
pysqlite - A small, simple and fast database engine for your Python applications.
Gerhard Häring gh@ghaering.de - Python, Web- and database development.
SQLite basics
SQLite is embedded, there is no server
Each SQLite database is stored in one file
SQLite supports in-memory databases, too
pysqlite - A small, simple and fast database engine for your Python applications.
Gerhard Häring gh@ghaering.de - Python, Web- and database development.
SQLite basics (2)
SQLite supports the following types
TEXT
INTEGER
FLOAT
BLOB
NULL
pysqlite - A small, simple and fast database engine for your Python applications.
Gerhard Häring gh@ghaering.de - Python, Web- and database development.
SQLite basics (3)
INTEGER
TEXT
FLOAT
BLOB
NULL
int
unicode
float
buffer
None
Type conversions from SQLite to Python
pysqlite - A small, simple and fast database engine for your Python applications.
Gerhard Häring gh@ghaering.de - Python, Web- and database development.
Import the module
from pysqlite2 import dbapi2 as sqlite
1 / 19 100%
La catégorie de ce document est-elle correcte?
Merci pour votre participation!

Faire une suggestion

Avez-vous trouvé des erreurs dans linterface ou les textes ? Ou savez-vous comment améliorer linterface utilisateur de StudyLib ? Nhésitez pas à envoyer vos suggestions. Cest très important pour nous !