SQLPage is an open-source tool that turns SQL queries into interactive web apps. It's used to build advanced internal tools, dashboards, and public websites, entirely in SQL.

Check it out on sql-page.com

Today, we released version 0.33, which opens new possibilities. In particular, building complex page layouts and custom REST APIs got easier. Here is a short overview of what's new.

🚀 Cleaner Routing

No more .sql clutter! Now, access page.sql simply as /page.

• Old: https://example.com/page.sql
• New: https://example.com/page

We are keeping full backward compatibility, so old .sql URLs still work. Cool URIs don't change.

🔗 Smarter API Calls

SQLPage exposes a set of functions, that are executed on the backend before sending your queries to Postgres. One of them is sqlpage.fetch, that calls external APIs, and transmits the results to your database, letting you process it using postgres-native json functions. We significantly improved it in this release.

• HTTP Basic Auth in sqlpage.fetch → Authenticate API requests directly from SQL.
• Better error messages when HTTP requests fail.
• Default headers: No need to define headers on every query; SQLPage now sends default ones automatically.

🎛️ UI Upgrades

• Auto-submit forms → There is now an option to apply filters instantly, no manual form submission needed.
• Dynamic dropdowns → Load dropdown options from another SQL file. Build an item search UI with auto-complete in two SQL queries.
• Markdown in form descriptions → Add rich, formatted help text inside forms.

🛠️ Advanced SQL Support

• PostgreSQL’s INSERT…SELECT…RETURNING now works seamlessly.
• overlaps operator support → Filter time-based data more easily.

🎨 Polished Look & Feel

• Upgraded charts & icons with ApexCharts v4.4.0 & Tabler Icons 3.30.
• Better table formatting → Numbers auto-format based on user locale.

💡 Ready to try it out? Check out the release notes and start building!

🤔 Not ready to download it ? Try it online on editor.datapage.app