postgrest-dist

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.

Usage

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://[email protected]: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();

TODO

• Seems like upstream postgrest manually builds darwin-arm64, so those are often not available at the same time as the rest