Releases · sqlpage/SQLPage (original) (raw)

v0.34.0

v0.34 (2025-03-23)

✨ Top Features at a Glance

HTML-enhanced Markdown in text components
Sticky table footers for better data presentation
Multiple bug fixes

🔒 Security First

POST-based Deletions

List component's delete_link now uses secure POST requests:

SELECT 'list' AS component; SELECT 'Delete me' AS title, 'delete_item.sql?id=77' AS delete_link;

Prevents accidental deletions by web crawlers and follows REST best practices

Protected Internal Files

Files/folders starting with . (e.g., .utils/) are now inaccessible
Perfect for internal scripts used with sqlpage.run_sql()

🎨 UI & Component Upgrades

Table Styling Revolution

/* Before: .price | After: */ ._col_price { background: #f8f9fa; border-right: 2px solid #dee2e6; }

New CSS class pattern: ._col_{column_name}
Fixes #830

Column component

SELECT 'columns' AS component; SELECT 'View details' AS title; -- No button shown

Columns without button text now hide empty buttons
Cleaner interfaces by default

Sticky Table Footers

SELECT 'table' AS component, true AS freeze_footers; SELECT 'Total' AS label, SUM(price) AS value, true AS _sqlpage_footer;

Keep summary rows visible during scroll
Use _sqlpage_footer on your final data row

🌍 Internationalization

Right-to-Left Support

SELECT 'shell' AS component, true AS rtl;

Enable RTL mode per page via shell component
Perfect for Arabic, Hebrew, and Persian content

📝 Content Handling

Rich Text Power

SELECT 'text' AS component, '

Important!

   New *HTML-enhanced* content.
   </div>' 
   AS unsafe_contents_md;

New unsafe_contents_md allows HTML+Markdown mixing

Base64 Image Support

Alt text

Embed images directly in Markdown fields

⚙️ Configuration Tweaks

{ "markdown_allow_dangerous_html": false, "markdown_allow_dangerous_protocol": false }

Markdown safety controls to change markdown rendering settings

🐛 Notable Fixes

SQL Server
Fixed TINYINT handling crashes
Anchor Links
Corrected display in tables with fixed headers
Form Inputs
Proper handling of 0 values in number fields

💡 Upgrade Guide

CSS Updates
Search/replace .your_column → ._col_your_column if you have custom css targetting tables.
Deletion Flows
Test list components using delete_link.
You can now add a check that the request method is POST if you want to forbid deletions by simply loading pages.

View full configuration options →

v0.33.1

SQLPage 0.33.1 Released ! 🚀

Note

SQLPage lets you build web applications using SQL queries. If you know SQL, you can create complete web applications without spending time on traditional web development languages and frameworks.
Download for Windows, MacOS, or Linux, or try online !

This release fixes multiple bugs, and improves performance.

Fix a bug where the table component would not format numbers if sorting was not enabled.
Fix a bug with date sorting in the table component.
Center table descriptions.
Fix a rare crash on startup in some restricted linux environments.
Fix a rare but serious issue when on SQLite and MySQL, some variable values were assigned incorrectly
- CASE WHEN <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>a</mi><mi>T</mi><mi>H</mi><mi>E</mi><mi>N</mi></mrow><annotation encoding="application/x-tex">a THEN </annotation></semantics></math>aTHENx WHEN <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>b</mi><mi>T</mi><mi>H</mi><mi>E</mi><mi>N</mi></mrow><annotation encoding="application/x-tex">b THEN </annotation></semantics></math>bTHENy would be executed as CASE WHEN <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>a</mi><mi>T</mi><mi>H</mi><mi>E</mi><mi>N</mi></mrow><annotation encoding="application/x-tex">a THEN </annotation></semantics></math>aTHENb WHEN <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>x</mi><mi>T</mi><mi>H</mi><mi>E</mi><mi>N</mi></mrow><annotation encoding="application/x-tex">x THEN </annotation></semantics></math>xTHENy on these databases.
- the issue only occured when using in case expressions where variables were used both in conditions and results.
Implement parameter deduplication.
Now, when you write select <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>x</mi><mi>w</mi><mi>h</mi><mi>e</mi><mi>r</mi><mi>e</mi></mrow><annotation encoding="application/x-tex">x where </annotation></semantics></math>xwherex is not null, the value of $x is sent to the database only once. It used to be sent as many times as $x appeared in the statement.
Improve error messages on invalid sqlpage function calls. The messages now contain actionable advice.
Fix top navigation bar links color. They appeared "muted", with low contrast, since v0.33
update to apex charts v4.5.0. This fixes a bug where tick positions in scatter plots would be incorrect.
New function: sqlpage.fetch_with_meta
- This function is similar to sqlpage.fetch, but it returns a json object with the following properties:
  * status: the http status code of the response.
  * headers: a json object with the response headers.
  * body: the response body.
  * error: an error message if the request failed.
- This is useful when interacting with complex or unreliable external APIs.

v0.33.0

SQLPage 0.33 Released ! 🚀

Note

Hey SQL Pagers !

Today, we are releasing SQLPage v0.33.0, which brings cleaner URLs, auto-submitting forms for instant filters, dynamic dropdowns for massive datasets, and fetch upgrades for effortless API calls. Tables now format numbers based on locale, charts are sharper, and new SQL syntax support unlocks powerful queries — all making your apps faster, more dynamic, and easier to build.

Routing & URL Enhancements 🔀

Clean URLs:

Access your pages without the extra “.sql” suffix. For instance, if your file is page.sql, you can now use either:

Old URL	New URL
https://example.com/page.sql	https://example.com/page (or page.sql still works)

Big thanks to @guspower for their contributions!

Complete Routing Rewrite:

We overhauled our request routing system for smoother, more predictable routing across every request.

SQLPage Functions ⚙️

sqlpage.fetch (Calling External Services)

HTTP Basic Authentication

SQLPage’s sqlpage.fetch(request) now supports HTTP Basic Auth. Easily call APIs requiring a username/password. For example:

SET result = sqlpage.fetch(json_object( 'url', 'https://api.example.com/data', 'username', 'user', 'password', 'pass' ));

Check out the fetch documentation for more.

Smarter Fetch Errors & Headers Defaults

Get clearer error messages if your HTTP request definition is off (unknown fields, etc.). Plus, the headers parameter is now optional. SQLPage now sends a User‑Agent header that includes the SQLPage version by default.

New Functions: sqlpage.request_body and sqlpage.request_body_base64

Return the raw request body as a string or base64 encoded string.
Useful to build REST JSON APIs in SQL easily.
Example:
INSERT INTO users (name, email)
VALUES (
json(sqlpage.request_body())->>'name',
json(sqlpage.request_body())->>'email'
);

New Function: sqlpage.headers

Easily manage and inspect HTTP headers with the brand‑new sqlpage.headers function.

UI Component Enhancements 🎨

Table & Card Components

Table CSS Fixes:

We fixed a bug where table cells weren’t getting the right CSS classes—your tables now align perfectly.

Native Number Formatting:

Numeric values in tables are now automatically formatted to your visitor’s locale with proper thousands separators and decimal points, and sorted numerically.
Example:

Many thanks @francesco-cattoglio for the contribution !

Enhanced Card Layouts:

Customizing your card components is now easier:

The embed property auto‑appends the _sqlpage_embed parameter for embeddable fragments.
When rendering an embedded page, the shell component is replaced by shell-empty to avoid duplicate headers and metadata.

Form Component Boosts

Auto‑Submit Forms

Set auto_submit to true and your form will instantly submit on any field change—ideal for dashboard filters.

Example

SELECT 'form' AS component, 'Filter Results' AS title, true AS auto_submit; SELECT 'date' AS name;

Dynamic Options for Dropdowns

Use options_source to load dropdown options dynamically from another SQL file. Perfect for autocomplete with large option sets.

Example

`index.sql`

select 'form' as componentt; select 'my_field' as name, 'select' as type, 'options_source.sql' as options_source;

`options_source.sql`

select 'json' as component; select id as value, label as label from my_options where label like $search || '%';

Result

Screencast.From.2025-02-15.13-52-43.mp4

Markdown in Field Descriptions

With the new description_md property, render markdown in form field descriptions for improved guidance.
Thanks to @theochr72 for the contribution !

Improved Header Error Messages

Now you’ll get more helpful errors if header components (e.g., json, cookie) are used incorrectly.

Chart, Icons & CSS Updates 📊

ApexCharts Upgrade

We updated ApexCharts to v4.4.0 for smoother charts and minor bug fixes.

Tabler Icons & CSS

Enjoy a refreshed look:

Tabler Icons are now v3.30.0 with many new icons.
The CSS framework has been upgraded to Tabler 1.0.0 for improved consistency and a sleeker interface.

CSV Import & Error Handling 📥

Enhanced CSV Error Messages:
More descriptive error messages when a CSV import fails (via copy and file upload).
Postgres CSV Bug Fix:
A bug that caused subsequent requests to fail after a CSV import error on PostgreSQL is now fixed.
(See Issue #788 for details.)

SQL Parser & Advanced SQL Support 🔍

Upgraded SQL Parser (v0.54):
Our sqlparser is now at v0.54, with support for advanced SQL syntax:

INSERT...SELECT...RETURNING:
INSERT INTO users (name, email)
SELECT :name, :email
WHERE :name IS NOT NULL
RETURNING 'redirect' AS component, 'user.sql?id=' || id AS link;
PostgreSQL’s overlaps operator:
SELECT 'card' AS component,
event_name AS title,
start_time::text || ' - ' || end_time::text AS description

FROM events
WHERE
(start_time, end_time)
OVERLAPS
($start_filter::timestamp, $end_filter::timestamp);

MySQL’s INSERT...SET syntax:
INSERT INTO users
SET name = :name, email = :email;

Happy coding and keep pushing the boundaries of what you can build with SQL!

v0.32.1

Note

This is a bugfix release.

Fix a bug where the form component would not display the right checked state in radio buttons and check boxes (#751)
Fix a bug in the link component where the properties view_link, edit_link, and delete_link had become incompatible with the main link property.
Updated sqlparser to v0.53 which fixes parse errors when using some advanced SQL syntax
- adds support for SQLite's UPDATE OR REPLACE syntax
- adds support for MSSQL's JSON_ARRAY and JSON_OBJECT functions
- adds support for PostgreSQL's JSON_OBJECT(key : value) and JSON_OBJECT(key VALUE value) syntax
- fixes the parsing of true and false in Microsoft SQL Server (mssql): they are now correctly parsed as column names, not as boolean values, since mssql does not support boolean literals. This means you may have to replace TRUE as some_property with 1 as some_property in your SQL code when working with mssql.
When your SQL contains errors, the error message now displays the precise line(s) number(s) of your file that contain the error.

v0.32.0

SQLPage v0.32: Reliability, Polish, and a New Web Editor 🚀

Note

Dear SQLPage community,

As we close out 2024, we're excited to share significant improvements that make SQLPage more robust and easier to use.

We're also introducing editor.datapage.app - a free, browser-based editor where you can create and deploy SQLPage websites instantly, no installation required!

Wishing you all a Merry Christmas and a Happy New Year! 🎄✨

🔒 Database Reliability

Transaction Management
- Automatic rollback of open transactions on errors, preventing corrupted states
- Fixed MySQL START TRANSACTION compatibility

Example protection against temporary table issues on postgres:

BEGIN; CREATE TEMPORARY TABLE t (x int) ON COMMIT DROP; -- Operations now safely roll back on error COMMIT;

Query Execution Safety
- Prevented statement execution after errors. When an error occurs in a SQL file, you now have the guarantee that no further statements will be executed after the one that caused the error.
- Added max_recursion_depth control for the run_sql function. See configuration for more information.
- sqlpage.environment_variable now returns null for unset variables

🎨 UI Improvements

Data Visualization
- Updated ApexCharts to v4.3.0, with multiple small improvements and bug fixes.
- Fixed stacked bar chart rendering
- Fixed axis tick amount calculation issues in the chart component.
- Enhanced map component with theme-aware backgrounds. When using the map component without a basemap, uses a background color that respects the theme color.
Other Components
- Enhanced list component with fully clickable items. The entire list item is now clickable, when a link property is provided.
- Fixed multi-select dropdown behavior on form reset: the dropdown would unexpectedly open when the form was reset.
- Added checkbox/radio button value property: the value property can now be used in checkbox and radio button components. The custom checked property still works, but it is now optional.
- Fixed table sorting for columns with spaces in their name.

🛠 Developer Features

New Capabilities
- sqlpage/on_reset.sql hook, executed after each page execution. See configuration for more information.
- coalesce support in SQLPage functions: you can now use coalesce inside arguments of sqlpage functions, and it will be evaluated inside sqlpage. For instance, this lets you call sqlpage.link(coalesce($url, 'https://sql-page.com')) to create a link that will use the value of $url if it is not null, or fallback to https://sql-page.com if it is null.
- New article property for content formatting: the article property in the text component can be used to display text in a more readable, article-like format.
  *
- Proper JSON handling in SQLite: the JSON function now returns a json object instead of a string in sqlite.
Quality of Life
- Improved footer positioning: the page footer (by default: Built with SQLPage) is now displayed at the bottom of the page instead of immediately after the main content.
- More helpful server startup messages: the welcome message displayed on the terminal when starting the server is now friendlier and more helpful.
  *
- Fixed sqlpage.header uppercase handling: the sqlpage.header function now correctly handles headers containing uppercase letters.

These updates focus on database reliability, component improvements, and developer productivity - making SQLPage a more robust tool for building web applications with SQL.

v0.31.0

SQLPage is a tool that allows users to create dynamic, SQL-powered websites with minimal coding effort.

This release, v0.31.0, introduces enhanced table functionalities, deeper database integration, smarter search features, and improved debugging with detailed error logs. It also upgrades security and optimizes chart performance, making it easier to build secure data-driven websites.

🚀 New Features

Improved Components

Columns Component
- Markdown-supported descriptions (description_md) allow richer formatting.
- Add simple text items without needing JSON handling.
- Optionally skip displaying items (null as item).
Table Component
- New freeze headers and columns feature improves usability with large tables.
- Enhanced search logic ensures more precise matches (e.g., "xy" no longer matches separate x and y cells in adjacent columns).
- Search box visibility is retained during horizontal scrolling.
  Technical: Adds freeze_headers, freeze_columns, and improves the internal search algorithm.
Form Component
- Added an empty option (empty_option) to dropdowns, enabling placeholder-like behavior.
  *
- Improved handling of large form submissions with configurable size limits (max_uploaded_file_size, default 5MB).
  Technical: There used to be a hardcoded limit to 16kB for all forms.

Database Enhancements

Support for New Data Types:
- Microsoft SQL Server now supports BIT columns.
- Improved handling of DATETIMEOFFSET in MSSQL and TIMESTAMPTZ in PostgreSQL, preserving their timezones instead of converting them to UTC.
Better JSON Handling:
- Accept nested JSON objects and arrays as function parameters.
  Useful for advanced usage like calling external APIs using sqlpage.fetch with complex data structures.
SQL Parser Update:
- Upgraded to v0.52.0 with new features:
  * Added support for:
  * advanced JSON_TABLE usage in MySQL for working with JSON arrays.
  * EXECUTE statements with parameters in MSSQL for running stored procedures.
  * MSSQL’s TRY_CONVERT function for type conversion.
  * ANY, ALL, and SOME subqueries (e.g., SELECT * FROM t WHERE a = ANY (SELECT b FROM t2)).
  * LIMIT max_rows, offset syntax in SQLite.
  * Assigning column names aliases using = in MSSQL (e.g., SELECT col_name = value).
- Fixes a bug where the parser would fail parse a SET clause for a variable named role.

Security and Performance

Encrypted Login Support for MSSQL:
- Ensures secure connections with flexible encryption modes:
  * No encryption (?encrypt=not_supported): For legacy systems and environments where SSL is blocked
  * Partial encryption (?encrypt=off): Protects login credentials but not data packets.
  * Full encryption (?encrypt=on): Secures both login and data.
  Technical: Controlled using the encrypt parameter (not_supported, off, or strict) in mssql connection strings.
Chart Library Optimization:
- Updated ApexCharts to v4.0.0.
- Fixed duplicate library loads, speeding up pages with multiple charts.
- Fixed a bug where timeline chart tooltips displayed the wrong labels.

🛠 Bug Fixes

Database and Compatibility Fixes

Microsoft SQL Server:
- Fixed decoding issues for less common data types.
- Resolved bugs in reading VARCHAR columns from non-European collations.
- Correctly handles REAL values.
SQLite:
- Eliminated spurious warnings when using SQLPage functions with JSON arguments.
  Technical: Avoids warnings like The column _sqlpage_f0_a1 is missing.

Component Fixes

Card Component:
- Fixed layout issues with embedded content (e.g., removed double borders).
  *
- Corrected misaligned loading spinners.
Form Dropdowns:
- Resolved state retention after form resets, ensuring dropdowns reset correctly.

Usability Enhancements

Removed unnecessary padding around tables for cleaner layouts.
Increased spacing between items in the columns component for improved readability.
Database errors are now consistently logged and displayed with more actionable details.
- Technical: Ensures warnings in the browser and console for faster debugging.

v0.30.1

v0.30.1: Bugfix release

fix a bug where table sorting would break if table search was not also enabled.

Many thanks to @DSMejantel for quickly reporting the issue.

v0.30.0

With SQLPage 0.30, build APIs in 2 lines of SQL

🤖 Easy APIs

Enhanced CSV Support: The CSV component can now create URLs that trigger a CSV download directly on page load.
- This finally makes it possible to allow the download of large datasets as CSV
- This makes it possible to create an API that returns data as CSV and can be easily exposed to other software for interoperabily.
Easy json APIs
- The json component now accepts a second sql query, and will return the results as a json array in a very resource-efficient manner. This makes it easier and faster than ever to build REST APIs entirely in SQL.
  * select 'json' as component;
  select * from users;
  * [ { "id": 0, "name": "Jon Snow" }, { "id": 1, "name": "Tyrion Lannister" } ]
- Ease of use : the component can now be used to automatically format any query result as a json array, without manually using your database''s json functions.
- server-sent events : the component can now be used to stream query results to the client in real-time using server-sent events.

🔒 Database Connectivity

Encrypted Microsoft SQL Server Connections: SQLPage now supports encrypted connections to SQL Server databases, enabling connections to secure databases (e.g., those hosted on Azure).
Separate Database Password Setting: Added database_password configuration option to store passwords securely outside the connection string. This is useful for security purposes, to avoid accidentally leaking the password in logs. This also allows setting the database password as an environment variable directly, without having to URL-encode it inside the connection string.

😎 Developer experience improvements

Improved JSON Handling: SQLPage now automatically converts JSON strings to JSON objects in databases like SQLite and MariaDB, making it easier to use JSON-based components.
- -- Now works out of the box in SQLite
  select 'big_number' as component;
  select 'Daily performance' as title, perf as value;
  json_object(
  'label', 'Monthly',
  'link', 'monthly.sql'
  ) as dropdown_item
  from performance;

📈 Table & Search Improvements

Initial Search Value: Pre-fill the search bar with a default value in tables with initial_search_value, making it easier to set starting filters.
Faster Sorting and Searching: Table filtering and sorting has been entirely rewritten.
- filtering is much faster for large datasets
- sorting columns that contain images and links now works as expected
- Since the new code is smaller, initial page loads should be slightly faster, even on pages that do not use tables

🖼️ UI & UX Improvements

Carousel Updates:
- Autoplay works as expected when embedded in a card.
- Set image width and height to prevent layout shifts due to varying image sizes.
Improved Site SEO: The site title in the shell component is no longer in <h1> tags, which should aid search engines in understanding content better, and avoid confusion between the site name and the page's title.

🛠️ Fixes and improvements

Shell Component Search: Fixed search feature when no menu item is defined.
Updated Icons: The Tabler icon set has been refreshed from 3.10 to 3.21, making many new icons available: https://tabler.io/changelog

v0.29.0

SQLPage v0.29 : better SQL websites 🎨

✨ New Components: columns for comparisons, foldable for expandable lists.
⚙️ Improvements: CLI arguments parsing, dynamic database URL, config validation.
🐛 Fixes: UI tweaks, table markdown rendering, shell font, and mobile menu display.

Detailed release notes

New columns component: columns. Useful to display a comparison between items, or large key figures to an user.
New foldable component: foldable. Useful to display a list of items that can be expanded individually.
CLI arguments parsing: SQLPage now processes command-line arguments to set the web root and configuration directory. It also allows getting the currently installed version of SQLPage with sqlpage --version without starting the server.
- ```
$ sqlpage --help
Build data user interfaces entirely in SQL. A web server that takes .sql files and formats the query result using pre-made configurable professional-looking components.
Usage: sqlpage [OPTIONS]
Options:
-w, --web-root The directory where the .sql files are located
-d, --config-dir The directory where the sqlpage.json configuration, the templates, and the migrations are located
-c, --config-file The path to the configuration file
-h, --help Print help
-V, --version Print version
```
Configuration checks: SQLPage now checks if the configuration file is valid when starting the server. This allows to display a helpful error message when the configuration is invalid, instead of crashing or behaving unexpectedly. Notable, we now ensure critical configuration values like directories, timeouts, and connection pool settings are valid.
- ```
./sqlpage --web-root /xyz
[ERROR sqlpage] The provided configuration is invalid
Caused by:
Web root is not a valid directory: "/xyz"
```
The configuration directory is now created if it does not exist. This allows to start the server without having to manually create the directory.
The default database URL is now computed from the configuration directory, instead of being hardcoded to sqlite://./sqlpage/sqlpage.db. So when using a custom configuration directory, the default SQLite database will be created inside it. When using the default ./sqlpage configuration directory, or when using a custom database URL, the default behavior is unchanged.
New navbar_title property in the shell component to set the title of the top navigation bar. This allows to display a different title in the top menu than the one that appears in the tab of the browser. This can also be set to the empty string to hide the title in the top menu, in case you want to display only a logo for instance.
Fixed: The font property in the shell component was mistakingly not applied since v0.28.0. It works again.
Updated SQL parser to v0.51.0. Improved INTERVAL parsing.
Important note: this version removes support for the SET <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>v</mi><mi>a</mi><mi>r</mi><mi>i</mi><mi>a</mi><mi>b</mi><mi>l</mi><mi>e</mi><mo>=</mo><mi mathvariant="normal">.</mi><mi mathvariant="normal">.</mi><mi mathvariant="normal">.</mi><mi mathvariant="normal">‘</mi><mi>s</mi><mi>y</mi><mi>n</mi><mi>t</mi><mi>a</mi><mi>x</mi><mi>i</mi><mi>n</mi><mi>S</mi><mi>Q</mi><mi>L</mi><mi>i</mi><mi>t</mi><mi>e</mi><mi mathvariant="normal">.</mi><mi>T</mi><mi>h</mi><mi>i</mi><mi>s</mi><mi>w</mi><mi>o</mi><mi>r</mi><mi>k</mi><mi>e</mi><mi>d</mi><mi>o</mi><mi>n</mi><mi>l</mi><mi>y</mi><mi>w</mi><mi>i</mi><mi>t</mi><mi>h</mi><mi>s</mi><mi>o</mi><mi>m</mi><mi>e</mi><mi>d</mi><mi>a</mi><mi>t</mi><mi>a</mi><mi>b</mi><mi>a</mi><mi>s</mi><mi>e</mi><mi>s</mi><mi mathvariant="normal">.</mi><mi>Y</mi><mi>o</mi><mi>u</mi><mi>s</mi><mi>h</mi><mi>o</mi><mi>u</mi><mi>l</mi><mi>d</mi><mi>r</mi><mi>e</mi><mi>p</mi><mi>l</mi><mi>a</mi><mi>c</mi><mi>e</mi><mi>a</mi><mi>l</mi><mi>l</mi><mi>o</mi><mi>c</mi><mi>c</mi><mi>u</mi><mi>r</mi><mi>r</mi><mi>e</mi><mi>n</mi><mi>c</mi><mi>e</mi><mi>s</mi><mi>o</mi><mi>f</mi><mi>t</mi><mi>h</mi><mi>i</mi><mi>s</mi><mi>s</mi><mi>y</mi><mi>n</mi><mi>t</mi><mi>a</mi><mi>x</mi><mi>w</mi><mi>i</mi><mi>t</mi><mi>h</mi><mi mathvariant="normal">‘</mi><mi>S</mi><mi>E</mi><mi>T</mi><mi>v</mi><mi>a</mi><mi>r</mi><mi>i</mi><mi>a</mi><mi>b</mi><mi>l</mi><mi>e</mi><mo>=</mo><mi mathvariant="normal">.</mi><mi mathvariant="normal">.</mi><mi mathvariant="normal">.</mi><mi mathvariant="normal">‘</mi><mo stretchy="false">(</mo><mi>w</mi><mi>i</mi><mi>t</mi><mi>h</mi><mi>o</mi><mi>u</mi><mi>t</mi><mi>t</mi><mi>h</mi><mi>e</mi><mi mathvariant="normal">‘</mi></mrow><annotation encoding="application/x-tex">variable = ... syntax in SQLite. This worked only with some databases. You should replace all occurrences of this syntax with SET variable = ... (without the </annotation></semantics></math>variable=...‘syntaxinSQLite.Thisworkedonlywithsomedatabases.Youshouldreplacealloccurrencesofthissyntaxwith‘SETvariable=...‘(withoutthe‘ prefix).
slightly reduce the margin at the top of pages to make the content appear higher on the screen.
fix the display of the page title when it is long and the sidebar display is enabled.
Fix an issue where the color name blue could not be used in the chart component.
divider component: Add new properties to the divider component: link, bold, italics, underline, size.
form component: fix slight misalignment and sizing issues of checkboxes and radio buttons.
table component: fixed a bug where markdown contents of table cells would not be rendered as markdown if the column name contained uppercase letters on Postgres. Column name matching is now case-insensitive, so 'title' as markdown will work the same as 'Title' as markdown. In postgres, non-double-quoted identifiers are always folded to lowercase.
shell component: fixed a bug where the mobile menu would display even when no menu items were provided.

spreadsheet component

There is a new spreadsheet component that displays your data as an editable excel-like spreadsheet that supports custom formatting.

For licensing reasons, it is not included in the default SQLPage distribution, but you can download it from https://github.com/lovasoa/sqlpage-spreadsheet.

v0.28.0

🎉 SQLPage v0.28 🎉

Chart component: fix the labels of pie charts displaying too many decimal places.
You can now create a 404.sql file anywhere in your SQLPage project to handle requests to non-existing pages. This allows you to create custom 404 pages, or create nice URLs that don't end with .sql.
- Create if /folder/404.sql exists, then it will be called for all URLs that start with folder and do not match an existing file.
Updated SQL parser to v0.50.0
- Support postgres String Constants with Unicode Escapes, like U&'\2713'. Fixes https://github.com/lovasoa/SQLpage/discussions/511
New big_number component to display key statistics and indicators in a large, easy-to-read format. Useful for displaying KPIs, metrics, and other important numbers in dashboards and reports.
Fixed small display inconsistencies in the shell component with the new sidebar feature (#556).
Cleanly close all open database connections when shutting down sqlpage. Previously, when shutting down SQLPage, database connections that were opened during the session were not explicitly closed. These connections would remain open until the database itself closes them. Now, SQLPage ensures that all opened database connections are cleanly closed during shutdown. This guarantees that resources are freed immediately, ensuring more reliable operation, particularly in environments with limited database connections.