3571
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
3572
Aggregating away the signal in your data
By aggregating our data in an effort to simplify it, we lose the signal and the context we need to make sense of what we’re seeing.
3573
Visualization techniques for different data sets
Visualizations are awesome.
3574
3575
Your database skills are not 'good to have' (2023)
And a hateful ode to Object-Relational Mappers
3576
3577
3578
Postgres Job Queues and Failure by MVCC
How Postgres’ concurrency model coupled with long-lived transactions can degrade the performance of indexes on hot tables in your database.
3579
Representing Enums in PostgreSQL
Recently, we had a discussion about whether we should use native enums in PostgreSQL, or rely on regular string columns with CHECK constraints. In the end, we decided that we wanted to go with the latter.
3580
Gay marriage: the database engineering perspective
Update, 2017-09-25 Hi! This essay is undergoing a long-overdue rewrite. In the meantime, consider my 2015 follow-up essay, Obergefell v. Hodges: the database engineering perspective....
3581
A/B test improved your website's conversion rate? Not so fast
Many internet companies use A/B testing to evaluate the performance of website changes they want to make. A typical metric in such scenarios is the conversion rate (CVR) of a user, i.e. the probability that a user converts (e.g. makes a purchase) on the website. A typical A/B test setup in such a situation would…
3582
Your Supabase is public if you turn off RLS
I was chatting with a close friend of mine and he sent me a link to his new SaaS that he's developing.
3583
Migrating from SQLite to PostgreSQL
Product updates, comparisons, and deep dives on database change management, access control, and compliance from the Bytebase engineering team.
3584
3585
3586
No, ZFS really doesn't need an fsck tool
(This blog entry has been recovered for the sole purpose of repairing a link in Hackernews. This blog entry is otherwise hidden on the website. 2026-04-13)
3587
3588
3589
Why I like Redis
I’ve been getting a lot of useful work done with Redis recently. Redis is typically categorised as yet another of those new-fangled NoSQL key/value stores, but if you look closer …
3590
How Numba and Cython speed up Python code
A high-level overview of Numba and Cython architectures
3591
Zero downtime migrations at petabyte scale (2024)
Data migrations are a critical part of the database lifecycle, and are sometimes necessary for version upgrades, sharding, or moving to a new platform. In many cases, migrations are painful and error-prone. In this article, we walk through how migrations are performed at PlanetScale, and offer advice on how to improve…
3592
3593
Harder, Better, Faster, Stronger Version of Uber H3 in Rust
Since this article will probably have more reach than my usual rambling, It'll be written in English (but let's not make a habit of it).
3594
Postgres data types you should consider using
PostgreSQL has a rich collection of extensions and nearly 100 different data types, each with their own tuned indexing or specialized functions. You probably already use integers and text, and today we're going to explore a few less-used but incredibly powerful PostgreSQL data types.
3595
How to build vector tiles from scratch
Building MVT tiles from scratch
3596
Turning the database inside-out with Apache Samza (2015)
Confluent is building the foundational platform for data in motion so any organization can innovate and win in a digital-first world.
3597
Building a streaming SQL engine with Arrow and DataFusion
Arroyo 0.10 has an entirely new SQL engine built with Apache Arrow and DataFusion. It's much faster, smaller, and easier to run. Read on for why and how we're making this change.
3598
Bulk loading into PostgreSQL: Options and comparison
You have a file, possibly a huge CSV, and you want to import its content into your database. There are lots of options to do this but how would you decide which one to use. More often than not the question is how much time would the bulk load would take. I found my self doing the same
3599
532x Performance Increase for MongoDB with fractal tree indexes
XoilacZ - Website Xem Trực tiếp bóng đá hôm nay với bình luận Tiếng Việt. XoilacTV cập nhật link xem bóng đá, lịch thi đấu, bảng xếp hạng, kết quả nhanh nhất
3600
Around the World with SQLite3 and Rsync
Run sqlite3 dbs in multiple regions with rsync