The list component

Example 1

A basic compact list

select 
    'list'                 as component,
    TRUE                   as compact,
    'SQLPage lists are...' as title;
select 
    'Beautiful' as title;
select 
    'Useful' as title;
select 
    'Versatile' as title;

Example 2

An empty list with a link to add an item

select 
    'list'              as component,
    'No items yet'      as empty_title,
    'This list is empty. Click here to create a new item !' as empty_description,
    'documentation.sql' as empty_link;

Example 3

A list with rich text descriptions

This example illustrates creating a nice list where each item has a title, a description, an image, and a link to another page.

Be careful, nested links are not supported. If you use the list's link property, then your markdown description_md should not contain any link.

select 
    'list' as component,
    TRUE   as wrap;
select 
    'SQL Websites' as title,
    '/favicon.ico' as image_url,
    'Write SQL, get a website. SQLPage is a **SQL**-based **site** generator for **PostgreSQL**, **MySQL**, **SQLite** and **SQL Server**.' as description_md,
    '/'            as link;
select 
    'SQL Forms'       as title,
    'https://upload.wikimedia.org/wikipedia/commons/b/b6/FileStack_retouched.jpg' as image_url,
    'Easily collect data **from users to your database** using the *form* component. Handle the data in SQL with `INSERT` or `UPDATE` queries.' as description_md,
    '?component=form' as link;
select 
    'SQL Maps'       as title,
    'https://upload.wikimedia.org/wikipedia/commons/1/15/Vatican_City_map_EN.png' as image_url,
    'Show database contents on a map using the *map* component. Works well with *PostGIS* and *SpatiaLite*.' as description_md,
    '?component=map' as link;
select 
    'Advanced features' as title,
    'settings'          as icon,
    '[Authenticate users](?component=authentication), [edit data](?component=form), [generate an API](?component=json), [maintain your database schema](/your-first-sql-website/migrations.sql), and more.' as description_md;

Example 4

A beautiful list with bells and whistles.

select 
    'list'                 as component,
    'Top SQLPage features' as title,
    TRUE                   as compact;
select 
    'Authentication'            as title,
    '?component=authentication' as link,
    'Authenticate users with a login form or HTTP basic authentication' as description,
    'red'                       as color,
    'lock'                      as icon,
    TRUE                        as active,
    '?component=authentication#view' as view_link;
select 
    'Editing data'           as title,
    '?component=form'        as link,
    'SQLPage makes it easy to UPDATE, INSERT and DELETE data in your database tables' as description,
    'blue'                   as color,
    'database'               as icon,
    '?component=form#edit'   as edit_link,
    '?component=form#delete' as delete_link;
select 
    'API'                    as title,
    '?component=json'        as link,
    'Generate a REST API from a single SQL query to connect with other applications and services' as description,
    'green'                  as color,
    'plug-connected'         as icon,
    '?component=json#edit'   as edit_link,
    '?component=json#delete' as delete_link;