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 "card" component
A grid where each element is a small card that displays a piece of data.
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.
A short paragraph displayed below the title.
Text header at the top of the list of cards.
REQUIRED. Name of the card, displayed at the top.
Whether this item in the grid is considered "active". Active items are displayed more prominently.
The name of a color, to be displayed on the left of the card to highlight it.
The body of the card.
Muted text to display at the bottom of the card.
An icon name (from tabler-icons.io) to display on the left side of the card.
An URL to which the user should be taken when they click on the card.
The most basic card
SELECT 'card' as component; SELECT 'A' as title; SELECT 'B' as title; SELECT 'C' as title;
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;