v0.32.0

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

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

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.