151
Using Bloom filters to efficiently synchronise hash graphs
This blog post uses MathJax to render mathematics. You need JavaScript enabled for MathJax to work.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 269 posts.
152
Event Sourcing (2017)
I recently became intrigued by the concept of event sourcing as applied to back-end architecture, specifically a microservice-oriented approach. I have spent the last few years working predominantly on the front-end, and became enamored by the simplicity and elegance of this pattern as the backbone of front-end…
153
Are CRDTs suitable for shared editing?
The sole purpose of this blog is to host a single article..
154
Introduction to Hacking PostgreSQL (2007)
Gavin Sherry and I have presented several versions of a tutorial introduction on how to modify the PostgreSQL source code. The original version was given at the PostgreSQL Anniversary Summit in June of 2006. Gavin has since given a revised version of the talk (at LCA 2007), as have I (at PgCon 2007).
155
Parsing the Infamous Japanese Postal CSV
Late last year I released posuto, a package presenting Japanese postal code data in an easy-to-use format. It's based on data released by Japan Post, which is infamous for being widely used but hard to parse.
156
Understanding Recursive Queries in PostgreSQL
This article gives a simple introduction with examples to recursive queries in PostgreSQL. It also includes a comparison to Oracle recursive queries.
157
APFS changes in Big Sur: how Time Machine backs up to APFS
APFS adds 6 volume roles, including one which supports Time Machine backups. And per-file encryption is coming.
158
Rust DataBase Connectivity (RDBC)
Software engineer specializing in query engines and distributed systems
159
160
Machine Learning Engineer Guide: Feature Store vs. Data Warehouse
The feature store is a data warehouse of features for machine learning (ML)....
161
How to better calculate churn rates
According to Andreessen Horowitz, this number is one of the top 16 metrics to measure a SaaS startup by. Well, sorry Andreessen, and sorry Horowitz, but this just isn't right.
162
Eventual Consistency isn’t for Streaming
Understand why eventual consistency isn't suitable for streaming systems & the systematic errors it can cause with Materialize's insights.
163
An Introduction to Conflict-Free Replicated Data Types
This is an interactive tutorial series about Conflict-Free Replicated Data Types, or CRDTs for short. Their purpose is to allow seamless replication of data on different nodes in a distributed system. Merging is by construction always possible, without any conflicts. This series assumes no knowledge about CRDTs, but…
164
Migrating to CockroachDB
CockroachDB is a newSQL database, behaving much like a traditional database while providing consistent HA and scalability out of the box.
165
A visual explanation for regularization of linear models
A deep dive into exactly how regularization works, using visualizations rather than (just) mathematics. This article also dispels some myths and answer some important questions about Lasso and Ridge regression.
166
US Postal Service data suggests significant population decline in San Francisco
PengelKeluaran SGP Hari Ini Resmi Togel Singapore Pools Tersedia Melalui Data SGP Prize dan Menyalin Pengeluaran SGP Hari Ini Untuk Pemain Toto SGP.
167
168
Generalizing 'jq' and Traversal Systems using optics and standard monads
The Personal blog and musings of Chris Penner, a designer, developer and future opsimath.
169
I Want Decentralized Version Control for Structured Data
How do I synchronize application data between devices and people? That's the question I was unable to answer when thinking about ideas for new applications I could develop. I wanted the synchronization to be
170
Why CockroachDB and PostgreSQL Are Compatible
CockroachDB is PostgreSQL compatible in order to be accessible to an ecosystem of drivers, existing code, and developer knowledge.
171
Effectively Using Materialized Views in Ruby on Rails
We look at how to utilize both, views and materialized views, within Ruby on Rails with a real-world sized dataset of hockey teams and their top scorers.
172
Applying Textbook Data Structures for Real Life Wins
How we leveraged a textbook data structure in our core platform and achieved a 15x speed up for a key data processing step.
173
ListenBrainz moves to TimescaleDB
The ListenBrainz team has been working hard on moving our primary listen store from InfluxDB to TimescaleDB , and today at UTC 16:00 we’re going to make the switch.
174
175
How we built scalable spatial indexing in CockroachDB
Support for spatial data and geospatial indexing is one of the most requested features in the history of CockroachDB.
176
TaBERT: A new model for understanding queries over tabular data
TaBERT is the first model that has been pretrained to learn representations for both natural language sentences and tabular data.
177
Amazon RDS on Graviton2 Processors
I recently wrote a post to announce the availability of M6g, R6g and C6g families of instances on Amazon Elastic Compute Cloud (Amazon EC2). These instances offer better cost-performance ratio than their x86 counterparts. They are based on AWS-designed AWS Graviton2 processors, utilizing 64-bit Arm Neoverse N1 cores…
178
Classifying 200k articles in 7 hours using NLP
Sculpt AI was built by a team of machine learning experts and SALT.agency and is a code-free AI platform. Keep reading to learn more about the benefits of this.
179
Lessons from Bug Hunters Who've Found 400 Bugs in Popular DBMSs
TiDB is the distributed SQL database built for AI agents. Vectors, transactions, and analytics in one engine with ACID guarantees and elastic scale.
180
SELECT wat FROM sql
Thanks to Nikhil Benesch, Justin Jaffray and several decades of "wouldn't it be nice if..." for contributions.