Posts in 2024
  • v2.7: Extension Overwhelming

    2024-05-20 in Releases

    Featured Image for v2.7: Extension Overwhelming

    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 …

    Read more

  • Postgres is eating the database world

    2024-03-04 in Postgres

    Featured Image for Postgres is eating the database world

    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 …

    Read more

  • v2.6: the OLAP New Challenger

    2024-02-22 in Releases

    Featured Image for v2.6: the OLAP New Challenger

    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 …

    Read more

Posts in 2023
  • S3: Elite to Mediocre

    2023-12-26 in Cloud Exit

    Featured Image for S3: Elite to Mediocre

    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 …

    Read more

  • Database in K8S: Pros & Cons

    2023-12-06 in Database

    Featured Image for Database in K8S: Pros & Cons

    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 …

    Read more

  • PostgreSQL Convention 2024

    2023-11-27 in Postgres

    Featured Image for PostgreSQL Convention 2024

    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, …

    Read more

  • Reclaim Hardware Bonus from the Cloud

    2023-11-16 in Cloud Exit

    Featured Image for Reclaim Hardware Bonus from the Cloud

    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 …

    Read more

  • v2.5: Debian / Ubuntu / PG16

    2023-10-24 in Releases

    Featured Image for v2.5: Debian / Ubuntu / PG16

    v2.5.0 curl https://get.pigsty.cc/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 …

    Read more

  • v2.4: Monitoring Cloud RDS

    2023-09-14 in Releases

    Featured Image for v2.4: Monitoring Cloud RDS

    v2.4.0 Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)". Highlights PostgreSQL 16 support The first LTS version with business support and consulting service Monitoring existing PostgreSQL, RDS for PostgreSQL / PolarDB …

    Read more

  • v2.3: Ecosystem Applications

    2023-08-20 in Releases

    Featured Image for v2.3: Ecosystem Applications

    v2.3.0 PGSQL/REDIS Update, NODE VIP, Mongo/FerretDB, MYSQL Stub Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)" Highlight INFRA: NODE/PGSQL VIP monitoring support NODE: Allow bind node_vip to node cluster with …

    Read more