Re:Many small queries are efficient in SQLite
by scaladev on Tuesday February 16, 2021 @06:42AM
(#26153019)
Bureaucratic forms have a tendency to change unpredictably. Today they want weight in kilograms, tomorrow they'll want it in grams, and the day after that in standardized intergalactic weight units. I get what you're saying (and I don't like writing unnecessary mapping boilerplate too), but there should be a middle layer to protect the application from craziness like that.
Re:Many small queries are efficient in SQLite
by magicalhippo on Tuesday February 16, 2021 @06:58AM
(#26153105)
Thankfully things in our sector is fairly static in that regard, so this is seldom an issue. That sounds quite horrible indeed.
And yes, a fatter middle layer would be nice. Our next generation software will probably have more of that, this code base is over 20 years old at this point...
Sure we could deal with it, but there are quite a number of tables due to different forms and messages, and then there's all the reports. Many custom ones thanks to to local officials wanting data from a certain customer in a certain way...