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.
✅ readonly role. A readonly role set up by default for the public schema.
✅ 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
✅ plv8 - Write in Javascript functions in Postgres.
✅ plpython3u - Python3 enabled by default. Write in Python functions in Postgres.

Install

See all installation instructions in the repo wiki.

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

Support for more images
Vote for more plugins/extensions
Open a github issue if you have a feature request

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).