-
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 …
-
v2.7: Extension Overwhelming
2024-05-20 in Releases
The Pigsty community is thrilled to announce Pigsty v2.7.0, which has 255 unique extensions available, to the free PostgreSQL distribution and RDS alternative. We also have introduced some new docker-compose templates for Odoo, Jupyter, PolarDB, and …
-
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 …
-
v2.6: the OLAP New Challenger
2024-02-22 in Releases
v2.6.0 Highlight Use PostgreSQL 16 as the default major version (16.2) Introduce ParadeDB extensions: pg_analytics, pg_bm25, and pg_sparse Introduce DuckDB and corresponding foreign data wrapper: duckdb_fdw Cloudflare CDN https://repo.pigsty.io and …
-
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 …
-
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 …