Topics /
The most popular blog posts about databases & data on Hacker News. 1,888 posts.
As my cat woke me up way too early for a Saturday morning, I decided to put all this extra time (and my ChatGPT Pro subscription) into good use and generated a QR-code generator for PostgreSQL, written as a single pure SQL statement. No external libraries or Postgres extension installation needed! The pqr.sql example…
Basic Income is a popular policy floating around the internet lately. The idea consists of declaring that the government will pay each living adult a fixed amount of money every month - an amount comparable to a minimum wage job. This policy would then replace all current welfare programs - welfare, unemployment …
In this post, I am going to talk about the N + 1 queries problem. While trying to solve this problem myself recently, I noticed most of the blog posts only talk about the very simple version of the problem and the proposed solutions would break down when the use cases get complex. I will try to get into more depth and…
Don’t waste time trying to discover which files are still open when you want to check or repair an APFS disk and Disk Utility throws an error. Here’s the solution.
by Andrew Barisser
The days of the one-size-fits-all monolithic database are behind us, and developers are using a multitude of purpose-built databases.
I've been interested in using Kyoto Tycoon for some time. Kyoto Tycoon, successor to Tokyo Tyrant , is a key/value database with a number of desirable features:
It’s very common for machine learning practitioners to have favorite algorithms. It’s a bit irrational, since no algorithm strictly…
Tracking improvements to Postgres partitioning since 2017. In just five years it’s gone from a non-feature to a very good one.
Make your own NBA shot charts. Open-source, interactive dashboard interface to NBA Stats API built with R and Shiny
Over break I went out with a buddy of mine and played some darts. This got me to thinking, where exactly should someone aim in order t...
There is a lot to say about parallelism in PostgreSQL. We have come a long way since I wrote my first post on this topic ( Parallel Sequen...
A blog about computer programs, databases, and the future of software development.
Some things about the R programming language that programmers coming from other languages are likely to trip over.
I am an economist at the Federal Trade Commission with a very basic statistics question, one that I have put to several fairly high-powered econometricians, and to which no one has had a satisfying answer.
99Bitcoins is your trusted guide to Bitcoin & crypto, offering easy tutorials, expert insights, and in-depth reviews to help you navigate the crypto world.
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.
Vector search isn't just for AI embeddings. Use HNSW for geo-spatial queries, stock covariance, chess positions, text tokens, and multi-modal recommendations with custom metrics.
The existence claim for the singular value decomposition (SVD) is quite strong: “Every matrix is diagonal, provided one uses the proper bases for the domain and range spaces” (Trefethen & Bau III, 1997) . MIT professor Gilbert Strang has a wonderful lecture on the SVD, and he includes an existence proof for the SVD…
This paper is from SOSP'13. The Polyjuice paper, which we studied last week, built on the Silo codebase and commit protocol, which led me ...
Data files are derived from the Google Web Trillion Word Corpus , as described by Thorsten Brants and Alex Franz, and distributed by the Linguistic Data Consortium.
Hacker News is a popular social news website, mostly covering technology and startup topics. It relies on user submissions and moderation, where each submitted story can be upvoted and commented by users, which in term determines whether the story reaches the front page and how long it stays there.
