271
Netflix's Distributed Counter Abstraction
By: Rajiv Shringi, Oleksii Tkachuk, Kartik Sathyanarayanan
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 350 posts.
272
Setting up PostgreSQL for running integration tests
Setting up PostgreSQL for tests is crucial for achieving performance and reliability. In this article, I'll explain how to set up PostgreSQL for tests and discuss some common pitfalls to avoid.
273
The PlanetScale vectors public beta
You can now use the vector data type for vector search and storage in your PlanetScale MySQL database.
274
Why is Snapshot Isolation not enough?
Let's talk about why Snapshot Isolation is not enough for a general purpose concurrency control. Snapshot Isolation has been adap...
275
SQLite does not do checksums
SQLite does not do checksums by default. Disk corruptions go silently unnoticed.
276
NumPy-style broadcasting in Futhark
A high-performance and high-level purely functional data-parallel array programming language that can execute on the GPU and CPU.
277
Qdrant, the Vector Search Database, raised $28M in a Series A round
Qdrant is an Open-Source Vector Search Engine written in Rust. It provides fast and scalable vector similarity search service with convenient API.
278
DeWitt and Stonebraker's "MapReduce: A major step backwards" (2009)
In January 2008 David DeWitt and Michael Stonebraker published an article criticising MapReduce. As far as I can find, the article is no lon...
279
An open source DuckDB text to SQL LLM
Our first Text2SQL model release! | Reading time: 5 min read
280
281
Optimizing ClickHouse: Tactics that worked for us
At LaunchDarkly, we ingest nearly 100 terabytes of observability data from our customers every month.
282
Postgres locks explorer
All of the data in this page is derived from these tests , so is true by some definition of true. Notable is this test - given an arbitrary SQL statement, it determines via runtime inspection which locks are taken.
283
Is the "modern data stack" still a useful idea?
My vote: no.
284
How to Distribute Postgres Geographically
Documenting a pattern for making multi-tenant applications global by distributing the data, using only standard PostgreSQL functionality.
285
Regular expression functions in Excel
Check out three new functions that use Regular Expressions to help parse text more easily: REGEXTEST, REGEXEXTRACT, and REGEXREPLACE!
286
Nixiesearch: Running Lucene over S3, and why we're building a new search engine
A new search engine in 2024? Yes, but stateless — index on S3, serverless — no cluster state, with all Lucene features — filters, autocomplete, facets. And also with local embedding & RAG inference.
287
Solving methane mysteries with satellite imagery
By combining two types of remote sensing data, we can see hidden leaks from ships
288
Pgvector Is Now Faster Than Pinecone at 75% Less Cost
Meet pgvectorscale, an open-source PostgreSQL extension that supercharges pgvector’s vector search performance for large-scale vector workloads.
289
LLM-based sentiment analysis of Hacker News posts between Jan 2020 and June 2023
We analyzed topics covered by 100k Hacker News posts and the sentiments they evoke using Metaflow.
290
Notebooks Are McDonalds of Code
You can come to McDonalds and order a salad, but you won't. Same with notebooks, you can write NASA-production-grade software in a notebook, but most likely you won't. Notebooks make you lazy, and encourage bad practices.
291
LedgerStore Supports Trillions of Indexes at Uber
Uber connects the physical and digital worlds to help make movement happen at the tap of a button. Billions of trips, deliveries, and tens of billions of financial transactions across earners, spenders, and merchants are made at Uber every quarter. LedgerStore is an immutable storage solution at Uber that provides…
292
The economics of a Postgres free tier
Let's look at the numbers behind Xata's free tier. How much does a database cost us and why are we offering them for free.
293
Thoughts on PostgreSQL in 2024
A look ahead at some ongoing projects in PostgreSQL in 2024 and beyond
294
Interactive SQLite Documentation: Experiment with Queries in Real-Time
At SQLite Cloud, we are dedicated to making database management as seamless and intuitive as possible. Today, we are thrilled to unveil a groundbreaking addition to our platform - the Interactive SQLite Documentation! Now, alongside our comprehensive...
295
Analyzing Spotify Stream History
I recently learned Spotify provides downloads for users’ streaming history. For me, this is over 10 years worth of data, so at the very least it seemed like a good nostalgia trip. This post covers some of my analysis of my personal export, and hopefully is a good starting place if you’re interested in exploring your…
296
The time keepers: pg_cron and pg_timetable
Need to schedule tasks in PostgreSQL? Compare pg_cron for simple in-database scheduling with pg_timetable for complex workflows and multi-cluster orchestration.
297
Why I Wrote Data Science for Crime Analysis with Python (2023)
To help crime analysts get started with python, I am early releasing Data Science for Crime Analysis with Python, an introductory book for analysts.
298
299
Breaking Bell's Inequality with Monte Carlo Simulations in Python
The article explains the Bell inequality using Monte Carlo simulations in Python, and shows how non-local action-at-a-distance can be used to break it with entangled qubits.
300
Imagining a personal data pipeline
I've been thinking a lot about personal data lately: where it's stored, how to extract it, and what to do with it. Here's where I landed.