Giter VIP home page Giter VIP logo

postgres's Introduction

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.

Primary Features

Extensions

Extension Description
Postgres contrib modules Because everyone should enable pg_stat_statements.
PostGIS Postgres' most popular extension - support for geographic objects.
pgRouting Extension of PostGIS - provides geospatial routing functionalities.
pgTAP Unit Testing for Postgres.
pg_cron Run CRON jobs inside 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.
pg-safeupdate Protect your data from accidental updates or deletes.
wal2json JSON output plugin for logical replication decoding.
PL/Java Write in Java functions in Postgres.
plv8 Write in Javascript functions in Postgres.

Can't find your favorite extension? Suggest for it to be added into future versions here!

Enhanced Security

Aside from having ufw,fail2ban, and unattended-upgrades installed, we also have the following enhancements in place:

Enhancement Description
fail2ban filter for PostgreSQL access Monitors for brute force attempts over at port 5432.
fail2ban filter for PgBouncer access Monitors for brute force attempts over at port 6543.

Additional Goodies

Goodie Description
PgBouncer Set up Connection Pooling.
PostgREST Instantly transform your database into an RESTful API.
WAL-G Tool for physical database backup and recovery.

Install

See all installation instructions in the repo wiki.

Docker Digital Ocean AWS

Marketplace Images

Postgres & Extensions PgBouncer PostgREST WAL-G
Supabase Postgres ✔️ ✔️
Supabase Postgres: PgBouncer Bundle ✔️ ✔️ ✔️
Supabase Postgres: PostgREST Bundle ✔️ ✔️ ✔️
Supabase Postgres: Complete Bundle ✔️ ✔️ ✔️ ✔️

Availability

AWS ARM AWS x86 Digital Ocean x86
Supabase Postgres Coming Soon Coming Soon Coming Soon
Supabase Postgres: PgBouncer Bundle Coming Soon Coming Soon Coming Soon
Supabase Postgres: PostgREST Bundle Coming Soon Coming Soon Coming Soon
Supabase Postgres: Complete Bundle Coming Soon Coming Soon Coming Soon

Quick Build

$ time packer build -timestamp-ui \
  --var "aws_access_key=<insert aws access key>" \
  --var "aws_secret_key=<insert aws secret key>" \
  --var "ami_regions=<insert desired regions>" \
  amazon-arm.json

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

postgres's People

Contributors

awalias avatar bjoernakamanf avatar darora avatar dragarcia avatar inian avatar kiwicopple avatar olirice avatar

Watchers

 avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.