Derek Sivers's database and web apps
6 months ago
- #database
- #PostgreSQL
- #web-development
- Derek Sivers maintains a private database with public code, mirrored on GitHub, GitLab, and Codeberg.
- The database setup includes circular references in tables.sql, with functions organized in schemas for easy reloading.
- Testing is done using pgTAP on a clone of the live database, with minimal data for focused testing.
- HTML templates are stored in the database, not on disk, for easy editing and use.
- PostgreSQL functions return two values: head text for HTTP headers and body text for the content.
- Different directories correspond to different web apps, each with its own set of functions and tests.
- Derek encourages discussions about programming and responds to every email.