public inbox for [email protected]
help / color / mirror / Atom feedFrom: SQLPage via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: SQLPage v0.33: Build Custom UIs, and now APIs — All in SQL!
Date: Wed, 19 Feb 2025 08:32:20 +0000
Message-ID: <[email protected]> (raw)
> 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**](https://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`](https://sql-page.com/functions.sql?function=fetch), that calls external APIs, and transmits the results to your database, letting you process it using [postgres-native json functions](https://sql-page.com/blog.sql?post=JSON%20in%20SQL%3A%20A%20Comprehensive%20Guide).
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](https://github.com/apexcharts/apexcharts.js/releases/tag/v4.4.0) & [Tabler Icons 3.30](https://tabler.io/changelog#/changelog/tabler-icons-3.30).
- **Better table formatting** → Numbers auto-format based on user locale.
---
💡 **Ready to try it out?** Check out the [release notes](https://github.com/sqlpage/sqlpage/releases) and start building!
🤔 Not ready to download it ? Try it online on [editor.datapage.app](https://editor.datapage.app/)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: SQLPage v0.33: Build Custom UIs, and now APIs — All in SQL!
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox