v0.23.0

SQLPage v0.23: Improved Performance, Enhanced Components, and Bug Fixes

• 🔁 Connection Reuse: The sqlpage.run_sql function now reuses existing database connections for the current query. This enhancement allows for creating temporary tables, spanning SQL transactions over multiple run_sql calls, and generally makes run_sql more performant.

• 🗃️ Empty Uploaded Files Fix: Optional file upload fields that are left empty will no longer be accessible to SQLPage file-related functions like sqlpage.uploaded_file_path and sqlpage.uploaded_file_mime_type. These functions will now return NULL if no file is uploaded. Similarly, sqlpage.persist_uploaded_file will not create an empty file but will return NULL if no file is uploaded.

• 🖱️ Button Component Updates:

  • A new tooltip property has been added to the button component.
    • 
      Sure, here’s the revised point with a bit more detail for the target and rel properties:
  • The button component now supports:
    • download: makes the button download a file when clicked,
    • target: specifies where to open the linked document (e.g., in a new tab or window),
    • rel: defines the relationship between the current document and the linked document, and can also prevent search engines from following the link.
    • 

• 📋 CSV Component Fix: The separator parameter in the CSV component now functions correctly, enabling the creation of Excel-compatible CSVs in regions where ; is the expected separator.

  • 

• 🔍 Shell Component Update: A new search_value property has been added.

  • 

• 📏 Hero Component Text Fix: Long button text in the hero component now renders on multiple lines when the viewport is narrow.

  • 

• 🍪 Cookie Component Bug Fix: Fixed an issue where removing a cookie from a subdirectory was not working. See #361.

• 🛠️ SQL Parser Update: The SQL parser has been updated to fix support for AT TIME ZONE in PostgreSQL and GROUP_CONCAT() in MySQL.

• ⚠️ Form Field Warning: A new warning message is logged when attempting to use SET $x = if there is already a form field named x.

• 🗺️ Map Component Centering: The map component now centers on its markers if latitude and longitude properties are omitted. This makes it easier to create zoomed maps with a single marker. See issue.

  • 

• ⏲️ Fetch Timeout Option: The sqlpage.fetch function now includes a timeout option for requests, useful for handling slow or unreliable APIs and large payloads.

• 🎥 Hero Component Video Properties: The hero component now supports poster, loop, muted, and nocontrols properties for videos.

• 🌐 Icon Bug Fix: Fixed an issue where icons would disappear when serving a SQLPage website from a subdirectory using the site_prefix configuration option.