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 database configuration configuration Dynamically defining a database Connection Pooling Read Slaves Schema migrations Generating Models from Existing Databases Adding Request Hooks Additional connection initialization Advanced Connection Connection Management Using multiple databases Database Errors Automatic Reconnect Logging queries Generating skeleton code Adding a new Database Driver Models and Fields Fields Creating model tables

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 1.6 Managing your Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 1.7 Models py test # Or use the test runner: python runtests.py You can test specific features or specific database drivers using the runtests.py script. By default the test suite is run using SQLite and the playhouse support. You can test by running import sqlite3 in the Python console. If you wish to use another database, there are many DB-API 2.0-compatible drivers out there, such as pymysql or psycopg2 for MySQL and

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

. . . . . . . . . . . . . . . . . . . . . . . . . . 598 4.12 Integrating Django with a legacy database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 598 4.13 Outputting CSV with Django Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 609 4.19 Writing database migrations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 610 5 Advanced: Managers | Raw SQL | Transactions | Aggregation | Search | Custom fields | Multiple databases | Custom lookups | Query Expressions | Conditional Expressions | Database Functions • Other: Supported

tests Optional dependencies Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the example Diving into the code Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining a database Connection Management Connection Pooling Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

the database Working with existing databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Database Initializing a Database Using Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications with Gevent Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and