811
Call Me Maybe: MariaDB Galera Cluster
Previously, on Jepsen, we saw Chronos fail to run jobs after a network partition . In this post, we’ll see MariaDB Galera Cluster allow transactions to read partially committed state.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
812
A beginners guide to thinking in SQL
In this tutorial we will learn about the concepts behind the SQL syntax. We will go through the basics of how to use the FROM and WHERE clauses, and move on to more advanced topics like joins, aggregations and subqueries.
813
Fly Postgres, Managed by Supabase
A managed Postgres offering developed by Supabase and Fly.io
814
815
Why Nasa Converted Its Lessons-Learned Database into a Knowledge Graph
Learning from mistakes—your own and those made by others—is a mark of effective organizations. Fostering a learning environment means seeing every...
816
Statistical Mistakes and How to Avoid Them
You can get CS papers published with shoddy statistics, but that doesn’t mean you should. Here are three easy ways to bungle the data analysis in your evaluation section: don’t even try to use statistics when you really ought to; misinterpret an inconclusive statistical test as concluding a negative; or run too many…
817
Principles of Sharding for Relational Databases
Some say sharding is the best way to scale a database. Sharding enables you to linearly scale cpu, memory, and disk by separating your database into smaller parts. Yet, sharding is controversial. This post explores the principles of sharding relational databases for B2B, B2C, and B2B2C applications.
818
Engineers Shouldn’t Write ETL
“What is the relationship like between your team and the data scientists?” This is, without a doubt, the question I’m most frequently asked when conducting i...
819
Amazon's exabyte-scale migration from Apache Spark to Ray on EC2
Large-scale, distributed compute framework migrations are not for the faint of heart. There are backwards-compatibility constraints to maintain, performance expectations to meet, scalability limits to overcome, and the omnipresent risk of introducing breaking changes to production. This all becomes especially…
820
Russian legislative elections 2011 - statistical evidence of vote fraud
You probably have heard about alleged vote fraud in the Russian legislative election 2011. You might even have seen videos about cases of vo...
821
Wddbfs – Mount a SQLite database as a filesystem
Often when I’m prototyping a project, I hesitate to use a sqlite database despite their many adavantages . It seems much easier to just dump a bunch of files in a directory and to rely on the universal support for the filesystem API to read/delete/update records. Part of this is avoiding the overhead of figuring out a…
822
823
The RAG Obituary: Killed by agents, buried by context windows
I’ve been working in AI and search for a decade. First, I built Doctrine, the largest European legal search engine, and now I am building Fintool , an AI-powered financial research platform that helps institutional investors analyze companies, screen stocks, and make investment decisions.
824
New Query Language for Graph Databases to Become International Standard
Read the latest Neo4j press releases and company news, including product launches, partnerships, and milestones in graph database and analytics.
825
Deleting an S3 Bucket Costs Money
Deleting an S3 bucket is harder than you think, and may even cost you money.
826
No More Full Table Vacuums in PostgreSQL
I just committed a very important patch to PostgreSQL. The short summary for the patch is " Don't vacuum all-frozen pages. " and it follows...
827
Using Altair for most of my visualization in Python
Fernando Irarrázaval Stream of consciousness about Data Science, Python, and Economics.
828
829
I wrote a new JIT compiler for PostgreSQL
Sometimes, I don’t know why I do things. It’s one of these times. A few months ago, Python 3.13 got its JIT engine, built with a new JIT compiler construction methodology (copy-patch, cf. research paper ). After reading the paper, I was sold and I just had to try it with PostgreSQL. And what a fun ride it’s been so…
830
Use SQL subqueries to count distinct 50x faster
NB: These techniques are universal, but for syntax we chose Postgres. Thanks to the inimitable pgAdminIII for the Explain graphics. So useful, yet so slow
831
When LIMIT 9 works but LIMIT 10 hangs
I got a Slack message from colleagues at a major partner. They’d updated their dev environment to support WebSockets, so that Neon’s serverless driver could be used there, but then they’d run into a weird issue. The nub of it was this: This hangs: This works Reproducibly, the query without an ORDER BY ran fine […]
832
Amazon S3 will no longer charge for several HTTP error codes
Discover more about what's new at AWS with Amazon S3 will no longer charge for several HTTP error codes
833
Some Reflections on Being Turned Down for a Lot of Data Science Jobs
👉 The decision was close, but the team has decided to keep looking for someone who might have more direct neural net experience.\n👉 Honestly, I think the way you communicated your thought process and results was confusing for some people in the room.\n👉 He’s needing someone with an image analysis background for data…
834
YC Portfolio Stats
We get asked a lot for statistics on the YC portfolio. Even though some of these aren’t that helpful [1], here is the latest update on the numbers we get asked about the most. As always, all the credit goes to the founders. Total market cap of all YC companies: >$30 billion Total money raised by all YC companies: >$3…
835
My thoughts on Python in Excel
An in-depth review of Microsoft's new Python in Excel functionality
836
Babelfish: SQL Server-to-Postgres Translation Layer
“The greatest force in legacy databases is inertia,” a widely regarded industry analyst once told me. Not superior functionality. Not better performance. Not lower cost. None of the above. Just inertia. Developers might say they prefer to run PostgreSQL to proprietary alternatives (and they do), but enterprises have…
837
838
Sieve is simpler than LRU
SIEVE is Simpler than LRU: an Efficient Turn-Key Eviction Algorithm for Web Caches
839
Unix’s file durability problem
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…
840
Prisma 2.0 Beta: Type-safe Database Access
Prisma 2 Beta introduced type-safe database access with Prisma Client, updated docs, and a clearer path toward production readiness.