django-silk
django-query-profiler
django-silk | django-query-profiler | |
---|---|---|
16 | 3 | |
4,254 | 129 | |
0.7% | - | |
7.2 | 0.0 | |
28 days ago | over 1 year ago | |
Python | Python | |
MIT License | BSD 3-clause "New" or "Revised" License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
django-silk
-
Show HN: Sqlbind a Python library to compose raw SQL
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
-
Understanding TTFB Latency in DJango - Seems absurdly slow after DB optimizations even locally
you're using DRF, which DDT doesn't work well with. DDT is more for template rendered pages, not API responses. Have you brought in Django silk for monitoring this?
-
The Django ecosystem is not so good
https://github.com/jazzband/django-silk/issues?q=is%3Aopen+is%3Aissue+label%3Abug
-
view fields depend on Enum value in Django admin
Are you using Django-silk? Googling for the error shows https://github.com/jazzband/django-silk/issues/374
-
How to view the number of queries executed in DRF.
Those docs are wrong. They still reference syncdb. Use the README at https://github.com/jazzband/django-silk.
-
Tracking Endpoint Access
Perhaps https://github.com/jazzband/django-silk?
- How can gather info about API Response status per user ?
-
I just updated my deep dive on how to optimize SQL queries with the Django ORM
If you're using Django as an API, without templates, django debug toolbar is useless because it requires templates. It won't work with DRF endpoints which means you miss out on profiling and SQL tracing. That's where django-silk shines.
-
Is there a notable performance difference between getting instance by get.(id=wanted_id) or using foreign key to get instance?
You can also install django-silk to profile your app, and play around with different implementations.
-
3% of 666 Python codebases we checked had a silently failing unit test
https://github.com/ansible-community/ara/pull/358 https://github.com/b12io/orchestra/pull/830 https://github.com/batiste/django-page-cms/pull/210 https://github.com/carpentries/amy/pull/2130 https://github.com/celery/django-celery/pull/612 https://github.com/django-cms/django-cms/pull/7241 https://github.com/django-oscar/django-oscar/pull/3867 https://github.com/esrg-knights/Squire/pull/253https://github.com/Frojd/django-react-templatetags/pull/64 https://github.com/groveco/django-sql-explorer/pull/474 https://github.com/jazzband/django-silk/pull/550 https://github.com/keras-team/keras/pull/16073 https://github.com/ministryofjustice/cla_backend/pull/773 https://github.com/nitely/Spirit/pull/306 https://github.com/python/pythondotorg/pull/1987 https://github.com/rapidpro/rapidpro/pull/1610 https://github.com/ray-project/ray/pull/22396 https://github.com/saltstack/salt/pull/61647 https://github.com/Swiss-Polar-Institute/project-application/pull/483 https://github.com/UEWBot/dipvis/pull/216
django-query-profiler
-
Show HN: Sqlbind a Python library to compose raw SQL
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
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!
-
Optimizing Django ORM SQL Queries
If you are trying to optimize for N+1 queries, django query profiler is another cool profiler. It is very simple to configure (requires changing 3-4 lines in your settings.py file), and works the same way with a chrome plugin and the command line.
What are some alternatives?
django-debug-toolbar - A configurable set of panels that display various debug information about the current request/response.
azure-docs - Open source documentation of Microsoft Azure
django-celery - Old Celery integration project for Django
Django-CRM - Open Source CRM based on Django
django-cms - The easy-to-use and developer-friendly enterprise CMS powered by Django
cryptogalaxy - Get any cryptocurrencies ticker and trade data in real time from multiple exchanges and then save it in multiple storage systems.
django-oscar - Domain-driven e-commerce for Django
django-query-profil
Ray - Ray is a unified framework for scaling AI and Python applications. Ray consists of a core distributed runtime and a set of AI Libraries for accelerating ML workloads.
appmap-intellij-plugin
Spirit - Spirit is a modern Python based forum built on top of Django framework
Protobuf - Protocol Buffers - Google's data interchange format