From: | Pigsty via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
Subject: | Pigsty v3: 336 extensions and MSSQL/Oracle flavor PG kernels! |
Date: | 2024-09-23 05:12:03 |
Message-ID: | 172706832391.694.2362398691765693695@wrigleys.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
The [Pigsty](https://pigsty.io/) community is thrilled to announce Pigsty [v3.0](https://github.com/Vonng/pigsty/releases/tag/v3.0.0), which delivers [336](https://pigsty.io/docs/pgext/list/) unique extensions. and several in-place PG kernel replacements.
You can replace vanilla PostgreSQL with [Babelfish](https://pigsty.io/docs/kernel/babelfish/) for MSSQL compatibility, with [`IvorySQL`](https://pigsty.io/docs/kernel/ivorysql) for ORACLE compatibility, and [`PolarDB`](https://pigsty.io/docs/kernel/polardb/) for Aurora flavor. You can also wrap any existing PostgreSQL kernel / RDS with add-ons: serving MongoDB wire protocol with the latest [`FerretDB`](https://pigsty.io/docs/ferret/) or the self-hosting firebase alternative [`Supabase`](https://pigsty.io/docs/kernel/supabase/), which is newly available on Debian/Ubuntu in addition to EL distros.
We also have [`DuckDB`](https://pigsty.io/docs/pro/duckdb/) support with the CLI binary and PostgreSQL extensions, such as `pg_lakehouse` / `pg_analytics` / `duckdb_fdw` and `pg_duckdb` (alpha) and many other extensions, to serve the OLAP race in the PG ecosystem. Check the complete [release note](https://pigsty.io/blog/releases/v3.0.0/) for all the details.
## About Pigsty
Pigsty is a Battery-included, local-first PostgreSQL Distribution as an open-sourced RDS alternative.
Links: [Website](https://pigsty.io/) | [GitHub](https://github.com/Vonng/pigsty) | [Demo](https://demo.pigsty.cc/) | [Get Started](https://pigsty.io/docs/setup/install/) | [Features](https://pigsty.io/docs/about/feature/) | [v3.0.0 Release Note](https://pigsty.io/blog/releases/v3.0.0/)
```bash
curl -fsSL https://repo.pigsty.io/get | bash
```
#### Features
- [Extensible](https://pigsty.io/img/pigsty/extension.png): 336 [PG Extensions](https://pigsty.io/docs/pgext/list) & 6 [PG Kernel](https://pigsty.io/docs/kernel) replacements available (e.g., [MSSQL](https://pigsty.io/docs/kernel/babelfish/), [Oracle](https://pigsty.io/docs/kernel/ivorysql/) compatibility).
- [Reliable](https://pigsty.io/img/pigsty/arch.jpg): Self-healing [HA](https://pigsty.io/docs/concept/ha/) clusters with pre-configured [PITR](https://pigsty.io/docs/pgsql/arch#point-in-time-recovery) and built-in [ACL](https://pigsty.io/docs/pgsql/acl), [CA & SSL](https://pigsty.io/docs/reference/param/#ca) secure best practice.
- [Observable](https://pigsty.io/img/pigsty/dashboard.jpg): SOTA monitoring for [PG](https://demo.pigsty.cc/d/pgrds-instance/pgrds-instance) / [Infra](https://pigsty.io/docs/infra) / [Node](https://pigsty.io/docs/node) based on Prometheus & Grafana stack: [Demo](https://demo.pigsty.cc/) & [Gallery](https://github.com/Vonng/pigsty/wiki/Gallery).
- [Available](https://pigsty.io/img/pigsty/ha.png): Auto-routed & pooled customizable database [Services](https://pigsty.io/docs/concept/svc#default-service) [Access](https://pigsty.io/docs/concept/svc#access-service) with haproxy, pgbouncer, and VIP.
- [Maintainable](https://pigsty.io/img/pigsty/iac.jpg): [One-Cmd Install](https://pigsty.io/docs/setup/install), [Admin SOP](https://pigsty.io/docs/pgsql/admin), Auto-Tune, Local Repo, [IaC,](https://pigsty.io/docs/pgsql/config) and [Vagrant](https://pigsty.io/docs/setup/provision#vagrant) / [Terraform](https://pigsty.io/docs/setup/provision#terraform) support.
- [Composable](https://pigsty.io/img/pigsty/sandbox.jpg): Bonus [Modules](https://pigsty.io/docs/about/modules) such as [Redis](https://pigsty.io/docs/redis), [MinIO](https://pigsty.io/docs/minio), [Etcd](https://pigsty.io/docs/etcd), [Docker](https://pigsty.io/docs/app), [DuckDB](https://pigsty.io/docs/pro/duckdb), [FerretDB](https://pigsty.io/docs/ferret), [Supabase](https://pigsty.io/docs/kernel/supabase/), [& more](https://pigsty.io/docs/pro/)!
#### Advantages
- Unparalleled Extension: We packed 138 [RPM](https://pigsty.io/docs/pgext/list/rpm) and 133 [DEB](https://pigsty.io/docs/pgext/list/deb) extensions in addition to the official PGDG repo.
- Stunning Observability: Ultimate experience with 3000+ metrics visualized in 30+ organized dashboards.
- Reliable Best Practices: Proven & Polished in large-scale production environment (25K vCPU) for 5 years+.
- NO Docker/Kubernetes: We choose the hard way to deliver RDS based on bare OS WITHOUT [Containers](https://pigsty.io/blog/db/db-in-k8s/)!
- Infrastructure as Code: Describe everything with declarative API and provision with idempotent playbooks!
- Free OSS & Local-First: Pigsty is a free software under [AGPLv3](https://pigsty.io/docs/about/license/). Build for PostgreSQL with passion & love.
From | Date | Subject | |
---|---|---|---|
Next Message | pgAdmin Development Team via PostgreSQL Announce | 2024-09-23 13:21:47 | pgAdmin 4 v8.12 Released |
Previous Message | pgEdge, Inc. via PostgreSQL Announce | 2024-09-22 07:46:02 | pgEdge Distributed PostgreSQL: The Next Generation — Introducing pgEdge Platform v24.7, Constellation Release |