3 ms·
We are trying to revive the art in our shop. Just got done building a really clean 3NF model for our problem domain and we are in the process of moving 100% of
by bob1029 5y ago
We are trying to revive the art in our shop. Just got done building a really clean 3NF model for our problem domain and we are in the process of moving 100% of our custom configuration needs to SQL queries.
From a biz strategy perspective, we can scale up a lot faster if all we need to do is find people who know (or can be taught) SQL.
Consider the amount of time it would take to ramp someone on 1 SQL schema vs the entire C# ecosystem.
For us, the application is quickly turning into a dumb funnel that just gets data and requirements (queries) into SQLite databases for eval. We put a web interface around all this so it can be easily managed on a per-customer basis.
When everything is a SQL query, you can trivially export/import/clone customer configurations to rapidly bootstrap new ones.
- JamesSwift 5y agoThis is great if you have highly-connected client apps. Its not as doable when you can't guarantee connectivity. In those cases, you need to ship/duplicate business logic to the clients to work around the network issues. Its a hard problem.
- bob1029 5y agoWe do 100% of our processing server-side. All the hard stuff happens there. Spreading biz state across multiple computers would be a massive mistake for our application. Our client devices are effectively dumb terminals that just send user events to the server and display whatever view model is returned.