-
Database Planet Collision: When PG Falls for DuckDB
2025-03-12 in Database
When I published “PostgreSQL Is Eating the Database World” last year, I tossed out this wild idea: Could Postgres really unify OLTP and OLAP? I had no clue we’d see fireworks so quickly. The PG community’s now in an all-out frenzy to stitch DuckDB …
-
Self-Hosting Supabase on PostgreSQL
2024-11-25 in Database
Supabase is great, own your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade supabase on local/cloud VM/BMs. What is Supabase? Supabase is an open-source Firebase alternative, a Backend as a Service …
-
MySQL is dead, Long live PostgreSQL!
2024-07-08 in Database
This July, MySQL 9.0 was finally released—a full eight years after its last major version, 8.0 (@2016-09). Yet, this hollow “innovation” release feels like a bad joke, signaling that MySQL is on its deathbed. While PostgreSQL continues to …
-
MySQL's Terrible ACID
2023-12-28 in Database
MySQL was once the world’s most popular open-source relational database. But popularity doesn’t equal excellence, and popular things can have major issues. JEPSEN’s isolation level evaluation of MySQL 8.0.34 has blown the lid off …
-
Database in K8S: Pros & Cons
2023-12-06 in Database
Whether databases should be housed in Kubernetes/Docker remains highly controversial. While Kubernetes (k8s) excels in managing stateless applications, it has fundamental drawbacks with stateful services, especially databases like PostgreSQL and …
-
NewSQL: Distributive Nonsens
2023-05-07 in Database
WeChat Column As hardware technology advances, the capacity and performance of standalone databases have reached unprecedented heights. In this transformative era, distributed (TP) databases appear utterly powerless, much like the “data middle …
-
Is running postgres in docker a good idea?
2019-01-13 in Database
For stateless app services, containers are an almost perfect devops solution. However, for stateful services like databases, it’s not so straightforward. Whether production databases should be containerized remains controversial. From a …