3 ms·
If the problem was as simple you make it, you could write your backend code only once, then re-use it in every project. Why you are expecting a relational data
by takeda 10y ago
If the problem was as simple you make it, you could write your backend code only once, then re-use it in every project.
Why you are expecting a relational database which has many more use cases than the web programming (and web is not even a primary one) to solve this difficult task for small use cases?
Anyway, there were attempts in solving this and those were called frameworks, which shows that hardly there's a one size fit all. If you use a framework and have complex project you reach a point where the framework will just stay in your way.
> Exactly. It doesn't have to suck - our databases could provide a nice interface to do all this stuff cleanly instead. We just need a resumable event stream, with versions and some other API tweaks and we can do computed views out-of-process of the database, written in whatever language I want.
Not really, a database as name suggests is meant for storing data, it's an already a difficult task by itself (if you want durability and still make it fast). What you need is a backend code that provides this functionality.
> I'm firmly of the opinion that all databases should provide a Samza / Storm / Kafka / etc style event log.
All the technologies you described are stream processors, while they work on data, they operate completely different than a database and they have different use cases. Postgres does have LISTEN/NOTIFY but that's meant more like a side channel for communication.
Perhaps what you need is AQMP?