. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.3 Example app . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . extensions Peewee’s source code hosted on GitHub. New to peewee? These may help: • Quickstart • Example twitter app • Models and fields • Querying • Relationships and joins Contents 1 peewee Documentation 'pets') # prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Once again we’ve run into a classic example of N+1 query behavior. In this case, we’re executing an additional query for every Person returned

hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? These may help: Quickstart Example twitter app Models and fields Querying Relationships and joins Contents: Installing and Testing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Database 'pets') # prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Once again we’ve run into a classic example of N+1 query behavior. In this case, we’re executing an additional query for every Person returned

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.3 Example app . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . guide covers all the bare essentials. It will take you between 5 and 10 minutes to go through it. • Example queries taken from the PostgreSQL exercises website. • Guide to the various query operators describes 'pets') # prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Once again we’ve run into a classic example of N+1 query behavior. In this case, we’re executing an additional query for every Person returned

guide covers all the bare essentials. It will take you between 5 and 10 minutes to go through it. Example queries taken from the PostgreSQL exercises website [https://pgexercises.com]. Guide to the various data Retrieving Data Closing the database Working with existing databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Query Examples 'pets') # prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Once again we’ve run into a classic example of N+1 query behavior. In this case, we’re executing an additional query for every Person returned

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.3 Example app . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . guide covers all the bare essentials. It will take you between 5 and 10 minutes to go through it. • Example Twitter app written using Flask framework. • Guide to the various query operators describes how 'pets') # prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Once again we’ve run into a classic example of N+1 query behavior. In this case, we’re executing an additional query for every Person returned

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.3 Example app . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . guide covers all the bare essentials. It will take you between 5 and 10 minutes to go through it. • Example queries taken from the PostgreSQL exercises website. • Guide to the various query operators describes 'pets') # prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Once again we’ve run into a classic example of N+1 query behavior. In this case, we’re executing an additional query for every Person returned

guide covers all the bare essentials. It will take you between 5 and 10 minutes to go through it. Example Twitter app written using Flask framework. Guide to the various query operators describes how to data Retrieving Data Closing the database Working with existing databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Database 'pets') # prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Once again we’ve run into a classic example of N+1 query behavior. In this case, we’re executing an additional query for every Person returned

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.3 Example app . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . cat Fido dog Grandma L. 0 pets Herb 1 pets Mittens Jr cat Once again we’ve run into a classic example of N+1 query behavior. We can avoid this by performing a JOIN and aggregating the records: >>> subquery want to look at a full web-app, check out the Example app. 1.3 Example app We’ll be building a simple twitter-like site. The source code for the example can be found in the examples/ twitter directory

guide covers all the bare essentials. It will take you between 5 and 10 minutes to go through it. Example queries taken from the PostgreSQL exercises website [https://pgexercises.com]. Guide to the various data Retrieving Data Closing the database Working with existing databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Query Examples 'pets') # prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Once again we’ve run into a classic example of N+1 query behavior. In this case, we’re executing an additional query for every Person returned

Definition Storing data Retrieving Data Working with existing databases What next? Example app Running the example Diving into the code More examples Additional Resources Contributing Patches Bugs Fido dog Grandma L. 0 pets Herb 1 pets Mittens Jr cat Once again we’ve run into a classic example of N+1 query behavior. We can avoid this by performing a JOIN and aggregating the records: >>> subquery you want to look at a full web-app, check out the Example app. Example app We’ll be building a simple twitter-like site. The source code for the example can be found in the examples/twitter directory.