rails, postgres, PORO, and htmx is a monstrously productive stack
If it was going to be read heavy I think I'd also pair that with SQLite for low latency and cheaper deployments.
If I didn't know exactly how requirements are likely to change over time I'd probably go with with Rails, Postgres[2], Redis and Hotwire. You can go a long way with that and a small team.
deprecated. they use stimulus and its worse obfuscated JS than htmx IMO