Re:Write code. Not too much. Mostly functions.
by dathinab on Tuesday December 22, 2020 @12:25AM
(#25503179)
The thing about modelling is that it often works on a higher abstraction level then the programming languages provide and that a bunch of (often performance related) thinks are (preferably) not represented in modelling.
This IMHO makes most tools to generate code from models just painful to use.
But I still agree that you have no business programming something which you can't somewhat model in a higher abstraction level.
> SQL is the king of managing data
Hm, not so much IMHO. SQL Is terrible bad at it in some contexts because it's inherently made for a 2d table projection which is (more or less) only joined to larger 2d table projections of data which often in it's nature is neither 2d nor maps well to 2d representations. And while you can extend SQL to support that or work around it with e.g. recursive queries it's not very nice to do at all.
This IMHO makes most tools to generate code from models just painful to use.
But I still agree that you have no business programming something which you can't somewhat model in a higher abstraction level.
> SQL is the king of managing data
Hm, not so much IMHO. SQL Is terrible bad at it in some contexts because it's inherently made for a 2d table projection which is (more or less) only joined to larger 2d table projections of data which often in it's nature is neither 2d nor maps well to 2d representations. And while you can extend SQL to support that or work around it with e.g. recursive queries it's not very nice to do at all.