booooop [any]

If testing this properly is your problem you should invest time in integration testing, running them on an in-memory database is an option as well. I think retrieving all the data and “caching” it like you call it has some negative consequences, for example what if the validation for some action fails and you didn’t need to load whatever you preloaded? Waste of a call to the db

I’ve taken smartphones and laptops, given for work but then never returned when leaving. Nothing permanent for hosting but I have used our infra for games and file sharing.