Learnings

<p>Case study about Notion performance </p>

<p>Django application providing queryset sealing capability to force appropriate usage of <code>only()</code>/<code>defer()</code> and <br><code>select_related()</code>/<br><code>prefetch_related()</code></p>

<p>Scaling to 100k Users </p>

<p>Lessons learned scaling PostgreSQL database to 1.2bn records/month: </p>

<p>Chrome plans to give slow websites a new badge of shame </p>

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

<p>PostgreSQL Configuration for Humans: </p>

<p>Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default: </p>

<p>"Rather than accepting the current rendered view (web page) as seen by the end-user as fixed, and then asking what can be done to optimise the end-to-end loading time of that page, this paper examines the question of what changes to the current view could dramatically reduce its load time? I.e., small (or sometimes not so small) changes to what the end user ultimately sees on the page, that can have a net benefit on the overall user experience" - </p>

<p>Garbage Collection in Redux Applications </p>

<p>Simple fixes for slow Django REST Framework serializers (not prefetch!): </p>

<p>Why reselect is useful to increase the performance of a React Redux app </p>

<p>Getting The Most Out Of Your PostgreSQL Indexes: </p>

<p>Use psrecord to make a graph of the CPU and memory usage of a process: #414770</p>

<p>Tools for easily profile memory and performance on Python Jupyter notebooks: </p>

<p>Improving third-party web performance at The Telegraph </p>

<p>6 tips for React performance </p>

<p>JavaScript Loading Priorities in Chrome </p>

<p>Just-in-time preloading — preload a page right before a user clicks on it </p>

<p>How Tag Managers impact web performance </p>

<p>Front-End Performance Checklist 2019 </p>

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

<p>Webpack strategies for evolutionary bundle splitting and code splitting that make sense. </p>

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