support for versions 2.6+ and 3.2+. built-in support for sqlite, mysql and postgresql numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more) Questions Managing your Database Creating a database connection and tables Using Postgresql Using SQLite Using BerkeleyDB Using MySQL Connecting using a Database URL Multi-threaded applications Run-time transaction Autocommit Mode Playhouse, extensions to Peewee Sqlite Extensions SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver BerkeleyDB backend Sqlcipher backend Postgresql Extensions

7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more) Installing and Testing Installing with git Running tests Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working examples Contributing Patches Bugs Questions Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining

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 Peewee’s source code hosted on GitHub [https://github Installing and Testing Installing with git Running tests Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working examples Contributing Patches Bugs Questions Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining

7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more) Installing and Testing Installing with git Running tests Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working Subqueries Modifying Data Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining

7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more) Subqueries Modifying Data Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining Constants and Helpers SQLite Extensions Getting started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend

support for versions 2.7+ and 3.2+. Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more) Subqueries Modifying Data Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining Constants and Helpers SQLite Extensions Getting started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend

Playhouse, a collection of addons apsw, an advanced sqlite driver Postgresql Extensions (hstore, ltree) pwiz, a model generator Signal support Sqlite Extensions Swee’pea, syntactic sugar for peewee Indices specify a database in a model class (or its parent class), otherwise peewee will fall back to a default sqlite database named “peewee.db”. Using with Postgresql Point models at an instance of PostgresqlDatabase applications Some database engines may not allow a connection to be shared across threads, notably sqlite. If you would like peewee to maintain a single connection per-thread, instantiate your database with

Implementing API Exceptions Using URL Processors Deploying with Setuptools Deploying with Fabric Using SQLite 3 with Flask SQLAlchemy in Flask Uploading Files Caching View Decorators Form Validation with WTForms can store information for your own needs, check the documentation of that object (g) and the Using SQLite 3 with Flask for more information. Accessing Request Data For web applications it’s crucial to config.from_mapping( SECRET_KEY='dev', DATABASE=os.path.join(app.instance_path, 'flaskr.sqlite'), ) if test_config is None: # load the instance config, if it exists, when not testing

Settings Frequently Asked Questions Databases General notes PostgreSQL notes MariaDB notes MySQL notes SQLite notes Oracle notes Subclassing the built-in database backends Using a 3rd-party database backend version can I use with Django? for details. Python includes a lightweight database called SQLite [https://www.sqlite.org/] so you won’t need to set up a database just yet. Get the latest version of Python By default, the DATABASES configuration uses SQLite. If you’re new to databases, or you’re just interested in trying Django, this is the easiest choice. SQLite is included in Python, so you won’t need to

Settings Frequently Asked Questions Databases General notes PostgreSQL notes MariaDB notes MySQL notes SQLite notes Oracle notes Subclassing the built-in database backends Using a 3rd-party database backend version can I use with Django? for details. Python includes a lightweight database called SQLite [https://www.sqlite.org/] so you won’t need to set up a database just yet. Get the latest version of Python By default, the DATABASES configuration uses SQLite. If you’re new to databases, or you’re just interested in trying Django, this is the easiest choice. SQLite is included in Python, so you won’t need to