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.
No more .sql clutter! Now, access page.sql simply as /page.
https://example.com/page.sql https://example.com/pageWe are keeping full backward compatibility, so old .sql URLs still work.
Cool URIs don't change.
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.
sqlpage.fetch → Authenticate API requests directly from SQL. headers on every query; SQLPage now sends default ones automatically. INSERT…SELECT…RETURNING now works seamlessly. overlaps operator support → Filter time-based data more easily. 💡 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