PostgreSQL

PostgreSQL is an open source object-relational database. It needs a server to host the database (you can’t just run it in Github pages), but offers powerful search features and excellent performance.

To set up a new database, see the tutorial. You can connect to the database using many different clients; which one you choose to use will depend on your stack of backend and frontend software.

• If you are using Python on the backend, you can consider psycopg3 or psycodict.
• For plain Ruby, you can use ruby-pg. If you are using Ruby on rails, it comes with built-in postgres adapters
• There are also many ways to connect to postgres from Javascript, including Postgres.js, node-postgres.

This page is a stub. If you are interested in writing a better version, please contact an editor or submit a pull request.