SQLPage — Building a full web application with nothing but Postgres and SQL queries
summary
An open-source Rust single-binary server turns plain .sql files into server-rendered pages: one SQL file per page, components rendered by column names, and query results streamed straight to HTML. A tiny Twitter clone is built in about 20 lines of SQL; an API over a DB comes up in ~40 seconds. Connects to Postgres/MySQL/SQLite, uses Postgres extensions, and stays stateless so it runs on a Raspberry Pi or a cluster. Non-programmers shipped apps (one coordinator in ~1 month) and a call‑center operator turned this into a production tool.
AI-written summary · about
chapters (10)
- 0:00Introduction to SQL Page
- 2:30Addressing misconceptions
- 5:35The need for new tools
- 8:41SQL Page's market position
- 14:14Core principles
- 19:17How SQL Page works
- 23:14Component-based design
- 28:49Building a live application
- 36:41Real-world use cases
- 44:30Advanced features and Q&A
related talks
23mTips for Writing a Web Server and Beyond
47mSQl Database Server Request from the Browser
20mYou don't need an ORM
31mPostgres without SQL: Natural language queries using GPT-3 & Rust
30mBuilding modern Python web apps with PostgreSQL
45mBuilding Scalable APIs: PostgreSQL Meets GraphQL
32mBecause SQL is everywhere but you don't want to use it
44mPostgreSQL for Developers