django-query-profil

By django-query-profiler

Django-query-profil Alternatives

Similar projects and alternatives to django-query-profil

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better django-query-profil alternative or higher similarity.

django-query-profil reviews and mentions

Posts with mentions or reviews of django-query-profil. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-02-26.
  • Show HN: Sqlbind a Python library to compose raw SQL
    7 projects | news.ycombinator.com | 26 Feb 2024
    But that's still not backend-specific SQL?

    There should be an interface method for this. Why does psycopg call it mogrify?

    https://django-debug-toolbar.readthedocs.io/en/latest/panels... :

    > debug_toolbar.panels.sql.SQLPanel: SQL queries including time to execute and links to EXPLAIN each query

    But debug toolbars mostly don't work with APIs.

    https://github.com/django-query-profiler/django-query-profil... :

    > Django query profiler - one profiler to rule them all. Shows queries, detects N+1 and gives recommendations on how to resolve them

    https://github.com/jazzband/django-silk :

    > Silk is a live profiling and inspection tool for the Django framework. Silk intercepts and stores HTTP requests and database queries before presenting them in a user interface for further inspection

  • My £4 a month server can handle 4.2M requests a day
    6 projects | news.ycombinator.com | 7 Sep 2021
    I agree that this stuff can definitely be handled better.

    https://github.com/django-query-profiler/django-query-profil... has a neat option for detecting likely N+1 queries. I usually use the Django Debug Toolbar for this.

    Django's ".only()" method lets you specify just the columns you want to retrieve - with the downside that any additional property access can trigger another SQL query. I thought I'd seen code somewhere that can turn those into errors but I'm failing to dig it up again now.

    I've used the assertNumQueries() assertion in tests to guard against future changes that accidentally increase the number of queries being made without me intending that.

    The points you raise are valid, but there are various levels of mitigations for them. Always room for improvement though!

Stats

Basic django-query-profil repo stats
2
-
-
-

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com