Norm
django-silk
| Norm | django-silk | |
|---|---|---|
| 3 | 16 | |
| 22 | 4,257 | |
| - | 0.8% | |
| 0.0 | 7.2 | |
| 10 months ago | about 1 month ago | |
| Python | Python | |
| GNU General Public License v3.0 or later | MIT 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.
Norm
- Show HN: Sqlbind a Python library to compose raw SQL
-
Sketch of a Post-ORM
This is just not liking SQL, which is fine, but it's not 'the future of querying databases'. It's just a simplified language that is under-specified and doesn't really support even a fraction of the use cases of SQL, and therefore looks 'cleaner'. It's a bad abstraction.
Here is my attempt at a 'post orm' if anyone is interested, as a bonus it is fully implemented and some people actually use it: https://github.com/justinvanwinkle/Norm
-
Show HN: Write universally accessible SQL, not library-specific ORM wrapper APIs
I tried to do something similar with https://github.com/justinvanwinkle/Norm about 10 years ago. It hasn't generated a lot of interest, but I find it quite useful to construct queries without having to learn the minutia of an ORM library, or even a SQL generation library.
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
What are some alternatives?
pure-orm - A pure ORM for writing native SQL queries yielding pure business objects
django-debug-toolbar - A configurable set of panels that display various debug information about the current request/response.
pgdbf - Convert XBase / FoxPro databases to PostgreSQL
django-celery - Old Celery integration project for Django
rusqlite-model - Model trait and derive implementation for rusqlite
django-cms - The easy-to-use and developer-friendly enterprise CMS powered by Django
mammoth - A type-safe Postgres query builder for TypeScript.
django-oscar - Domain-driven e-commerce for Django
Hangfire - An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
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.
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
Spirit - Spirit is a modern Python based forum built on top of Django framework