5 ms·
You. Were. Running. An. Insurance. Company. On. SQLite? What? What possessed them?
by sgt101 2y ago
You. Were. Running. An. Insurance. Company. On. SQLite?
What?
What possessed them?
- simonw 2y agoSounds like a perfectly cromulent solution to me. It's an upgrade from Excel!
- Exoristos 2y agoTrue in many ways, yet Excel is considerably more robust.
- simonw 2y agoCan you back that up? SQLite has an extremely strong reputation for robustness.
- lucb1e 2y agoCheck 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.
- roblh 2y agoThis 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.
- sgt101 2y agoutterly utterly unhinged. It's basically a design that someone both very naive and suffering late stage Rabies would come up with.
- samtho 2y agoThe database in question was 80mb, which is very small. It’s also fast and backups are as simple as copying the file. Not advocating for this particular use case, but we’ve all seen more egregious abuses of SQLite.
- agent001 2y agolol according to github 80 MB is not small - https://docs.github.com/en/repositories/working-with-files/managing-large-files/about-large-files-on-github https://docs.github.com/en/repositories/working-with-files/m...
- Zambyte 2y agoGit is designed for text files. An 80 MB text file is huge. An 80 MB binary database is tiny.
- sgt101 2y agoI depends what you are putting into it... I think it's completely feasible to get 100000 customer records into 80 MB... and then some
- lomase 2y agoGit is a tool to diff code. Github host git repositories. You are using Github to store data, not code.
- AtlasBarfed 2y agoWell snapshotting/backup isn't hard