Managed PostgreSQL, in the region you choose
You get a database, not a server: there is no instance to size, patch or back up by hand. Pick a region and a PostgreSQL version, and connect your application with a login of its own.
Closed
Until you open it
One login
Per application
One region
The one you choose
What it runs
In the region you choose
Each database lives in exactly one region, the one you picked when you created it, so you decide how far your queries travel.
Closed until you open it
A new database has no public endpoint. Turning internet access on means naming the address ranges that may connect, and nothing else can.
A login per application
Each application gets its own credentials and its own permissions, so taking one away leaves the others running.
import { Pool } from "pg";
const pool = new Pool({
connectionString: process.env.DATABASE_URL,
});
const { rows } = await pool.query(
"SELECT * FROM users WHERE active = $1",
[true],
);
console.log(rows);Query it from the browser
The SQL Workbench runs statements from the console without opening your database to the internet. It can change your data and your schema, and it cannot create databases, create roles or grant them, so it never steps outside the database you gave it.