-
Whoever Integrates DuckDB Best Wins the OLAP World
2024-08-13 in Postgres
In the post “PostgreSQL is Eating the World”, I posed a question: Who will ultimately unify the database world? My take is that it’ll be the PostgreSQL ecosystem coupled with a rich variety of extension plugins. And I believe that to conquer …
-
StackOverflow 2024 Survey: PostgreSQL Is Dominating the Field
2024-07-25 in Postgres
2024 StackOverflow Global Developer Survey Results have just been released, featuring high-quality responses from 60,000 developers in 185 countries and regions. Naturally, as a seasoned database aficionado, the part I’m most interested in is the …
-
Self-Hosting Dify with PG, PGVector, and Pigsty
2024-06-22 in Postgres
Dify – The Innovation Engine for GenAI Applications Dify is an open-source LLM app development platform. Orchestrate LLM apps from agents to complex AI workflows, with an RAG engine. Which claims to be more production-ready than LangChain. Of …
-
PGCon.Dev 2024, The conf that shutdown PG for a week
2024-06-17 in Postgres
PGCon.Dev, once known as PGCon—the annual must-attend gathering for PostgreSQL hackers and key forum for its future direction, has been held in Ottawa since its inception in 2007. This year marks a new chapter as the original organizer, Dan, hands …
-
Postgres is eating the database world
2024-03-04 in Postgres
PostgreSQL isn’t just a simple relational database; it’s a data management framework with the potential to engulf the entire database realm. The trend of “Using Postgres for Everything” is no longer limited to a few elite teams but is becoming a …
-
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 …
-
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, …