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.
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.
Text header at the top of the data grid.
REQUIRED. Name of the piece of information.
Whether this item in the grid is considered "active". Active items are displayed more prominently.
If set to a color name, the value will be displayed in a pill of that color.
Value to display below the name.
Muted text to display below the value.
An icon name (from tabler-icons.io) to display on the left side of the value.
A target URL to which the user should be taken when they click on the value.
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;
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;