Omnigres: Postgres as a Platform
This is an interesting project, but I&#x27;d be unlikely to use it, for a couple of reasons:<p>- In my experience the performance of the stateful DB server has been the biggest bottleneck when scaling - it&#x27;s much easier to scale the stateless application servers which sit between end user requests and your DB in a traditional architecture. So usually I&#x27;m wanting to move as much work as possible away from the DB in order to squeeze the most out of it before needing to shard the DB or move to a different solution, rather than moving more responsibilities into the DB.<p>- It&#x27;s frankly pretty scary to load a C extension into postgres which is opening ports and parsing requests etc - bugs in it could crash the server or open security holes, and if you were able to exploit a vulnerability you&#x27;d be able to grab any of the data in the DB and easily exfiltrate it. This would be less of an issue if using this for an internal service which isn&#x27;t directly exposed to the internet, but it still could make it easier for an attacker to escalate their access. (This isn&#x27;t a &#x27;it should be rust&#x27; comment really, even if this was in rust it would still be pretty worrying).<p>- Even if think you only need simple CRUD actions, over time you tend to need more and more logic around those actions. Authentication, verification, triggering processes in other systems, maybe you make schema changes and need to adapt requests from old clients, etc.  It&#x27;s really nice to have a more heavyweight application server where you can implement that logic - I&#x27;m pretty skeptical that row level permissions, triggers etc will be able to cleanly handle all those as you add new requirements over time. This applies also to other tools for more directly exposing your DB ( e.g. PostgREST ). IMO starting off using a tool like this is really just setting you up to have to do a pretty painful rebuild later on.<p>Am I missing something here, maybe I have misunderstood the intended use case?