Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 253 posts.
I’ve added a faceted search engine to this blog, powered by PostgreSQL. It supports regular text search (proper search, not just SQL“like” queries), filter by tag, filter by date, filter …
A long-form article entitled: "Domain Logic and SQL"
The Django ORM feels so much easier than SQLAlchemy? Maybe this article can change your perception.
An interesting challenge in cartography is getting data of the appropriate resolution. As Lewis Fry Richardson observed , the more precisely you measure the length of a coastline, the longer it appears; geographic shapes have infinite complexity. Digital displays, in contrast, are limited by pixels. Choosing too high…
Via this comment on Hacker News I started exploring the ClickHouse Playground . It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.
This blog post has been archived! SpacetimeDB has improved a lot since I initially published this technical review, and most of the technical details in it no longer apply.
tl;dr: I have created a test suite for comparing the transaction isolation levels in different databases. I did this as background research for my book . This post explains why.
Things a programmer coming from another language needs to know about R, especially those things that might be most surprising
Did you know that there's a Bash kernel for IPython Notebook? It even displays inline images. Could it ever be a convenient environment for doing data science? Would it be worthwhile to publish my book Data Science at the Command Line as a collection of notebooks?
NoSQL databases were the future. MongoDB was the database for “modern” web engineers and used by countless startups. What happened?
Suppose for a moment that you are running a web site that has a poorly implemented password database that stores password hashes using some...
The CAP theorem is too simplistic and too widely misunderstood to be of much use for characterizing systems.
Back in September 2009 I launched a small web app called HNTrends.com, a tool for visualizing the movement of stories on HackerNews’s front page over time. I haven’t worked on the site …
