Tech Insights

<p>Kysely is a type safe query builder for Typescript, a great companion for Prisma (With <em>prisma-kysely</em> integration) </p>

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

<p>Django - filter(A).filter(B) vs filter(A, B) </p>

<p>An alternative to soft_deleted_at is to create a table that will be auto populated with deleted records </p>

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

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

<p>Using window functions on Django ORM </p>

<p>django-pgtrigger provides primitives for configuring Postgres triggers on Django models without raw SQL in many cases: </p>

<p>You Are Doing SQL Pagination Wrong </p>

<p>django-raw-sugar: Turns your raw SQL into a QuerySet. </p>

<p>Postgres Auditing in 150 lines of SQL: </p>

<p>Does the join order matter in SQL? </p>

<p>Short explanation of the issues faced when trying to create a PostgreSQL index using the date() function and how to resolve it. </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>Join strategies and performance in PostgreSQL: </p>

<p>How to Create an Index in Django Without Downtime: </p>

<p>Optimizing Pattern Searching Queries in PostgreSQL: </p>

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

<p>SQLBolt – Interactive lessons and exercises to learn SQL: </p>

<p>Scaling Relational SQL Databases: </p>

<p>pgbarman - taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee: </p>