wiki:Notes/PythonSQLite

Python SQLite

See SQLite

http://pymotw.com/2/sqlite3/

https://docs.python.org/2/library/sqlite3.html

http://www.pythoncentral.io/series/python-sqlite-database-tutorial/

http://sebastianraschka.com/Articles/2014_sqlite_in_python_tutorial.html

http://zetcode.com/db/sqlitepythontutorial/

PySQLite

https://github.com/ghaering/pysqlite

Python DB-API module for SQLite 3.

https://pysqlite.readthedocs.org/en/latest/sqlite3.html

SQLAlchemy

The ( almost ) one and only ...

http://www.sqlalchemy.org/

http://docs.sqlalchemy.org/en/latest/dialects/sqlite.html

http://docs.sqlalchemy.org/en/rel_1_0/

http://www.aosabook.org/en/sqlalchemy.html

http://mapfish.org/doc/tutorials/sqlalchemy.html

http://www.pythoncentral.io/series/python-sqlalchemy-database-tutorial/

http://www.rmunn.com/sqlalchemy-tutorial/tutorial.html

Peewee

http://docs.peewee-orm.com/en/latest/

Peewee is a simple and small ORM. It has few (but expressive) concepts, making it easy to learn and intuitive to use.

A small, expressive ORM
Written in python with support for versions 2.6+ and 3.2+.
built-in support for sqlite, mysql and postgresql
tons of extensions available in the Playhouse, a collection of addons (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more).

http://docs.peewee-orm.com/en/latest/peewee/playhouse.html#playhouse

The playhouse includes modules for different database drivers or database specific functionality:

apsw, an advanced sqlite driver
Postgresql Extensions
Sqlite Extensions
BerkeleyDB backend
Sqlcipher backend

http://docs.peewee-orm.com/en/latest/peewee/playhouse.html#schema-migrations

https://github.com/coleifer/peewee

APSW

https://github.com/rogerbinns/apsw

APSW stands for Another Python SQLite Wrapper.

Full Text Search

https://charlesleifer.com/blog/using-sqlite-full-text-search-with-python/

https://charlesleifer.com/blog/saturday-morning-hacks-adding-full-text-search-to-the-flask-note-taking-app/

https://charlesleifer.com/blog/extending-sqlite-with-python/

https://github.com/coleifer/scout

scout is a RESTful search server written in Python. The search is powered by SQLite's full-text search extension, and the web application utilizes the Flask framework.

https://github.com/coleifer/scout/#dependencies

http://scout.readthedocs.org/en/latest/

Issues

Triggers - http://justatheory.com/computers/databases/sqlite/foreign_key_triggers.html

Also See

SQLite

Last modified 23 months ago Last modified on 06/20/2015 11:25:00 AM