/postgres

Unmodified Postgres with some useful plugins

Primary LanguageShellPostgreSQL LicensePostgreSQL

Postgres + goodies

Unmodified Postgres with some useful plugins. Our goal with this repo is not to modify Postgres, but to provide some of the most common extensions with a one-click install.

Features

  • ✅ Postgres 12. Includes generated columns and JSON path support.
  • ✅ Ubuntu 18.04 (Bionic).
  • pg-contrib-12. Because everyone should enable pg_stat_statements.
  • wal_level = logical and max_replication_slots = 5. Ready for replication.
  • PostGIS. Postgres' most popular extension - support for geographic objects.
  • pgTAP. Unit Testing for Postgres.
  • pgAudit. Generate highly compliant audit logs.
  • pgjwt. Generate JSON Web Tokens (JWT) in Postgres.
  • pgsql-http. HTTP client for Postgres.
  • plpgsql_check. Linter tool for PL/pgSQL.
  • plv8. Write in Javascript functions in Postgres.
  • PL/Java. Write in Java functions in Postgres.
  • pg_cron. Run CRON jobs inside Postgres.
  • pg-safeupdate. Protect your data from accidental updates or deletes.

Install

See all installation instructions in the repo wiki.

Docker Digital Ocean AWS

Motivation

After talking to a lot of techies, we've found that most believe Postgres is the best (operational) database but they still choose other databases. This is overwhelmingly because "the other one was quicker/easier". Our goal is to make it fast and simple to get started with Postgres, so that we never hear that excuse again.

Our secondary goal is to show off a few of Postgres' most exciting features. This is to convince new developers to choose it over other database (a decision we hope they'll appreciate once they start scaling).

Finally, this is the same build we offer at Supabase, and everything we do is opensource. This repo makes it easy to install Postgres, Supabase makes it easy to use Postgres.

Roadmap

License

The PostgreSQL License. We realize that licensing is tricky since we are bundling all the various plugins. If we have infringed on any license, let us know and we will make the necessary changes (or remove that extension from this repo).

Sponsors

We are building the features of Firebase using enterprise-grade, open source products. We support existing communities wherever possible, and if the products don’t exist we build them and open source them ourselves.

New Sponsor