3571
How big are our embeddings now and why?
Embedding sizes and architectures have changed remarkably over the past 5 years
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
3572
3573
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.
3574
Visualization techniques for different data sets
Visualizations are awesome.
3575
3576
Your database skills are not 'good to have' (2023)
And a hateful ode to Object-Relational Mappers
3577
3578
3579
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.
3580
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.
3581
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....
3582
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…
3583
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.
3584
Migrating from SQLite to PostgreSQL
Product updates, comparisons, and deep dives on database change management, access control, and compliance from the Bytebase engineering team.
3585
3586
3587
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)
3588
3589
3590
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 …
3591
How Numba and Cython speed up Python code
A high-level overview of Numba and Cython architectures
3592
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…
3593
3594
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).
3595
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.
3596
How to build vector tiles from scratch
Building MVT tiles from scratch
3597
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.
3598
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.
3599
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
3600
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