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 "card" component
A grid where each element is a small card that displays a piece of data.
Top-level parameters
columns
The number of columns in the grid of cards. This is just a hint, the grid will adjust dynamically to the user's screen size, rendering fewer columns if needed to fit the contents.
description
A short paragraph displayed below the title.
title
Text header at the top of the list of cards.
Row-level parameters
title
REQUIRED. Name of the card, displayed at the top.
active
Whether this item in the grid is considered "active". Active items are displayed more prominently.
color
The name of a color, to be displayed on the left of the card to highlight it.
description
The body of the card.
footer
Muted text to display at the bottom of the card.
icon
An icon name (from tabler-icons.io) to display on the left side of the card.
link
An URL to which the user should be taken when they click on the card.
Example 1
The most basic card
SELECT
'card' as component;
SELECT
'A' as title;
SELECT
'B' as title;
SELECT
'C' as title;
Result
A
B
C
Example 2
A beautiful card grid with bells and whistles.
SELECT
'card' as component,
'Popular websites' as title,
2 as columns;
SELECT
'Google' as title,
'https://google.com' as link,
'A search engine' as description,
'red' as color,
'brand-google' as icon,
'Owned by Alphabet Inc.' as footer;
SELECT
'Wikipedia' as title,
'https://wikipedia.org' as link,
'An encyclopedia' as description,
'blue' as color,
'world' as icon,
1 as active,
'Owned by the Wikimedia Foundation' as footer;