Skip to content

v0.35.0

Latest
Compare
Choose a tag to compare
@github-actions github-actions released this 21 May 23:05
· 4 commits to main since this release

🎉 SQLPage v0.35 Release Announcement 🎉

Get started with SQLPage


SQLPage is the easiest way to turn your SQL queries into beautiful, interactive websites—no backend coding required. Whether you're a data enthusiast, a business analyst, or a developer, SQLPage lets you build data-driven web apps with just SQL, making web development accessible to everyone.


🚀 Major Highlight: Single Sign-On (SSO) with OIDC

The headline feature of v0.35 is Single Sign-On (SSO) support using OpenID Connect (OIDC)!
Now, you can protect your entire SQLPage website and let users log in with their existing accounts—Google, Microsoft, GitHub, or your organization's identity provider. This means you can secure your site with industry-standard authentication, making it easier and safer for users to access your app.
Learn how to set up SSO in minutes: SQLPage SSO Guide


✨ New Features

  • Rich Text Editor: Let your users write formatted text with links and images—see the new rich text editor example.
    • image
  • Form Improvements: Add stylish "switch" checkboxes and headers to your forms for a more modern, user-friendly experience.
    • image
  • Big Number Component Enhancements: Now you can add links to titles and values, and choose if they open in a new tab.
    • image
  • Tabler CSS Update: Upgraded to Tabler v1.3 for better chart tooltips, improved list display, and a fresh set of icons from Tabler Icons v1.33.
  • Active Menu Highlighting: Easily highlight the current page in your top bar menu.
    • image
  • Flexible Content-Security-Policy: Harden your site's security with more customizable CSP rules.
    • image

🐞 Bug Fixes & Improvements

  • Tooltips now work correctly on line charts, even with hidden series.
  • List component no longer truncates text when descriptions are empty.
  • Improved memory usage for better performance.
  • Updated SQL parser to v0.56 for more compatibility (including new Postgres and MSSQL features).
    • support nested comments in SQL Server
    • support CTEs in DELETE: WITH t (x) AS (SELECT ...) DELETE FROM my_table WHERE id IN (SELECT x FROM t)
    • support the XMLTABLE table-valued function for parsing xml

Ready to try it?

Download the latest version and start building your own SQL-powered website today: Your First SQL Website

And if you encounter any issue with this new release, please report it ! That will help make SQLPage better for everyone.