Toggle menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

PostgreSQL

From Nest Guides
Revision as of 01:05, 28 March 2024 by Samuel (talk | contribs) (Add PostgreSQL page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

PostgreSQL is a popular and widely-used SQL relational database. It's used for projects as small as my tiny side projects as well as projects as large as HCB. Since it's used so often, Nest runs an instance of Postgres that you can use without having to spin up a whole new instance that could use a lot of resources.

How to use Nest Postgres

Nest Postgres is just a simple instance of PostgreSQL 16 that you can access with your Nest username and password. To launch the Postgres client, you can simply run:

psql

and you'll enter the interactive Postgres shell where you can run SQL like normal. Since Nest Postgres is publicly accessible, you can also connect to it from any other machine, including wherever your apps may run, such as Vercel!