hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing and 0-compatible drivers out there, such as pymysql or psycopg2 for MySQL and Postgres respectively. Cython [http://cython.org/]: used for various speedups. Can give a big boost to certain operations, particularly and much, much saner semantics than the standard library pysqlite. Use with APSWDatabase. pycrypto [http://pythonhosted.org/pycrypto/] is used for the AESEncryptedField. bcrypt module is used for the PasswordField

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing and 0-compatible drivers out there, such as pymysql or psycopg2 for MySQL and Postgres respectively. Cython [http://cython.org/]: used for various speedups. Can give a big boost to certain operations, particularly pysqlite. Use with APSWDatabase. gevent [http://www.gevent.org/] is an optional dependency for SqliteQueueDatabase (though it works with threading just fine). BerkeleyDB [http://www.oracle.com/technetwork/database/database-

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing and 0-compatible drivers out there, such as pymysql or psycopg2 for MySQL and Postgres respectively. Cython [http://cython.org/]: used for various speedups. Can give a big boost to certain operations, particularly APIs. Use with APSWDatabase. gevent [http://www.gevent.org/] is an optional dependency for SqliteQueueDatabase (though it works with threading just fine). BerkeleyDB [http://www.oracle.com/technetwork/database/database-

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing and 0-compatible drivers out there, such as pymysql or psycopg2 for MySQL and Postgres respectively. Cython [http://cython.org/]: used for various speedups. Can give a big boost to certain operations, particularly pysqlite. Use with APSWDatabase. gevent [http://www.gevent.org/] is an optional dependency for SqliteQueueDatabase (though it works with threading just fine). BerkeleyDB [http://www.oracle.com/technetwork/database/database-

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing and 0-compatible drivers out there, such as pymysql or psycopg2 for MySQL and Postgres respectively. Cython [http://cython.org/]: used for various speedups. Can give a big boost to certain operations, particularly provides the same functionality. gevent [http://www.gevent.org/] is an optional dependency for SqliteQueueDatabase (though it works with threading just fine). BerkeleyDB [http://www.oracle.com/technetwork/database/database-

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing and 0-compatible drivers out there, such as pymysql or psycopg2 for MySQL and Postgres respectively. Cython [http://cython.org/]: used for various speedups. Can give a big boost to certain operations, particularly provides the same functionality. gevent [http://www.gevent.org/] is an optional dependency for SqliteQueueDatabase (though it works with threading just fine). BerkeleyDB [http://www.oracle.com/technetwork/database/database-

support for special extensions like hstore [http://peewee.readthedocs.org/en/latest/peewee/playhouse.html#postgresql-extensions-hstore-ltree] and full-text search [http://peewee.readthedocs.org/en/latest/peewee/playhouse 1.2. index next | previous | peewee 1.0.0 documentation » Overview peewee is a lightweight ORM [http://en.wikipedia.org/wiki/Object-relational_mapping] written in python. Examples: # a simple query peewee 1.0.0 documentation » Example app peewee ships with an example web app that runs on the Flask [http://flask.pocoo.org/] microframework. If you already have flask and its dependencies installed you should

1.3. index next | previous | peewee 0.9.7 documentation » Overview peewee is a lightweight ORM [http://en.wikipedia.org/wiki/Object-relational_mapping] written in python. Examples: # a simple query peewee 0.9.7 documentation » Example app peewee ships with an example web app that runs on the Flask [http://flask.pocoo.org/] microframework. If you already have flask and its dependencies installed you should to_user=user ).count() > 0 def gravatar_url(self, size=80): return 'http://www.gravatar.com/avatar/%s? d=identicon&s=%d' % \ (md5(self.email.strip().lower().encode('utf-

and execute the run_example.py script: python run_example.py The example app will be accessible at http://localhost:5000/ 10 Chapter 1. Contents: peewee Documentation, Release 2.10.2 1.3.2 Diving into associated with a given User instance: >>> for tweet in user.tweets: ... print tweet.message ... http://www.youtube.com/watch?v=xdhLQCYQ-nQ Under the hood, the tweets attribute is just a SelectQuery driver against BerkeleyDB’s sqlite replacement. Begin by downloading and compiling BerkeleyDB: wget http://download.oracle.com/berkeley-db/db-6.0.30.tar.gz tar xzf db-6.0.30.tar.gz cd db-6.0.30/build_unix

and execute the run_example.py script: python run_example.py The example app will be accessible at http://localhost:5000/ 1.3.2 Diving into the code For simplicity all example code is contained within list of PRAGMA settings, their meaning and accepted values can be found in the SQLite documentation: http://sqlite.org/pragma.html User-defined functions SQLite can be extended with user-defined Python how to run tests using Peewee, check out Peewee’s own test-suite. 1.5.11 Async with Gevent gevent <http://www.gevent.org/> is recommended for doing asynchronous i/o with Postgresql or MySQL. Reasons I prefer