queries
django-pgtrigger
Our great sponsors
| queries | django-pgtrigger | |
|---|---|---|
| - | 3 | |
| 259 | 508 | |
| - | 1.0% | |
| 0.0 | 6.4 | |
| over 2 years ago | 10 days ago | |
| Python | Python | |
| BSD 3-clause "New" or "Revised" 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.
queries
We haven't tracked posts mentioning queries yet.
Tracking mentions began in Dec 2020.
django-pgtrigger
-
How Postgres Triggers Can Simplify Your Back End Development
For Django there's https://github.com/Opus10/django-pgtrigger that makes it possible to define triggers right in your models, so you have everything in one place.
-
This Week in Python
django-pgtrigger – Write Postgres triggers for your Django models
-
A lightweight alternative to Celery for Django-PostgreSQL apps.
Note that have now ditched our post_save signal from the previous solution. As we pointed out, signals can easily be missed. Instead, we are using a Postgres trigger : defining the listener as it is above makes use of the django-pgtrigger library to write a Postgres trigger to our database, the job of which is to notify our channel whenever a Comment is inserted in to the database. Triggers are far more robust than signals for detecting database write events; application level triggers can easily be missed, whereas triggers will always be executed.
What are some alternatives?
psycopg2 - PostgreSQL database adapter for the Python programming language
asyncpg - A fast PostgreSQL Database Client Library for Python/asyncio.
txpostgres - Twisted wrapper for asynchronous PostgreSQL connections
Python PG Extras - Python PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources
django-pgpubsub - A distributed task processing framework for Django built on top of the Postgres NOTIFY/LISTEN protocol.
redis-search-django - Django package that provides auto indexing and searching capabilities for Django model instances using RediSearch.