A component that writes messages to the server logs. When a page runs, it prints your message to the terminal/console (standard error). Use it to track what happens and troubleshoot issues.
docker logs <container_name>.journalctl -u sqlpage.Introduced in SQLPage v0.37.1.
| name | required | type | description |
|---|---|---|---|
| message | REQUIRED | TEXT |
The text to write to the server logs. It is printed when the page runs. |
| level | TEXT |
How important the message is. One of 'trace', 'debug', 'info' (default), 'warn', 'error'. Not case-sensitive. Controls the level shown in the logs. |
| No data |
This writes "Hello, World!" to the server logs.
SELECT 'log' as component, 'Hello, World!' as message;
Example output:
[2025-09-13T22:30:14.722Z INFO sqlpage::log from "x.sql" statement 1] Hello, World!
Choose how important the message is.
SELECT 'log' as component, 'error' as level, 'This is an error message' as message;
Example output:
[2025-09-13T22:30:14.722Z ERROR sqlpage::log from "x.sql" statement 2] This is an error message
Include variables like a username.
set username = 'user'
select 'log' as component,
'403 - failed for ' || coalesce($username, 'None') as message,
'error' as level;