1501
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 1,888 posts.
1502
Faster PostgresSQL to BigQuery Transfers
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
1503
1504
Applied Monotonicity: A Brief History of CRDTs in Riak
RiakAround 2013, Riak was at the forefront of Conflict-Free Replicated Data Type (CRDT) development with the engineers at Basho Technologies working hard to integrate efficient, usable CRDTs from t...
1505
Merklizing the key/value store for fun and profit
Joel Gustafson
1506
Analyzing and breaking an externally encrypted HDD
Analyzing and breaking external encrypted HDD has been a “hobby” of mine for quite some time. With my colleagues Joffrey Czarny and Julien Lenoir we looked at several models in the past :
1507
Words growing or shrinking in Hacker News titles: a tidy analysis
In May, some friends and I built Tagger News, a real-time automatic classifier of Hacker News articles based on their text (see here for more about how we built it). This process started me down some interesting paths, particularly analyzing trends in titles. By finding words that became more or less common in Hacker…
1508
Do you really need foreign keys?
Foreign keys are a bit like that well-intentioned friend who insists on double-checking everything you do. They’re often recommended as a must-have for enforcing referential integrity checks in your database.
1509
1510
A sequel to SQL? An intro to Malloy
Homepage of Carlin Eng
1511
Taxi, Uber, and Lyft Usage in New York City
Open NYC data reveals the taxi industry’s contraction, Uber’s growth, and the scramble for market share
1512
A little bit of the one-time MacOS version still lingers in ZFS
You're probably reading this page because you've attempted to access some part of my blog (Wandering Thoughts) or CSpace , the wiki thing it's part of. Unfortunately you're using a browser version that my anti-crawler precautions consider suspicious, most often because it's too old (most often this applies to versions…
1513
The PostgreSQL documentation and the limitations of community
In my opinion, the PostgreSQL documentation is simultaneously excellent and fairly poor, and both its excellence and its shortcomings are di...
1514
1515
R, OpenMP, MKL, Disaster
The answer should be something close to ALPHA , i.e. 0.01 . What R was printing out was weird numbers like 1e-10 .
1516
1517
One night in Uzbekistan: Why was this one data point so influential?
We have a comment coming out in Nature next week that is going to cause the retraction of a high-profile paper by Kotz et al. from last year (the second most cited climate paper in the news in 2024).
1518
Google+ launches ‘Ripples’ visualisation
After what appears to be have been a rapid and widespread take-up of its Google+ social media service, Google has now launched details of its 'Ripples' feature. Significantly, news of the release was made by Fernanda Viegas, one of the most prominent names in the field and co-leader, with Martin Wattenberg, of…
1519
1520
Things I want in a modern relational query language
This was a very old draft I’ve had sitting around for years. The recent discussions of new query languages like Acadia spurred me to revisit, revise, and publish this. I think one of the biggest causes of NoSQL is that… Continue reading →
1521
Agentic AI systems violate the implicit assumptions of database design
There is an implicit contract at the foundation of every database architecture decision you have ever made. You probably never wrote it down. Nobody does. It just… existed.
1522
(Some) ORM haters do get it
Daftar slot online di Modus99 dapat menggunakan qris dan menjadi satu-satunya situs paling terpercaya saat ini dengan berbagai jenis bocoran semua provider.
1523
15k inserts/s with Rust and SQLite (2021)
There is this growing sentiment in tech that stacking more and more layers of complexity to reach the sacrosanct "infinite scalability" is not the way forward. First, because it rarely materializes: you need a lot of other things than fancy tech to reach millions of people. Second, because the tradeoffs
1524
1525
1526
PostgreSQL DBaaS vendor comparison and calculator
This is a comparison of PostgreSQL DBaaS providers with an interactive calculator.
1527
Starting data analysis with R: Things I wish I'd been told
R is a very powerful open source environment for data analysis, statistics and graphing, with thousands of packages available. After my previous blog post about likert-scales and metadata in R , a few of my colleagues mentioned that they were learning R through a Coursera course on data analysis . I have been working…
1528
Sparrow, a modern C++ implementation of the Apache Arrow columnar format
A Modern C++ Implementation of the Apache Arrow Columnar Format
1529
LLM Classification Is Feature Engineering
LLMs make good classifiers but even better features
1530
The mean means nothing: data visualization to debug a latency problem
I was recently trying to validate some performance improvements related to lld at $DAYJOB and it was a little frustrating to see the improvements in our benchmarks but not in the live-production dashboards.