SQLPage v0.32: build web apps in SQL, now with more style !

Posted on 2025-01-06 by SQLPage
Related Open Source

SQLPage v0.32 brings a lot of polish, and some advanced features for Christmas 🎄

SQLPage is an open-source tool that turns renders SQL query results as interactive web pages.

It's used to build advanced internal tools, dashboards, and public websites, entirely in SQL.

Check it out on sql-page.com.

Release highlights

This release focuses on polishing both the experience to application authors and final users.

New in components

  • The chart component has been reshaped and the underlying javascript library has been updated, with multiple bug fixes, and better automatic axis management.
  • The map component now has a nice background that follows the current theme.
  • The text component can now format long-form text in an printed article-like layout to make it easy to read.

Under the hood

  • Configurable recursion depth in sqlpage.run_sql
  • Better SQL transaction management, with guaranteed rollback on error. This plays nicely with postgres advanced transaction-related features.
  • Introduced the sqlpage/on_reset.sql hook to run custom sql after each page load.

Links