1291
Postgres UUIDv7 and per-back end monotonicity
How Postgres’ v7 UUIDs are made monotonic, and why that’s a great feature.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
1292
Tin: full-text search for Postgres
TIN is a fast, full-featured, full-text search index for Postgres
1293
Deno KV internals: building a database for the modern web
How we built a performant, scalable, ACID-compliant, JavaScript-native database on FoundationDB.
1294
1295
1296
Track HN: Survival Rate of Show HN Stories
Spoiler alert: many of the good projects didn’t survive
1297
Practical Guide to SQL Transaction Isolation
You may have seen isolation levels in the documentation for your database, felt mildly uneasy, and went on with life. Few day-to-day examples of using transactions really mention isolation. Most use the database’s default isolation level and hope for the best. It’s a fundamental topic to understand however and you’ll…
1298
1299
Why Databases Are Not for Docker Containers
If we attentively look at IT industry at 2017, all of us will see “containers” and “Docker” as the top buzzwords ever. We started to package developed software in Docker containers in every field. …
1300
Every System is a Log: Avoiding coordination in distributed applications
Distributed coordination makes application complex and brittle. Because all systems eventually build on logs, we can use a shared-log approach to eliminate most coordination. We discuss this conceptually and show how this is practically implemented in the open source project Restate.
1301
Redis 8.8: New array data structure, rate limiter, performance improvements
Redis 8.8 is now available in Open Source. Explore the new array data type, window counter rate limiter, streams NACK, and more performance-focused updates.
1302
1303
PgBouncer is useful, important, and fraught with peril
Updated 2024-09-17 to reflect updated PgBouncer support for protocol-level prepared statements 🐘 To start, I want to say that I’m appreciative that PgBouncer exists and the work its open source maintainers put into it. I also love working with PostgreSQL, and I’m thankful for the incredible amount of work and…
1304
Image Completion with Deep Learning in TensorFlow
Content-aware fill is a powerful tool designers and photographers use to fill in unwanted or missing parts of images. Image completion and inpainting are closely related technologies used to fill in missing or corrupted parts of images. There are many ways to do content-aware fill, image completion, and inpainting. In…
1305
Probabilistic Data Structures For Web Analytics And Data Mining
Statistical analysis and mining of huge multi-terabyte data sets is a common task nowadays, especially in the areas like web analytics and Internet advertising. Analysis of such large data sets oft…
1306
Binance built a 100PB log service with Quickwit
Binance Scales its Log Service to 100PB and Saves Millions with Quickwit
1307
Farewell Pandas, and thanks for all the fish
the portable Python dataframe library
1308
Why isn't differential dataflow more popular?
Differential dataflow is a library that lets you write simple dataflow programs and a) then runs them in parallel and b) efficiently updates the outputs when new inputs arrive. Compared to competition like spark and kafka streams , it can handle more complex computations and provides dramatically better throughput and…
1309
Raid-Z Expansion Feature for ZFS Goes Live
The Foundation sponsored feature reflows existing data to rewrite it onto a new arrangement of disks thereby freeing space at the end of the logical RAID-Z group The FreeBSD Foundation funded the project to ensure the completion and release of an easy-to-use and practical application. The project came in under budget…
1310
Scaling the GitLab database
An in-depth look at the challenges faced when scaling the GitLab database and the solutions we applied to help solve the problems with our database setup.
1311
Timescale raises $110M Series C
Timescale just raised $110 million in our Series C, led by Tiger Global alongside all existing investors: Benchmark, New Enterprise Associates.
1312
Anna: A Fast, Scalable, Flexibly Consistent Key-Value Store
There’s fast and there’s fast. This post is about Anna*, a key/value database design from our team at Berkeley that’s got phenomenal speed and buttery smooth scaling, with an unpr…
1313
Making a Postgres query 1k times faster
Learn how we discovered what was slowing down large database queries, and what we did to make Postgres queries 1000x faster.
1314
How Time Series Databases Work, and Where They Don’t
This blog takes a deep dive into the hows and whys of time series databases—and why Honeycomb couldn't be limited to a TSDB implementation.
1315
Archive.org and California to start a data sharing and preservation project
Research and cultural heritage institutions are facing increasing costs to provide long-term public access to historically valuable collections of scientific data, born-digital records, and other digital artifacts. With many institutions moving data to cloud services, data sharing and access costs have become more…
1316
100M Photos – Geotagged, Connected, and Available for All
Last year I wrote a blog post when we hit 10 million photos, to mark the date and thank everyone who helped us get there together. Today, we just passed 100 million.
1317
1318
All of the vehicle license plates available in America
States now offer a vast menu of personalized plate options for a dizzying array of organizations, professions, sports teams, causes and other groups.
1319
How about trailing commas in SQL?
Anecdotally, this might be the most requested feature in SQL: Allow some trailing commas.
1320