Posts in 2024
  • 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 …

    Read more

  • v2.6.0 Release Note

    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 …

    Read more

Posts in 2023
  • S3: Elite to Mediocre

    2023-12-26 in Cloud Exit

    WeChat Column | Vonng’s Blog 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 …

    Read more

  • DB in K8S: Pros & Cons

    2023-12-06 in Database

    WeChat Column | 中文版 | Medium 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 …

    Read more

  • PostgreSQL Convention 2024

    2023-11-27 in Postgres

    WeChat Column 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 …

    Read more

  • Reclaim Hardware Bonus from the Cloud

    2023-11-16 in Cloud Exit

    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.0 Release Note

    2023-10-24 in Releases

    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.0 Release Note

    2023-09-14 in Releases

    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.0 Release Note

    2023-08-20 in Releases

    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

  • v2.2.0 Release Note

    2023-08-04 in Releases

    v2.2.0 https://github.com/Vonng/pigsty/releases/tag/v2.2.0 Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)" Release Note: https://doc.pigsty.cc/#/RELEASENOTE?id=v220 Highlight Monitoring Dashboards Overhaul: …

    Read more