-
Technical Minimalism: Just Use PostgreSQL for Everything
2024-02-19 in Postgres
This article was originally published by Stephan Schmidt @ KingOfCoders and sparked heated discussions on Hacker News[1]: Using PostgreSQL as a replacement for Kafka, RabbitMQ, ElasticSearch, MongoDB, and Redis is a practical approach that can …
-
ParadeDB: ElasticSearch Alternative in PG Ecosystem
2024-02-18 in Postgres
Original WeChat Article ParadeDB: A New Player in the PostgreSQL Ecosystem YC S23 invested in an exciting new project called ParadeDB. Their slogan? “Postgres for Search & Analytics — Modern Elasticsearch Alternative built on …
-
The Astonishing Scalability of PostgreSQL
2024-01-13 in Postgres
This article outlines how Cloudflare uses 15 PostgreSQL clusters to scale up to 55 million requests per second. How Cloudflare Used 15 PG Clusters to Support 55M QPS | In July 2009, in California, USA, a startup team created a Content Delivery …
-
PostgreSQL Crowned Database of the Year 2024!
2024-01-05 in Postgres
Today, the renowned database popularity ranking site DB-Engines announced its Database of the Year for 2024. PostgreSQL has claimed this honor for the fifth time. Of course, PostgreSQL was also crowned Database of the Year in 2023, 2019, 2018, and …
-
S3: Elite to Mediocre
2023-12-26 in Cloud Exit
Object storage (S3) has been a defining service of cloud computing, once hailed as a paragon of cost reduction in the cloud era. Unfortunately, with the evolution of hardware and the emergence of resources cloud (Cloudflare R2) and open-source …
-
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 …
-
PostgreSQL Convention 2024
2023-11-27 in Postgres
Background 0x01 Naming Convention 0x01 Design Convention 0x01 Query Convention 0x01 Admin Convention Roughly translated from PostgreSQL Convention 2024 with Google. 0x00 Background No Rules, No Lines The functions of PostgreSQL are very powerful, …
-
Reclaim Hardware Bonus from the Cloud
2023-11-16 in Cloud Exit
Hardware is interesting again, with the AI wave fueling a GPU frenzy. However, the intrigue isn’t limited to GPUs —— developments in CPUs and SSDs remain largely unnoticed by the majority of devs. A whole generation of developers is obscured by cloud …
-
v2.5: Debian / Ubuntu / PG16
2023-10-24 in Releases
v2.5.0 curl https://get.pigsty.io/latest | bash Highlights Ubuntu / Debian Support: bullseye, bookworm, jammy, focal Dedicate yum/apt repo on repo.pigsty.cc and mirror on packagecloud.io Anolis OS Support (EL 8.8 Compatible) PG Major Candidate: Use …
-
FerretDB: When PG Masquerades as MongoDB
2023-10-08 in Postgres
MongoDB was once a revolutionary technology that liberated developers from the “schema shackles” of relational databases, enabling rapid application development. However, as time passed, MongoDB gradually drifted away from its open-source …