1681
Surprises in the Bitcoin blockchain and how they are stored (2014)
Every Bitcoin transaction is stored in the distributed database known as the Bitcoin blockchain. However, people have found ways to hack ...
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 1,888 posts.
1682
A polynomial autoencoder beats PCA on transformer embeddings
A closed-form autoencoder: PCA encoder + quadratic Ridge decoder. On FiQA it gives 4× compression of mxbai-embed-large-v1 at -0.88 p.p. NDCG@10, +1.34 p.p. over PCA. No SGD, no neural networks.
1683
1684
Understanding Variance, Co-Variance, and Correlation
An explanation of Variance, Covariance and Correlation in rigorous yet clear terms providing a more general and intuitive look at these essential concepts.
1685
Surviving without a superuser in Postgres 16
As I've written about before , a PostgreSQL superuser always has the ability to take over the operating system account in which PostgreSQL i...
1686
Don't test with SQLite when you use Postgres in Production
Yesterday, I was looking for some help trying to have a clean way to roll back database transactions at the end of a test in a Python TestC...
1687
First Contact with SQLite
I've been playing around with SQLite the last couple of days. I thought I knew a little about SQLite, but I didn't, and am getting my remedial education through an accelerated gauntlet. Some of what …
1688
Oops, You Wrote a Database
Those who fail to study databases are doomed to write them
1689
Event Sourcing (2005)
Capture all changes to an application state as a sequence of events.
1690
A synthetic control causal analysis of Musk's tweet on Tesla stock price
a terse analysis of tesla stock prices and how one of elon’s tweets moves them
1691
1692
Text Classification by Data Compression
Edit – I posted this on Hackernews and got some valuable feedback. Many brought up the fact that you should be able to reuse the internal state of the compressor instead of recompressing the training …
1693
Restic Cryptography
tl;dr: this is not an audit and I take no responsibility for your backups, but I had a quick look at the crypto and I think I’m going to use restic for my personal backups.
1694
Z-order curve usage to decrease dimensionality to 1
Personal blog about system engineering and devops
1695
Derivation and Intuition behind Poisson distribution
Made in Notion, the connected workspace where AI agents and teams organize docs, projects and knowledge together.
1696
1697
Graphing how the 10k* most common English words define each other
The words are a subset of the 10,000 most common words from Google's Trillion Word Corpus , with definitions sourced from Open English Wordnet .
1698
Postgres, Kafka, and a mysterious 100 GB
Lately I’ve been trying to learn more about Amazon Web Services (AWS) and some other popular technologies. Since I work at a large tech company, I spend a lot of my professional time using pr…
1699
Grouping digits in SQL
PostgreSQL 16 was released last week. This is the story of a feature.
1700
What is Eventual Consistency?
On this post we're going to talk about Eventual Consistency in the context of lock-free and wait-free data structures, with focus on the C++...
1701
Data visualization - 9 Years of Sleep
For the last ten years or so, I used to turn on my PC when I came home from school or work and shut it down again right before I went to bed. So most of the time when my PC is running, I'm awake. I've also been idling in IRC for as long as I had Internet – when my PC is running, so is my IRC client.
1702
1703
Generalized linear models, abridged
Generalized linear models (GLMs) are indispensable tools in the data science toolbox. They are applicable to many real-world problems involving continuous, yes/no, count and survival data (and more). The models themselves are intuitive and can be used for inference and prediction. A few very high quality free and open…
1704
1705
Mapping Strings in C++
Mapping strings to things makes sense. You take a meaningful string and you assign it a value. As with most things we do in programming there are many pitfalls to approaching a problem. So, lets explore some of them!
1706
Advent of Code Surveys: Results
Results dashboard with the yearly (unofficial) Advent of Code participant survey
1707
Historically, 4NF explanations are needlessly confusing
4NF presented in a straightforward way, with some investigation of history of teaching 4NF.
1708
1709
Weighting an average to minimize variance
How would you allocate money to a set of independent assets with to minimize volatility if some assets are more volatile than others?
1710
1 Database Containing 35,000,000 Google Profiles. Implications?
UPDATE 2012-02-16: raver1975 released a SQL database w/35M Google Profiles as .torrent on The Pirate Bay. UPDATE 2011-06-10: Central question in the Google discussion is whether mass-aggregation of profile data…