<h2>Overview</h2>
<p>django-pgtrigger is a tool that helps users write Postgres triggers for Django models. Triggers can be used to solve complex problems more reliably, performantly, and succinctly than using application code. This tool offers several features that make it easier to implement triggers in Django models.</p>
<h2>Features</h2>
<ul>
<li><strong>Protect</strong>: Protecting operations on rows or columns</li>
<li><strong>ReadOnly</strong>: Making read-only models or fields</li>
<li><strong>SoftDelete</strong>: Soft-deleting models</li>
<li><strong>FSM</strong>: Enforcing field transitions</li>
<li><strong>UpdateSearchVector</strong>: Keeping a search vector updated for full-text search</li>
<li><strong>Official interfaces</strong>: Building official interfaces for specific operations</li>
<li><strong>Versioning models</strong>: Mirror fields, computing unique model hashes, etc.</li>
</ul>


<h2>Overview:</h2>
<p>django-pghistory is a tool that tracks changes to Django models using Postgres triggers. It offers reliable history tracking without requiring changes to the application code. This tool provides structured history models that mirror the fields of the models, allowing grouping of history with additional context like the logged-in user. The configuration options available cater to various application needs and focus on performance and scalability. Additionally, django-pghistory includes an admin integration and middleware for convenience.</p>
<h2>Features:</h2>
<ul>
<li><strong>Reliable History Tracking:</strong> Tracks changes to Django models using Postgres triggers.</li>
<li><strong>Structured History Models:</strong> Mirror the fields of the original models.</li>
<li><strong>Additional Context:</strong> Provides grouping of history with context like the logged-in user.</li>
<li><strong>Configuration Options:</strong> Allows customization of history tracking for performance and scale.</li>
<li><strong>Admin Integration:</strong> Includes an admin integration and middleware for easy use.</li>
<li><strong>Selective Field Tracking:</strong> Can track a subset of fields and store events conditionally based on field transitions.</li>
<li><strong>Free-form Context:</strong> Users can store application context in event metadata without additional database queries.</li>
</ul>
<h2>Summary:</h2>


<h2>Overview:</h2>
<p>django-pgtrigger is a tool that helps users implement Postgres triggers for their Django models. Triggers can efficiently solve complex problems like protecting operations on rows or columns, creating read-only models, soft-deleting models, and more. This tool eliminates the need for overridden methods, base models, or signal handling, making it easier to manage and maintain database behaviors.</p>
<h2>Features:</h2>
<ul>
<li><strong>Efficient Problem Solving:</strong> Solve complex issues reliably and succinctly.</li>
<li><strong>Multiple Use Cases:</strong> Protect operations, create read-only models, soft-delete objects, enforce field transitions, and more.</li>
<li><strong>No Overridden Methods Required:</strong> Easily implement triggers without overriding methods, handling signals, or using base models.</li>
<li><strong>Compatibility:</strong> Works with Python 3.8 - 3.12, Django 4.2 - 5.1, Psycopg 2 - 3, and Postgres 13 - 16.</li>
</ul>


Ambitioneng

Django Pgtrigger

Django Pghistory

Django Pgtrigger