Tech Insights

<p>Handling Concurrency Without Locks </p>

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

<p>Testing Database Changes the Right Way </p>

<p>Beekeeper Studio - Open Source SQL Editor and Database Manager </p>

<p>Django’s Field Choices Don’t Constrain Your Data </p>

<p>Export to CSV from PSQL using the copy command </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 we built a forever-free serverless SQL database </p>

<p>Scaling Datastores at Slack with Vitess </p>

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

<p>Hosting SQLite databases on static pages </p>

<p>Overview postgresql indexes </p>

<p>Keeping Django database migrations backward compatible </p>

<p>Zero downtime database migrations </p>

<p>Working with huge data sets in Django </p>

<p>PostgreSQL at low level: stay curious! &gt; </p>

<p>Best way to select random rows PostgreSQL: </p>

<p>List all foreign keys referring to a table and if they're nullable or not with a simple SQL query in Postgres </p>

<p>quickly define a django management command for read-only shell </p>

<p>You should be careful when naming your heroku apps </p>

<p>Show database, table and indexes size in Postgres: </p>

<p>Auto-incremented primary keys are not very safe, consider using uuid </p>

<p>Intuitive proof of CAP theorem: </p>

<p>In Django, <code>in_bulk</code> queryset method allows bulk fetching via primary key: #in-bulk</p>