Sponsor of the Day:
Jerkmate
https://docs.postgrest.org/en/v14/integrations/pg-safeupdate.html
pg-safeupdate — PostgREST 14 documentation
Block Full-Table Operations: If the active role can delete table rows then the DELETE verb is allowed for clients. Here’s an API request to delete old rows...
postgrest 14 documentationpg
https://docs.postgrest.org/en/v14/explanations/nginx.html
Nginx — PostgREST 14 documentation
PostgREST is a fast way to construct a RESTful API. Its default behavior is great for scaffolding in development. When it’s time to go to production it works...
postgrest 14 documentationnginx
https://docs.postgrest.org/en/v14/explanations/architecture.html
Architecture — PostgREST 14 documentation
This page describes the architecture of PostgREST. Bird’s Eye View: You can click on the components to navigate to their respective documentation. Code Map:...
postgrest 14 documentationarchitecture
https://docs.postgrest.org/en/v14/references/schema_cache.html
Schema Cache — PostgREST 14 documentation
PostgREST requires metadata from the database schema to provide a REST API that abstracts SQL details. One example of this is the interface for Resource...
postgrest 14 documentationschemacache
https://docs.postgrest.org/en/v14/references/cli.html
CLI — PostgREST 14 documentation
PostgREST provides a CLI with the options listed below: FILENAME: Runs PostgREST with the given Config File. Help: Shows all the options available. Version:...
postgrest 14 documentationcli
https://docs.postgrest.org/en/v14/references/admin_server.html
Admin Server — PostgREST 14 documentation
PostgREST provides an admin server that can be enabled by setting admin-server-port. Health Check: You can enable a health check to verify if PostgREST is...
postgrest 14 documentationadminserver
https://postgrest.org/en/stable/integrations/systemd.html
systemd — PostgREST 14 documentation
For Linux distributions that use systemd(Ubuntu, Debian, Arch Linux) you can create a daemon in the following way. First, create postgrest configuration...
postgrest 14 documentationsystemd
https://docs.postgrest.org/en/v14/explanations/db_authz.html
Database Authorization — PostgREST 14 documentation
Database authorization is the process of granting and verifying database access permissions. PostgreSQL manages permissions using the concept of roles. Users...
postgrest 14 documentationdatabaseauthorization
https://postgrest.org/en/stable/references/api/tables_views.html
Tables and Views — PostgREST 14 documentation
All tables and views of the exposed schema and accessible by the active database role are available for querying. They are exposed in one-level deep routes....
postgrest 14 documentationtablesviews
https://docs.postgrest.org/en/v14/how-tos/create-soap-endpoint.html
Create a SOAP endpoint — PostgREST 14 documentation
author, fjf2002,. PostgREST supports Media Type Handlers. With a bit of work, SOAP endpoints become possible. Minimal Example: This example will simply return...
postgrest 14 documentationcreatesoapendpoint