Learnings

<p>If you need to use more advanced database functions on Django annotations, such as Postgres <code>split_part</code>, you can make use of query expressions like <code>Func</code> </p>

<p>Fisher-Yates: the best way to shuffle an array and the dangers of naïveté </p>

<p>When I should use either PUT or PATCH to handle updates #39338329</p>

<p>If you have pure functions called multiple times you should try it functools.lru_cache</p>

<p>Regex for matching URLs, useful to auto-linkify raw text: </p>

<p>Show size of various PostgreSQL objects like indexes, materialized views, tables, etc: </p>

<p>It's a funny explanation about idempotence </p>

<p>Is REST DELETE really idempotent? </p>

<p>Stop Using word2vec: </p>

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

<p>Using SVG as a placeholder: </p>

<p>CSS Grid: Supporting Browsers without Grid </p>

<p>Tell Django to stop reporting particular 404s by tweaking the IGNORABLE_404_URLS setting.</p>

<p>List of userful url patterns: </p>

<p>On DRF, override to use different serializers for input and output in a same request: </p>

<p>Interesting tool to abstract some git concepts in the command line interface </p>

<p>If using <code>get_or_create</code> don't forget to make use of <code>defaults</code> parameter</p>

<p>Dropbox releases PyAnnotate - auto-generate type annotations for mypy: </p>

<p>Use django-postgres-extra for native upserts, more powerful HStoreField, more signals and indexes with conditions: </p>

<p>An instant JSON API for your SQLite databases: </p>

<p>Find bottlenecks by benchmarking your tests with pytest-benchmark </p>

<p>The law of Demeter is an important foundation for OOP </p>

<p>Best REST overview I could find: </p>

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