-
PostgreSQL 17 Released: The Database That's Not Just Playing Anymore!
2024-09-26 in Postgres
The annual PostgreSQL major release is here! What surprises does PostgreSQL 17 have in store for us? In this release announcement, the PostgreSQL global community has finally dropped the act — sorry, we’re not playing anymore — …
-
Can PostgreSQL Replace Microsoft SQL Server?
2024-09-02 in Postgres
Many people don’t have a clear picture of how far the PostgreSQL ecosystem has evolved. Beyond devouring the database world with its all-encompassing extension ecosystem, PostgreSQL can now directly replace Oracle, SQL Server, and MongoDB at …
-
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 …
-
Pigsty v3.0: Extension Exploding & Plugable Kernels
2024-08-05 in Releases
Get started with: curl -fsSL https://repo.pigsty.io/get | bash cd ~/pigsty; ./bootstrap; ./configure; ./install.yml Highlight Features Extension Exploding: Pigsty now has an unprecedented 400 available extensions for PostgreSQL. This includes 121 …
-
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 …
-
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 …