SQLPage on Ubuntu 24.04

Overview

SQLPage is an open source web server that turns SQL queries into web pages. It reads .sql files from a directory, runs them against a database, and renders each result set using a library of pre made components. The whole model fits in one sentence: a query whose first column is called component selects a component, and the remaining columns are that component's properties. Return a table component and you get a sortable, searchable table; return a chart component and you get a chart. There is no HTML to write, no JavaScript framework to learn, no package manager and no build step, so the development loop is simply to edit a file and reload the page. That makes it a fast way to put an interface in front of data that already lives in a database, and it means the people who understand the data can build the interface themselves.

Common uses

• Internal admin panels and operational dashboards over an existing database
• Reporting pages built by the people who know the SQL, not the front end
• Rapid prototypes and data catalogues you can stand up the same day

See it running

Real screenshots taken while testing this image against its deployment guide.