PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch. - postgrest github
Use postgrest (github) as an npm module for tighter integration with node apps (e.g. test fixtures). Also enables postgrest usage in serverless environments.
npm install postgrest-dist
import postgrest from "postgrest-dist";
// Use environment variables to configure postgrest, see https://postgrest.org/en/stable/references/configuration.html
const server = await postgrest();
// Or pass in a custom environment in js, which will be combined with the env of the current process.
const server = await postgrest({
PGRST_DB_URI: "postgres://postgres@127.0.0.1:5432/postgres",
});
// also works with using unix sockets:
const server = await postgrest({
PGRST_DB_URI: "postgres:///postgres?host=/var/run/postgresql",
PGRST_SERVER_UNIX_SOCKET: resolve(socketDir, "postgrest.sock"),
});
// And shut down when you are done
server.stop();- Seems like upstream postgrest manually builds darwin-arm64, so those are often not available at the same time as the rest