Tech Insights

<p>Index Selectivity: A Key to High Performance SQL </p>

<p>Information Schema has tables that have a lot of metadata about your DB, </p>

<p>Cheatsheet to grouping queries in Django </p>

<p>How to migrate models across apps in Django? </p>

<p>Django needs a <code>GinIndex</code> with <code>OpClass</code> + <code>Upper</code> to support fast queries with the <code>icontains</code> operator: </p>

<p>Grab: How we store and process millions of orders daily </p>

<p>In Postgres, <code>COUNT(*)</code> vs. <code>COUNT(id)</code> is a non-issue: </p>

<p>How to extract a data-rich service from a monolith </p>

<p>How to estimate the size of one column in a Postgres table? </p>

<p>GitLab on Migration Style Guide: </p>

<p>Thin clones of PostgreSQL to build powerful development, test, and QA envs. Cloning a 1 TiB PostgreSQL database takes ~10 seconds: </p>

<p>Common DB schema change mistakes: </p>

<p>How percentile approximation works (and why it's more useful than averages) </p>

<p>Reading Your Own Writes: </p>

<p>PostgreSQL Anonymizer: </p>

<p>How to make Django migrations that add unique fields: </p>

<p>You can run EXPLAIN on a SQL query directly from a Django queryset: </p>

<p>Datomic Cloud. A transactional database with a flexible data model, elastic scaling, and rich queries. Nubank uses Datomic to back a nimble, elastic microservices platform</p>

<p>How not to structure your database-backed web applications: a study of performance bugs in the wild - </p>

<p>Context Manager to launch exceptions when Django makes unexpected queries to ensure explicit control over DB overhead: </p>

<p>5 ways to host PostgreSQL databases: </p>

<p>Optimizing the Django Admin Paginator: </p>

<p>Use "identity columns" instead of serial type in Postgres &gt; 10: </p>

<p>Don't Do This in Postgres: </p>