github-featured / sqlpage--sqlpage

发布

0 发布 108 Git 标签

RSS 订阅源
  • v0.42.0 cc55a3d647
    比较

    - **New Function**: `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, especially whe…

    frostbyte_neo 发布于 2026-01-17 15:19:19 +00:00 | 307 次提交 在此版本后已推送到 main

    …n the --web-root argument or WEB_ROOT environment variable is used.

    • New Function: sqlpage.configuration_directory() - Returns the configuration directory where SQLPage looks for sqlpage.json, templates, and migrations. Useful when you need to reference configuration-related files in your SQL code.
    • fix: The default welcome page (index.sql) now correctly displays the web root and configuration directory paths instead of showing the current working directory.
    • fix: sqlpage.variables() now does not return json objects with duplicate keys when post, get and set variables of the same name are present. The semantics of the returned values remains the same (precedence: set > post > get).
    • add support for some duckdb-specific (like select {'a': 1, 'b': 2}), and oracle-specific syntax dynamically when connected through odbc.
    • better oidc support. Single-sign-on now works with sites:
      • using a non-default site_prefix
      • hosted behind an ssl-terminating reverse proxy
    • New docker image variant: lovasoa/sqlpage:latest-duckdb, lovasoa/sqlpage:main-duckdb with preconfigured duckdb odbc drivers.
    • New config option: cache_stale_duration_ms to control the duration for which cached sql files are considered fresh.
    下载附件