Project into sqlite on your app server is the main trick I use. Denormalize if you have to.

Hell, for a lot of projects you don't even need to get that fancy. Run a single server with an embedde database, running Go or Java and you're good to go.