News for hackers. Stuff that matters.
Re:The Great Database Migration by sgt101 on Sunday June 30, 2024 @02:22PM (#40838928)
You. Were. Running. An. Insurance. Company. On. SQLite?

What?

What possessed them?

Re:The Great Database Migration by samtho on Sunday June 30, 2024 @03:26PM (#40839498)
The 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.

Re:The Great Database Migration by agent001 on Sunday June 30, 2024 @10:19PM (#40842041)
lol according to github 80 MB is not small - https://docs.github.com/en/repositories/working-with-files/m...
Re:The Great Database Migration by Zambyte on Sunday June 30, 2024 @11:52PM (#40842391)
Git is designed for text files. An 80 MB text file is huge. An 80 MB binary database is tiny.
Re:The Great Database Migration by sgt101 on Monday July 01, 2024 @11:06AM (#40846493)
I depends what you are putting into it... I think it's completely feasible to get 100000 customer records into 80 MB... and then some
Re:The Great Database Migration by lomase on Monday July 01, 2024 @05:50AM (#40844154)
Git is a tool to diff code. Github host git repositories.

You are using Github to store data, not code.

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!
Re:The Great Database Migration by Exoristos on Sunday June 30, 2024 @04:26PM (#40840098)
True in many ways, yet Excel is considerably more robust.
Re:The Great Database Migration by simonw on Sunday June 30, 2024 @04:59PM (#40840319)
Can you back that up? SQLite has an extremely strong reputation for robustness.
Re:The Great Database Migration by lucb1e on Sunday June 30, 2024 @07:15PM (#40841195)
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.

Re:The Great Database Migration by roblh on Sunday June 30, 2024 @09:19PM (#40841789)
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.
Re:The Great Database Migration by sgt101 on Monday July 01, 2024 @11:08AM (#40846515)
utterly utterly unhinged.

It's basically a design that someone both very naive and suffering late stage Rabies would come up with.

Re:The Great Database Migration by AtlasBarfed on Sunday June 30, 2024 @07:22PM (#40841254)
Well snapshotting/backup isn't hard