Østjyllands Brandvæsen maintains a MySQL database that they update on a regular basis. Allegro IT ApS built a standardised import script for this database so routine updates can be carried out without developer involvement every time.
The solution is delivered as a SQL file that is opened in MySQL Workbench and executed. That means a staff member with basic technical background can run the import themselves when new data comes in — without having to file a ticket with us, and without the risk that ad-hoc, manually written SQL statements break existing records.
It's a small but practical solution: no application to host, no dependencies to maintain, and nothing that can break at the next OS or browser update. Just a file that does its job and can be stored alongside the rest of the organisation's documentation.
