Ban 1+N in Django

1. django-zen-queries

   1 4 373 1.5 Python

   Explicit control over database query execution in Django applications

   

   See also django-zen-queries https://github.com/dabapps/django-zen-queries , which can make it impossible for changes to a template to trigger queries.

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. haxl

   2 11 4,305 4.1 Haskell

   A Haskell library that simplifies access to remote data, such as databases or web-based services.

   

   +1. The JS event loop auto-monad-izing Promises into Haxl [1]-esqe trees of implicitly-batched loads has been a big win for us building on JavaScript/TypeScript.

   If I had to move to another language, I'd really want to find a "powered by the event loop / dataloader" framework, i.e. Vert.x for Java.

   Also, per dataloader, a shameless plug for our ORM that has dataloader de-N+1-ing built natively into all object graph traversals:

   https://joist-orm.io/docs/goals/avoiding-n-plus-1s

   [1]: https://github.com/facebook/Haxl

4. funcy

   3 5 3,431 5.2 Python

   A fancy and practical functional tools

   

   On an unrelated note, Python folks should check out OP's library funcy [1]: "A collection of fancy functional tools focused on practicality. Inspired by clojure, underscore and my own abstractions."

   Thanks for the library Suor!

   [1] https://github.com/Suor/funcy

5. bullet

   4 32 7,222 8.4 Ruby

   help to kill N+1 queries and unused eager loading

   

   Rails has Bullet[0] to help identify and warn you against N+1

   Does Django have anything active? Quick search revealed nplusone[1] but its been dead since 2018.

   [0] https://github.com/flyerhzm/bullet

   [1] https://github.com/jmcarp/nplusone

6. nplusone

   5 2 1,033 0.0 Python

   Auto-detecting the n+1 queries problem in Python

   

   Rails has Bullet[0] to help identify and warn you against N+1

   Does Django have anything active? Quick search revealed nplusone[1] but its been dead since 2018.

   [0] https://github.com/flyerhzm/bullet

   [1] https://github.com/jmcarp/nplusone

7. django-cacheops

   6 7 2,204 6.4 Python

   A slick ORM cache with automatic granular event-driven invalidation.

   

   Here is an example of such thing https://github.com/Suor/django-cacheops/blob/8b3a79de29b2545...

8. django-orm-plus

   7 1 3 10.0 Python

   

   I was working on a library to do this which I never got around to fully finishing but the idea is there: https://github.com/lime-green/django-orm-plus I think all I had left was polishing the auto add logic and testing with a real project

9. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

10. pellet

    8 2 79 2.7 Python

    Pellet helps improve your Django app performance by discovering N+1 queries. (by har777)

    

    Self plug: Checkout https://github.com/har777/pellet to easily find and fix django N+1 issues.

    I usually add it to existing integration tests so that they raise exceptions on N+1. If test coverage is low then I would suggest sending the N+1 metrics to something like datadog. That way your users using the product will reveal all the N+1 issues on your monitoring solution.

11. django-auto-prefetching

    9 1 231 4.6 Python

    Automatic prefetching for Django

    

    Shameless plug - I ran into this while developing REST interfaces with Django and built django-auto-prefetching: https://github.com/GeeWee/django-auto-prefetching

    It essentially travels your DRF serializer tree and builds an auto-prefetched query automatically without you needing to do any work.

    Back when I still worked actively on it, I wanted to monkey-patch models to track whether or not n+1 was happening, and if it was, automatically do pre-fetching, so instead of an n+1 problem you'd end up with just a "3-4 queries when it could've been 1" problem - which is much more palatable. Never got around to that part though.

12. django-seal

    10 2 266 5.9 Python

    Django application providing queryset sealing capability.

    

    If I understand it correctly, that's what [django-seal](https://github.com/charettes/django-seal) does.

Suggest a related project