1
Storing UTC is not a silver bullet
Note: this is a pretty long post. If you’re not interested in the details, the conclusion at the bottom is intended to be read in a standalone fashion. There’s also a related blog post …
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 13 posts.
2
Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior.
This is pretty important change, as it has the chance to cause performance issues in some cases.
3
Let’s Build a Simple Database (2017)
Writing a sqlite clone from scratch in C
4
Common statistical tests are linear models
By Jonas Kristoffer Lindeløv ( blog , profile ). Last updated: 28 June, 2019 (See changelog ). Check out the Python version and the Twitter summary .
5
6
Xkcd-Style Plots in Matplotlib (2012)
Update: the matplotlib pull request has been merged! See This post for a description of the XKCD functionality now built-in to matplotlib!
7
How Bad Is Your Colormap? (2014)
What this function does is to give you a lumninance-correct grayscale version of any matplotlib colormap. I've found this useful for quickly checking how my plots might appear if printed in black and white, but I think it's probably even more useful for stoking the flame of the internet's general rant against jet .
8
Interpretable Machine Learning
Machine learning is part of our products, processes, and research. But computers usually don’t explain their predictions , which can cause many problems, ranging from trust issues to undetected bugs. This book is about making machine learning models and their decisions interpretable.
9
10
AWS Elasticsearch: a fundamentally-flawed offering
I'm currently working on a logging project that was initially implemented using AWS Elasticsearch. Having worked with large-scale mainline Elasticsearch clusters for several years, I'm absolutely stunned at how poor Amazon's implementation is and I can't fathom why they're unable to fix or at least improve it. I…
11
Processing 40TB of code from 10M projects with a dedicated server and Go
The command line tool I created Sloc Cloc and Code (scc) (which is now modified and maintained by many other excellent people) counts lines of code, comments and makes a complexity estimate for files …
12
Timestamps and Time Zones in PostgreSQL (2016)
The nuance between timestamp with and without time zone
13
Shenandoah GC in production: experience report
Update: I've made several edits to the post since Aleksey Shipilëv was kind enough to suggest many corrections and improvements.If you closely follow JVM development scene, you've probably noticed ...