Derek Sivers shares his personal database-driven web application architecture where PostgreSQL handles both data and presentation logic. The system uses SQL functions to generate complete HTML responses with HTTP headers, eliminating the traditional separation between database and templating layers. The codebase includes
Table of contents
tables.sqltable-refs.sqlscripts/reset.shomni/*.sql*/test/*.sqlscripts/templates/HTML in PostgreSQL?HTTP headers in PostgreSQL?web functionsio-rb/app schemasquestions? comments?Sort: