Building and automating your SaaS with a Swagger specification
Do you know the Row Level Security of PostgreSQL? What about the policies? Did you know that you can complete an insertion in every view, or send a message (e.g., in a RabbitMQ) to everything that users create?
Let’s learn together how to use the PostgreSQL database by going back to first principles – what it does best, how to ensure information consistency, managing access rights to data, and managing data presentation.
We’ll see the philosophy behind Postgrest and PostGraphQL/Sub0 to create a version-controlled, authenticated and extremely high-performance and secure API by declaring our data structures and our data and role constraints with pipsql.