Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tkfW2-005pBI-Hx for pgsql-announce@arkaria.postgresql.org; Wed, 19 Feb 2025 08:33:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tkfW1-005TVs-32 for pgsql-announce@arkaria.postgresql.org; Wed, 19 Feb 2025 08:33:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tkfVz-005TUz-Hh for pgsql-announce@lists.postgresql.org; Wed, 19 Feb 2025 08:33:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tkfVx-001fvT-0J for pgsql-announce@lists.postgresql.org; Wed, 19 Feb 2025 08:33:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=fX951SlQuba/SkTxeX4VMCalBPSp/vzIvqL/TdehFi8=; b=PlTdSKTY1D3szaGvQYAlolzLor GCcvpuHrxXnAag4eAuM7IVxkzZC5MGNLe87ZXI/twW2VXOyp0SoJYUxUoCxP3o88OqMVYG+fkxnOc AKV+lClAqzUKz8NAsiZFt1zbbDowl1Nc9oH7ikcxLFnMzdwFh2pEOQ0Dv03JyC5BTl5eZNW5VvrgV f0OZXVFx4f+61pnyzB+YV8A1gCZiFctFkoEXMNR7OXtSEHyTbBafSd81p8SOM+bxMQ1UKvwclmdtI Q+GEdIGXhnlVwQnJrnAE+MeG1xn2k4g9jhdA57KSGZAJDgf0P+U2LHtqnTurNwgB9YSMrCt39fL/q ZMJZMkjQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tkfVw-0068p6-DA for pgsql-announce@lists.postgresql.org; Wed, 19 Feb 2025 08:33:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tkfVu-000rYV-Jt for pgsql-announce@lists.postgresql.org; Wed, 19 Feb 2025 08:33:02 +0000 Content-Type: multipart/mixed; boundary="===============4623160455456234561==" MIME-Version: 1.0 Subject: =?utf-8?q?SQLPage_v0=2E33=3A_Build_Custom_UIs=2C_and_now_APIs_=E2=80=94_All_in_SQL!?= To: PostgreSQL Announce From: SQLPage via PostgreSQL Announce Reply-To: contact@ophir.dev Date: Wed, 19 Feb 2025 08:32:20 +0000 Message-ID: <173995394070.666.8122470926860646333@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 5e7c7df54184f63e231177fd8fff6cf164217392d3aab55bf72231402beaa4a3 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4623160455456234561== Content-Type: multipart/alternative; boundary="===============7790363449314809563==" MIME-Version: 1.0 --===============7790363449314809563== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable > SQLPage is an open-source tool that turns SQL queries into interactive we= b apps. > It's used to build advanced internal tools, dashboards, and public websit= es, 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 particul= ar, building complex page layouts and custom REST APIs got easier. Here is = a short overview of what's new. ## =F0=9F=9A=80 Cleaner Routing **No more `.sql` clutter!** Now, access `page.sql` simply as `/page`.=20 - Old: `https://example.com/page.sql`=20 - New: `https://example.com/page` We are keeping full backward compatibility, so old `.sql` URLs still work. Cool URIs don't change. ## =F0=9F=94=97 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?functio= n=3Dfetch), that calls external APIs, and transmits the results to your dat= abase, letting you process it using [postgres-native json functions](https:= //sql-page.com/blog.sql?post=3DJSON%20in%20SQL%3A%20A%20Comprehensive%20Gui= de). We significantly improved it in this release. - **HTTP Basic Auth in `sqlpage.fetch`** =E2=86=92 Authenticate API request= s directly from SQL. =20 - **Better error messages** when HTTP requests fail. =20 - **Default headers**: No need to define `headers` on every query; SQLPage = now sends default ones automatically. =20 ## =F0=9F=8E=9B=EF=B8=8F UI Upgrades =20 - **Auto-submit forms** =E2=86=92 There is now an option to apply filters i= nstantly, no manual form submission needed. =20 - **Dynamic dropdowns** =E2=86=92 Load dropdown options from another SQL fi= le. Build an item search UI with auto-complete in two SQL queries. =20 - **Markdown in form descriptions** =E2=86=92 Add rich, formatted help text= inside forms. =20 ## =F0=9F=9B=A0=EF=B8=8F Advanced SQL Support - **PostgreSQL=E2=80=99s `INSERT=E2=80=A6SELECT=E2=80=A6RETURNING`** now wo= rks seamlessly. =20 - **`overlaps` operator support** =E2=86=92 Filter time-based data more eas= ily. =20 ## =F0=9F=8E=A8 **Polished Look & Feel** =20 - **Upgraded charts & icons** with [ApexCharts v4.4.0](https://github.com/a= pexcharts/apexcharts.js/releases/tag/v4.4.0) & [Tabler Icons 3.30](https://= tabler.io/changelog#/changelog/tabler-icons-3.30). =20 - **Better table formatting** =E2=86=92 Numbers auto-format based on user l= ocale. --- =F0=9F=92=A1 **Ready to try it out?** Check out the [release notes](https:/= /github.com/sqlpage/sqlpage/releases) and start building! =F0=9F=A4=94 Not ready to download it ? Try it online on [editor.datapage.= app](https://editor.datapage.app/) --===============7790363449314809563== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable SQLPage v0.33: Build Custom UIs, and now APIs =E2=80=94 All in S= QL!
 

SQLPage v0.33: Build Custom UIs, and now APIs =E2=80=94 All in SQL!

SQLPage is an open-source tool that turns S= QL 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 open= s new possibilities. In particular, building complex page layouts and custo= m REST APIs got easier. Here is a short overview of what's new.

=F0=9F=9A=80 Cleaner Routing

No more .sql clutter!<= /strong> Now, access page.sql simply as /page.

  • Old: http= s://example.com/page.sql
  • New: http= s://example.com/page

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

=F0=9F=94=97 Smarter API Calls<= /h2>

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

  • HTTP Ba= sic Auth in sqlpage.fetch =E2=86=92 Authenticate API = requests directly from SQL.
  • Better = error messages when HTTP requests fail.
  • Default= headers: No need to define headers on every query; S= QLPage now sends default ones automatically.

=F0=9F=8E=9B=EF=B8=8F UI Upgrad= es

  • Auto-su= bmit forms =E2=86=92 There is now an option to apply filters insta= ntly, no manual form submission needed.
  • Dynamic= dropdowns =E2=86=92 Load dropdown options from another SQL file. = Build an item search UI with auto-complete in two SQL queries.
  • Markdow= n in form descriptions =E2=86=92 Add rich, formatted help text ins= ide forms.

=F0=9F=9B=A0=EF=B8=8F Advanced = SQL Support

  • Postgre= SQL=E2=80=99s INSERT=E2=80=A6SELECT=E2=80=A6RETURNING= now works seamlessly.
  • o= verlaps operator support =E2=86=92 Filter time-based data m= ore easily.

=F0=9F=8E=A8 Polished L= ook & Feel

=F0=9F=92=A1 Ready to try it out? Check out the release notes a= nd start building!

=F0=9F=A4=94 Not ready to download it ? Try= it online on editor.datapage.app
This email was sent to you from SQLPage. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to SQLPage.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============7790363449314809563==-- --===============4623160455456234561==--