4 ms·
> My group writes .NET code If you are clever enough, your current ecosystem can be bent into a "low" code arrangement. We pushed most of our logic into SQL
by bob1029 3y ago
> My group writes .NET code
If you are clever enough, your current ecosystem can be bent into a "low" code arrangement.
We pushed most of our logic into SQL queries over time. Domain experts write "code" these days. This was only possible after years of refining our schema relative to our customers and problems. Learning what should be configurable and what should not. To do this effectively usually requires that you already wrote a lot of code.
SQL databases are a superpower. I feel like they are your ultimate low code platform. Especially SQLite, which can run literally anywhere. In this arrangement, the query planner and virtual machine are your programming staff. The quality of this low code ecosystem is entirely defined by the imagination of the person responsible for designing the schema.
If you find yourself having a really hard time writing a query that seems somewhat ordinary for your problem domain, it might be an indication of a skill issue with your DBAs or schema author. This is where low code typically goes off the rails. Your in-house employees are also now customers and you have to accommodate their requirements in addition to the ones that these abstractions are ultimately trying to address for your outside customers.
- jiriro 3y agoWould you mind elaborating on “pushing logic into SQL queries”? Also how “SQL databases are a superpower”? I suppose one still needs a non trivial dev infrastructure and dev skills to make the SQL a superpower:-|
- bob1029 3y ago> I suppose one still needs a non trivial dev infrastructure and dev skills to make the SQL a superpower:-| Exactly. My intended takeaway from this is that there is no free lunch unless your business is super simple.
- sfn42 3y agoI'm not them but I'll translate for you. They had a shitty app that did dumb stuff that SQL can do for them. Someone finally figured out how SQL works and wrote some proper queries and now they think they're geniuses.