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 numerous extensions available (postgres Django Integration Fields Generic foreign keys Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL CSV Utils Connection pool Read If you wish to also build the SQLite Cython extension, you must manually run: python setup.py build_sqlite_ext python setup.py install Installing with git The project is hosted at https://github.com/coleifer/peewee

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 • numerous extensions available (postgres If you wish to also build the SQLite Cython extension, you must manually run: python setup.py build_sqlite_ext python setup.py install 1.1.1 Installing with git The project is hosted at https://github com/coleifer/peewee and can be installed using git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install If you would like to build the SQLite extension in a git checkout, you can run:

documentation » peewee a small orm written in python provides a lightweight querying interface over sql uses sql concepts when querying, like joins and where clauses support for special extensions like hstore [http://peewee an advanced sqlite driver Postgresql Extensions (hstore, ltree) pwiz, a model generator Signal support Sqlite Extensions Swee’pea, syntactic sugar for peewee Indices and tables Index Module Index Search peewee is a lightweight ORM [http://en.wikipedia.org/wiki/Object-relational_mapping] written in python. Examples: # a simple query selecting a user User.get(username='charles') # get the staff and

and intuitive to use. A small, expressive ORM Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL Connection pool Test Utils Flask git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note On some systems you may need to use sudo python setup.py install to install peewee system-wide. If you would

and intuitive to use. A small, expressive ORM Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL Connection pool Test Utils Flask git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note On some systems you may need to use sudo python setup.py install to install peewee system-wide. If you would

(but expressive) concepts, making it easy to learn and intuitive to use. a small, expressive ORM python 2.7+ and 3.4+ (developed with 3.6) supports sqlite, mysql and postgresql tons of extensions Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL Connection pool Test Utils Flask git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note On some systems you may need to use sudo python setup.py install to install peewee system-wide. If you would

0.0 • a small orm • written in python • provides a lightweight querying interface over sql • uses sql concepts when querying, like joins and where clauses • support for special extensions like hstore 1.0.0 2 CONTENTS CHAPTER ONE CONTENTS: 1.1 Overview peewee is a lightweight ORM written in python. Examples: # a simple query selecting a user User.get(username=’charles’) # get the staff and filter(Q(user__is_staff=True) | Q(user__is_superuser=True)) 3 peewee Documentation, Release 1.0.0 You can use python operators to create select queries: # how many active users are there? User.select().where(User

intuitive to use. • A small, expressive ORM • Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) • Built-in support for SQLite, MySQL and Postgresql. • numerous extensions git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. If you would alongside other modules. python setup.py build_ext -i 3 peewee Documentation, Release 3.5.0 1.1.2 Running tests You can test your installation by running the test suite. python runtests.py You can test

easy to learn and intuitive to use. A small, expressive ORM Written in python with support for versions 2.7+ and 3.2+. Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres driver Sqlcipher backend Postgresql Extensions DataSet Fields Hybrid Attributes Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL Connection pool Test Utils Flask git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note On some systems you may need to use sudo python setup.py install to install peewee system-wide. If you would

intuitive to use. • A small, expressive ORM • Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) • Built-in support for SQLite, MySQL and Postgresql. • numerous extensions git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. If you would alongside other modules. python setup.py build_ext -i 3 peewee Documentation, Release 3.4.0 1.1.2 Running tests You can test your installation by running the test suite. python runtests.py You can test