PostgREST, a software program that converts PostgreSQL into a REST API, has released version 12, introducing a key feature known as Media Type Handlers. This feature allows for the direct creation of web applications from the database using SQL and HTMX languages.
In reality, this feature enables functions in PostgREST to return data in any format, not just limited to web applications. However, utilizing PostgREST for web development allows for the creation of fully functional applications solely within PostgREST itself.
In addition, PostgREST also offers various sub-features, including:
1. JWT Caching: This feature performs a single JWT validation and then caches the value according to the JWT’s lifespan. This eliminates the need to validate JWTs every time, resulting in a processing time savings of up to 130ms.
2. Server Timing: This feature displays header information indicating the duration of query processing and its associated components.
3. Aggregate Functions: PostgREST supports various aggregate functions such as counting values, calculating averages, and finding minimum/maximum values.
You can download the program from GitHub.
TLDR: PostgREST, a PostgreSQL to REST API converter, introduces version 12 with the Media Type Handlers feature. This allows for direct web application creation using SQL and HTMX languages. Additional features include JWT Caching, Server Timing, and support for aggregate functions. Download available on GitHub.
Leave a Comment