I built a postgREST-backed todo list app with a twist. PostgREST also serves the initial HTML page which loads a single Javascript file, frontend.js, from CDN with sub-resource integrity check. I built the frontend with Preact+HTM+Tailwind but any JS-framework that generates a single file for browser would work. The idea was to explore if this model could simplify development of self-hostable open-source webapps, and it seems yes. Users just have to run backend.sql file. No need to upgrade anything for UI changes and no need to maintain server-side language environments/frameworks.
Explainer post:
backend.sql + frontend.js = ❤️
Github repo
Discuss on Hacker News