Stored procedures | Postgres.FM 016 |
Nikolay and Michael discuss the age-old topic of implementing business logic on the database side versus the application side.
Extending SQL https://www.postgresql.org/docs/curre...
PostgREST https://postgrest.org/en/stable/
PL/pgSQL https://www.postgresql.org/docs/curre...
EdgeDB https://www.edgedb.com/
pgTAP https://pgtap.org/
Sqitch https://sqitch.org/
Flyway https://flywaydb.org/
Liquibase https://www.liquibase.org/
client_min_messages https://www.postgresql.org/docs/curre...
log_min_messages https://www.postgresql.org/docs/curre...
Simplify: move code into database functions (blog post by Derek Sivers) https://sive.rs/pg
PL/sh https://github.com/petere/plsh
Supabase https://supabase.com/
auto_explain.log_nested_statements https://www.postgresql.org/docs/curre...
Hasura https://hasura.io/
-------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.