Pigsty v3: 336 extensions and MSSQL/Oracle flavor PG kernels!

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Pigsty via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: Pigsty v3: 336 extensions and MSSQL/Oracle flavor PG kernels!
Date: Mon, 23 Sep 2024 05:12:03 +0000
Message-ID: <[email protected]> (raw)

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.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Pigsty v3: 336 extensions and MSSQL/Oracle flavor PG kernels!
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox