4 ms·
This is called PostgREST: https://postgrest.org/ https://postgrest.org/. Never used it in production, but PostgREST leverages multiple PostgreSQL features: row-
by FrancoisBosun 4y ago
This is called PostgREST: https://postgrest.org/ https://postgrest.org/. Never used it in production, but PostgREST leverages multiple PostgreSQL features: row-based security, schemas, authorizations, etc. I quite like PostgREST, and I'd use it for internal stuff.
- spoiler 4y agoWe used PostgREST in a project at my previous company, and it's the most horrendous thing imaginable. The project is a meme in the company and nobody wants to work on it, including its author (who decided to switch teams becaus of how much he hated it). I don't know if this was because of PostgREST or because all the logic was encoded in grotesque looking SQL that nobody understood (and changing some things requires dropping and readding things). It is an extremely cool project, don't get me wrong, but it's one of those things that's "I know this already and I'll use it for a weekend/poc project to not deal with writing a backend" and not for something important. And again, I don't know if this was just poor usage or something that manifests itself in every project that relies on it. Also the DSL is very much it's own thing, so migrating away from it is painful, especially if you inherited the project and don't want to read the document. But again, sample size is 1, so it's anecdotal.
- nick__m 4y agoI tried PostgREST for a small internal and it was a decent experience. I followed the following rules: 1- Don't expose your real database but expose a database consisting of view on your real database so you can refactor. 2- Wrap your bussines logic in stored proc to keep your sql readable 3- Use jwt for authentication That said, I would not recommend it for a large scale application. I consider it, maybe wrongly, as the MSAccess of the backend.