TechEmpower
Creating custom SQL Procedures for framework
I'm interested in adding PostgREST as a framework. PostgREST is different compared to other frameworks in that it keeps all business logic in the database (e.g. through stored procedures).
Is there any way to extend the SQL schema with custom code for a framework? Would that even be allowed at all?
PostgREST doesn't have any mechanism to create the schema / objects itself - it assumes the user to have direct database access and create everything there. It basically works as a proxy that exposes parts of the database through a REST api.
I can't think of an easy way to do this without creating a new database folder specifically for this framework (https://github.com/TechEmpower/FrameworkBenchmarks/wiki/Development-Adding-a-Database) with all of the stored procedures and then a framework folder for the server/api. It's possible to do it, but I'm not sure it's a good fit.
