Learnings

<p>PostgreSQL CLUSTER command can speed up large tables that are frequently filtered by a indexed column: </p>

<p>django-partial-index allows you to set partial/conditional indexes and partial unique constraints, which are useful for ensuring data integrity according to your business logic: </p>

<p>Django Pro-Tip – Slugs as primary keys: </p>

<p>Excellent article about how ORMs cause leaky abstractions that lead to performance issues and how fixing them is generally simple: </p>

<p>Besides causing unexpected performance problems, a model default ordering in Django can cause problems to <code>values()</code>. Avoid default ordering! #interaction-with-default-ordering-or-order-by</p>

<p>Are triggers really that slow in Postgres? </p>

<p>A beginner’s guide to database locking and the lost update phenomena (examples in Hibernate, but relevant to Django!): </p>

<p>Stupid PostgreSQL Tricks: Writable Views (not really recommended, but interesting!): </p>

<p>Django transaction.atomic is not a lock! </p>

<p>On Django, you should NOT use <code>loaddata</code> management command directly in a data migration. It will use the current model state, not the historical one, therefore your migration will certainly BREAK in the future: </p>

<p>On PostgreSQL, use <code>substring</code> function with regex along with multiple columns on <code>order by</code> to properly mix numeric with alphabetical order: </p>

<p>ORDER BY the IN value list: </p>

<p>9 Django Tips for Working with Databases: </p>

<p>Postgres DB-level for-each with LATERAL: </p>

<p>Primary Keys: IDs versus GUIDs </p>

<p>Order of columns in a compound index in PostgreSQL (and query order): </p>

<p>Reading a Postgres EXPLAIN ANALYZE Query Plan: </p>

<p>Django will store your dates in UTC if you set USE_TZ=True</p>

<p>django-eraserhead: Django package that provides hints to optimize database usage by deferring unused fields (and more) </p>

<p>Django 1.11 Subquery expressions: #subquery-expressions</p>

<p>Postgres full-text search is Good Enough! </p>

<p>Avoid Django's GenericForeignKey: </p>