Same thing I have settled on. Sqlite for quick and easy postgres for scaling. For simple frontends I just use the built in go templates. If I need complex fr

Same thing I have settled on. Sqlite for quick and easy postgres for scaling. For simple frontends I just use the built in go templates. If I need complex frontends for larger apps I use sveltekit/svelte5 for frontend data I just export a single instance of a class that has state/derived fields for data and an isInitialized field that returns a promise for loading the data. Then methods for reloading data, changing data or any actions I need. So all i have to do is await classInstance then use the class data in whatever way I need. Everything is reactive and simple due to states. you can use and update the fields directly like regular js but with global reactivity built in. The data automatically loads the first time the module is imported. due to how esmodule files work. I just have a classInstance.LoadData() after the export. Svelte5 isn't as good with LLM's but with some small instructions about how states, derived, and effects work it works pretty well.