Skip to content

v0.42.0

Latest
Latest

Choose a tag to compare

View all tags
@github-actions github-actions released this 17 Jan 15:40
· 1 commit to main since this release
v0.42.0
cc55a3d

SQLPage v0.42.0 (2025-12-28)

Note

SQLPage transforms your SQL queries into web user interfaces. It lets you create web applications quickly, entirely in SQL.
Download for Windows, MacOS, or Linux, or try online!

New features

  • Better support for alternative databases
    • SQL file parsing
      • add support for some DuckDB-specific syntax (like select {'a': 1, 'b': 2}),
      • same for Oracle-specific syntax
  • New docker image variant: lovasoa/sqlpage:latest-duckdb, lovasoa/sqlpage:main-duckdb, lovasoa/sqlpage:v0.42.0-duckdb with preconfigured duckdb odbc drivers. Just run the image and you have a sqlpage connected to a duckdb running. This makes it much easier to use SQLPage on existing local or remote CSV, XLSX, JSON, or Parquet files without any data conversion step.
  • New config option: cache_stale_duration_ms to control the duration for which cached sql files are considered fresh.

New Functions

  • sqlpage.web_root() returns the web root directory where SQLPage serves .sql files from. This is more reliable than sqlpage.current_working_directory() when you need to reference the location of your SQL files, because it takes into account the --web-root command line argument and the WEB_ROOT environment variable.
  • sqlpage.configuration_directory() returns the configuration directory where SQLPage looks for sqlpage.json, templates, and migrations.

Bug fixes

  • Fixed oracle-specifc bugs. The entire sqlpage test suite now runs against an oracle database after each change, guaranteeing no regression.
  • The default welcome page (index.sql) now correctly displays the web root and configuration directory paths instead of showing the current working directory.
  • sqlpage.variables() returned json objects with duplicate keys when post, get and set variables of the same name were present. It now always returns valid json objects without duplicate keys. The semantics of the returned values remains the same (precedence: set > post > get).
  • better oidc support. Single-sign-on now works with sites:
    • using a non-default site_prefix
    • hosted behind an ssl-terminating reverse proxy
  • Fixed a bug where sqlpage would sometimes redirect to the wrong url after logout, causing logout failures when using sqlpage.oidc_logout_url()
Assets 6
Loading