SQLPage documentation
The two most important concepts in SQLPage are components and parameters. This page documents all the components that you can use in SQLPage and their parameters. Use this as a reference when building your SQL application.
components
The "datagrid" component
Display small pieces of information in a clear and readable way. Each item has a name and is associated with a value.
Top-level parameters
title
Text header at the top of the data grid.
Row-level parameters
title
REQUIRED. Name of the piece of information.
active
Whether this item in the grid is considered "active". Active items are displayed more prominently.
color
If set to a color name, the value will be displayed in a pill of that color.
description
Value to display below the name.
footer
Muted text to display below the value.
icon
An icon name (from tabler-icons.io) to display on the left side of the value.
link
A target URL to which the user should be taken when they click on the value.
Example 1
Just some sections of information.
SELECT
'datagrid' as component;
SELECT
'Language' as title,
'SQL' as description;
SELECT
'Creation date' as title,
'1974' as description;
SELECT
'Language family' as title,
'Query language' as description;
Result
Example 2
A beautiful data grid with nice colors and icons.
SELECT
'datagrid' as component,
'User' as title;
SELECT
'Pseudo' as title,
'lovasoa' as description;
SELECT
'Status' as title,
'Active' as description,
'green' as color;
SELECT
'Email Status' as title,
'Validated' as description,
'check' as icon,
1 as active;
SELECT
'Personal page' as title,
'ophir.dev' as description,
'https://ophir.dev/' as link;
SELECT
'Search engine' as title,
'https://google.com' as link,
'Google' as description,
'red' as color,
'brand-google' as icon,
'Owned by Alphabet Inc.' as footer;
SELECT
'Encyclopedia' as title,
'https://wikipedia.org' as link,
'Wikipedia' as description,
'blue' as color,
'world' as icon,
'Owned by the Wikimedia Foundation' as footer;