I would use Elixir (Phoenix + liveView), to me its the most productive stack for web apps at the moment.
You can have SPA like user experience without building a separate frontend & backend. That simplifies things ALOT!
For data persistence, I would consider SQLite otherwise go with Postgres.
I think there's a certain class of small to medium sized application (I'm building several) where liveview can be a good fit, but after writing it professionally and in hobby projects for several years, I'm less convinced that it's a great solution everywhere.
In theory, it sounds like this could be the sweet-spot for using the Javascript ecosystem where its required where LiveView fall short.
[0]: https://github.com/woutdp/live_svelte
[1]: https://dockyard.com/blog/2024/03/14/harnessing-liveview-and...