-
Pig, The Postgres Extension Wizard
2024-12-29 in Postgres
Title: Meet Pig: The Postgres Extension Wizard Ever wished installing or upgrading PostgreSQL extensions didn’t feel like digging through outdated readmes, cryptic configure scripts, or random GitHub forks & patches? The painful truth is that …
-
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 …
-
v3.1: PG 17 as default, Better Supabase & MinIO, ARM & U24 support
2024-11-24 in Releases
With the release of PostgreSQL 17.2 earlier this week, Pigsty promptly followed up with its v3.1 release. In this version, PostgreSQL 17 has been promoted as the default major version, and nearly 340 PostgreSQL extensions are now available out of the …
-
The idea way to install PostgreSQL Extensions
2024-11-02 in Postgres
PostgreSQL Is Eating the Database World through the power of extensibility. With 340 extensions powering PostgreSQL, we may not say it’s invincible, but it’s definitely getting much closer. I believe the PostgreSQL community has reached a …
-
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 340 available extensions for PostgreSQL. This includes 121 …
-
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 …