Content-Type: multipart/mixed; boundary="===============1052207830710842593=="
MIME-Version: 1.0
Subject: SQLPage v0.32: build web apps in SQL, now with more style !
To: PostgreSQL Announce <pgsql-announce@lists.postgresql.org>
From: SQLPage via PostgreSQL Announce <announce-noreply@postgresql.org>
Reply-To: contact@ophir.dev
Date: Mon, 06 Jan 2025 21:01:44 +0000
Message-ID: <173619730426.713.7821644926134314220@wrigleys.postgresql.org>
Auto-Submitted: auto-generated
Archived-At: <https://www.postgresql.org/message-id/173619730426.713.7821644926134314220%40wrigleys.postgresql.org>
Precedence: bulk

--===============1052207830710842593==
Content-Type: multipart/alternative; boundary="===============7254921003347719303=="
MIME-Version: 1.0

--===============7254921003347719303==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

# SQLPage v0.32 brings a lot of polish, and some advanced features for Chri=
stmas =F0=9F=8E=84

**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**](https://sql-page.com).

## Release highlights

This release focuses on polishing both the experience to application author=
s and final users.

### New in components

- The [**chart component**](https://sql-page.com/component.sql?component=3D=
chart) has been reshaped and the underlying javascript library has been upd=
ated, with multiple bug fixes, and better automatic axis management.
- The [**map component**](https://sql-page.com/component.sql?component=3Dma=
p) now has a nice background that follows the current theme.
- The [**text component**](https://sql-page.com/component.sql?component=3Dt=
ext) can now format long-form text in an printed article-like layout to mak=
e it easy to read.=20

### Under the hood

 - Configurable recursion depth in [`sqlpage.run_sql`](https://sql-page.com=
/functions.sql?function=3Drun_sql)
 - Better SQL transaction management, with guaranteed rollback on error. Th=
is plays nicely with postgres advanced transaction-related features.
 - Introduced the `sqlpage/on_reset.sql` hook to run custom sql after each =
page load.

## Links
- [`sql-page.com` - SQLPage Home Page (built with sqlpage)](https://sql-pag=
e.com)
- [`github.com/sqlpage/sqlpage` - Release Notes and downloads](https://gith=
ub.com/sqlpage/SQLPage/releases/tag/v0.32.0)
--===============7254921003347719303==
Content-Type: text/html; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


<!doctype html>
<html>
  <head>
    <meta name=3D"viewport" content=3D"width=3Ddevice-width">
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF-8=
">
    <title>SQLPage v0.32: build web apps in SQL, now with more style !</tit=
le>
    <style>

    @media only screen and (max-width: 620px) {
      table[class=3Dbody] h1 {
        font-size: 28px !important;
        margin-bottom: 10px !important;
      }
      table[class=3Dbody] p,
            table[class=3Dbody] ul,
            table[class=3Dbody] ol,
            table[class=3Dbody] td,
            table[class=3Dbody] span,
            table[class=3Dbody] a {
        font-size: 16px !important;
      }
      table[class=3Dbody] .wrapper,
            table[class=3Dbody] .article {
        padding: 10px !important;
      }
      table[class=3Dbody] .content {
        padding: 0 !important;
      }
      table[class=3Dbody] .container {
        padding: 0 !important;
        width: 100% !important;
      }
      table[class=3Dbody] .main {
        border-left-width: 0 !important;
        border-radius: 0 !important;
        border-right-width: 0 !important;
      }
      table[class=3Dbody] .btn table {
        width: 100% !important;
      }
      table[class=3Dbody] .btn a {
        width: 100% !important;
      }
      table[class=3Dbody] .img-responsive {
        height: auto !important;
        max-width: 100% !important;
        width: auto !important;
      }
    }

    @media all {
      .ExternalClass {
        width: 100%;
      }
      .ExternalClass,
            .ExternalClass p,
            .ExternalClass span,
            .ExternalClass font,
            .ExternalClass td,
            .ExternalClass div {
        line-height: 100%;
      }
      .apple-link a {
        color: inherit !important;
        font-family: inherit !important;
        font-size: inherit !important;
        font-weight: inherit !important;
        line-height: inherit !important;
        text-decoration: none !important;
      }
      #MessageViewBody a {
        color: inherit;
        text-decoration: none;
        font-size: inherit;
        font-family: inherit;
        font-weight: inherit;
        line-height: inherit;
      }
      .btn-primary table td:hover {
        background-color: #34495e !important;
      }
      .btn-primary a:hover {
        background-color: #34495e !important;
        border-color: #34495e !important;
      }
    }
    </style>
  </head>
  <body class=3D"" style=3D"background-color: #f6f6f6; font-family: sans-se=
rif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4=
; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adju=
st: 100%;">
    <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" class=3D"body" =
style=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace=
: 0pt; width: 100%; background-color: #f6f6f6;">
      <tr>
        <td style=3D"font-family: sans-serif; font-size: 14px; vertical-ali=
gn: top;">&nbsp;</td>
        <td class=3D"container" style=3D"font-family: sans-serif; font-size=
: 14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580=
px; padding: 10px; width: 580px;">
          <div class=3D"content" style=3D"box-sizing: border-box; display: =
block; Margin: 0 auto; max-width: 580px; padding: 10px;">


            <span class=3D"preheader" style=3D"color: transparent; display:=
 none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden=
; mso-hide: all; visibility: hidden; width: 0;"></span>
            <table class=3D"main" style=3D"border-collapse: separate; mso-t=
able-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: #ffffff; =
border-radius: 3px;">


              <tr>
                <td class=3D"wrapper" style=3D"font-family: sans-serif; fon=
t-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;">
                  <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" s=
tyle=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace:=
 0pt; width: 100%;">
                    <tr>
                      <td style=3D"font-family: sans-serif; font-size: 14px=
; vertical-align: top;">

<div>
<h1 style=3D"color: #000; font-family: sans-serif; line-height: 1.4; margin=
: 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: ce=
nter">SQLPage v0.32: build web apps in SQL, now with more style !</h1>
</div>
<h1 style=3D"color: #000; font-family: sans-serif; line-height: 1.4; margin=
: 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: ce=
nter">SQLPage v0.32 brings a lot of polish, and some advanced features for =
Christmas =F0=9F=8E=84</h1>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px"><strong>SQLPage</strong> is an open-source =
tool that turns renders SQL query results as interactive web pages.</p>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">It's used to build advanced internal tools,=
 dashboards, and public websites, entirely in SQL.</p>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">Check it out on <a href=3D"https://sql-page=
.com" style=3D"color: #3498db; text-decoration: underline"><strong>sql-page=
.com</strong></a>.</p>
<h2 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h=
eight: 1.4; margin: 0; margin-bottom: 30px">Release highlights</h2>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">This release focuses on polishing both the =
experience to application authors and final users.</p>
<h3 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h=
eight: 1.4; margin: 0; margin-bottom: 30px">New in components</h3>
<ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;=
 margin: 0; margin-bottom: 15px">
<li style=3D"list-style-position: inside; margin-left: 5px">The <a href=3D"=
https://sql-page.com/component.sql?component=3Dchart" style=3D"color: #3498=
db; text-decoration: underline"><strong>chart component</strong></a> has be=
en reshaped and the underlying javascript library has been updated, with mu=
ltiple bug fixes, and better automatic axis management.</li>
<li style=3D"list-style-position: inside; margin-left: 5px">The <a href=3D"=
https://sql-page.com/component.sql?component=3Dmap" style=3D"color: #3498db=
; text-decoration: underline"><strong>map component</strong></a> now has a =
nice background that follows the current theme.</li>
<li style=3D"list-style-position: inside; margin-left: 5px">The <a href=3D"=
https://sql-page.com/component.sql?component=3Dtext" style=3D"color: #3498d=
b; text-decoration: underline"><strong>text component</strong></a> can now =
format long-form text in an printed article-like layout to make it easy to =
read. </li>
</ul>
<h3 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h=
eight: 1.4; margin: 0; margin-bottom: 30px">Under the hood</h3>
<ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;=
 margin: 0; margin-bottom: 15px">
<li style=3D"list-style-position: inside; margin-left: 5px">Configurable re=
cursion depth in <a href=3D"https://sql-page.com/functions.sql?function=3Dr=
un_sql" style=3D"color: #3498db; text-decoration: underline"><code>sqlpage.=
run_sql</code></a></li>
<li style=3D"list-style-position: inside; margin-left: 5px">Better SQL tran=
saction management, with guaranteed rollback on error. This plays nicely wi=
th postgres advanced transaction-related features.</li>
<li style=3D"list-style-position: inside; margin-left: 5px">Introduced the =
<code>sqlpage/on_reset.sql</code> hook to run custom sql after each page lo=
ad.</li>
</ul>
<h2 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h=
eight: 1.4; margin: 0; margin-bottom: 30px">Links</h2>
<ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;=
 margin: 0; margin-bottom: 15px">
<li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http=
s://sql-page.com" style=3D"color: #3498db; text-decoration: underline"><cod=
e>sql-page.com</code> - SQLPage Home Page (built with sqlpage)</a></li>
<li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http=
s://github.com/sqlpage/SQLPage/releases/tag/v0.32.0" style=3D"color: #3498d=
b; text-decoration: underline"><code>github.com/sqlpage/sqlpage</code> - Re=
lease Notes and downloads</a></li>
</ul>

                      </td>
                    </tr>
                  </table>
                </td>
              </tr>

            </table>

            <div class=3D"footer" style=3D"clear: both; Margin-top: 10px; t=
ext-align: center; width: 100%;">
              <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" style=
=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt=
; width: 100%;">
                <tr>
                  <td class=3D"content-block" style=3D"font-family: sans-se=
rif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-siz=
e: 12px; color: #999999; text-align: center;">
                    <span class=3D"apple-link" style=3D"color: #999999; fon=
t-size: 12px; text-align: center;">
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.
</span>
		    <br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> 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
<a href=3D"https://lists.postgresql.org/unsubscribe/" style=3D"color: #3498=
db; text-decoration: underline">https://lists.postgresql.org/unsubscribe/</=
a>.

                  </td>
                </tr>
              </table>
            </div>

          </div>
        </td>
        <td style=3D"font-family: sans-serif; font-size: 14px; vertical-ali=
gn: top;">&nbsp;</td>
      </tr>
    </table>
  </body>
</html>

--===============7254921003347719303==--

--===============1052207830710842593==--