811
Fly Postgres, Managed by Supabase
A managed Postgres offering developed by Supabase and Fly.io
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,222 posts.
812
813
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...
814
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…
815
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.
816
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...
817
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…
818
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...
819
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…
820
821
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.
822
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.
823
Deleting an S3 Bucket Costs Money
Deleting an S3 bucket is harder than you think, and may even cost you money.
824
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...
825
Using Altair for most of my visualization in Python
Fernando Irarrázaval Stream of consciousness about Data Science, Python, and Economics.
826
827
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…
828
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
829
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 […]
830
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
831
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…
832
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…
833
My thoughts on Python in Excel
An in-depth review of Microsoft's new Python in Excel functionality
834
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…
835
836
Sieve is simpler than LRU
SIEVE is Simpler than LRU: an Efficient Turn-Key Eviction Algorithm for Web Caches
837
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…
838
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.
839
840
Modern Data Practice and the SQL Tradition
This made it to the Hacker News front-page too: some very interesting comments there