Pages

Pages are the way users interact with the application. Pages can also provide backend interaction and logic. Pages are stored in the pages folder and have the .htmql file extension.

Pages are written in HTMQL, which is a combination of HTML and SQL. The HTMQL syntax is designed to be familiar to developers who are familiar with basic HTML and SQL, but advanced frontend developers can take advantage of Javascript and other frontend libraries.

A page can contain the full stack of functionality; the backend database interaction and the frontend user interface. Frontend logic can be added via HTMX, Hyperscript, Javascript or other frontend technologies. Backend logic can be provided by application server special conventions (e.g. aliases and modifiers), database features (e.g. triggers, stored procedures), or external applications (via external execution calls).

When pages are accessed, the SQL commands are executed and complete before the HTML content is rendered.