Re:The Great Database Migration
by simonw on Sunday June 30, 2024 @02:53PM
(#40839211)
Sounds like a perfectly cromulent solution to me. It's an upgrade from Excel!
[ Parent
| on HN ]
True in many ways, yet Excel is considerably more robust.
Can you back that up? SQLite has an extremely strong reputation for robustness.
Check the new workflow diagram. If I read it correctly, they still edit the database as a spreadsheet and convert that into sql. The diagram is near this text:
> we reduced the process down to a 1- click solution. We built a dashboard in our underwriting platform that actuaries can visit and request factor changes. With a single click, an asynchronous job kicks off, automating the steps of Google Sheet extraction > parsing > codegen > SQL script generation > PR creation. The only engineering involvement now required is a PR review.
This is completely unhinged, right? Am I crazy? All that work just to make absolutely 100% sure their staff never have to try to learn anything new or modify their processes in any way shape or form.