Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/sqlpage/SQLPage/releases below:

Website Navigation

• Releases
• Tags

Releases · sqlpage/SQLPage · GitHub

small bugfix release

• Fix regression introduced in v0.36.0: PostgreSQL money values showed as 0.0
  • The recommended way to display money values in postgres is still to format them in the way you expect in SQL. See #983
• updated dependencies

Hello everyone! We've been working hard to bring a range of new features, fixes and improvements in this update. Here's what's new.

1. Database Enhancements:

   • We now support the MONEY and SMALLMONEY types in MSSQL. If you're dealing with financial data, this makes your life easier. For more details, check out the MSSQL money documentation
   • Added math functions to the built-in SQLite database, which means you can perform more calculations directly in your queries without extra work. You can learn more about these functions in the SQLite documentation

2. Migration Files:

   • You can now create empty migration files directly from the command line using the sqlpage create-migration command. This simplifies setting up new database changes. For more information, try sqlpage --help

3. New Component:

   • Introducing the new modal component, allowing you to display content in a popup window, improving the user interface and experience.

4. Chart Improvements:

   • Bar charts now sort categories by name rather than by their first appearance. This makes cumulative bar charts easier to interpret, especially when some data points are missing.
   • Pie charts now accept numerical values passed as strings, making it more flexible to create these charts.

5. Updates and Fixes:

   • Updated Tabler to version 1.4 and Tabler Icons to version 3.34, giving you access to 19 new icons for your projects. For details, check out the Tabler release notes and Tabler Icons changelog.
   • Enhanced file-based routing: Requests to /xxx will now redirect to /xxx/ only if /xxx/index.sql exists, resulting in a more intuitive navigation experience. This also makes it easier to create clean API endpoints using 404.sql.
   • SQL Parser Updates:
     • Added support for Postgres text search types (tsquery and tsvector).
     • Fixed parsing of LIMIT in subqueries and improved handling of JOIN precedence and Unicode identifiers.
     • Support for MySQL MEMBER OF, making it easier to work with JSON arrays.
     • For more details on these updates, see the SQL parser changelog for version 0.57 and version 0.58.

6. Single Sign-On (SSO) Improvements:

   • Fixed an issue where SSO logins would fail over time due to key rotation by identity providers. Now, the system refreshes provider metadata periodically, ensuring smoother and more reliable logins.
   • Added support for partially private sites when using single sign-on. This means you can have both public and private pages in the same application. It’s now easier to create a login page that redirects to your OIDC provider. See the single sign on documentation.
   • SQLPage can now read custom claims from the identity tokens emitted by your identity provider. This lets you configure your provider to include user-specific data (like roles or permissions) in the login token, enabling dynamic content tailored to the authenticated user. For configuration details, see the SQLPage user info function documentation.
   • Fixed an issue with URL parameters during SSO login. Now, if an anonymous user visits a page with URL parameters and logs in, they’ll be correctly redirected to that page with all parameters intact.

We hope these updates make your experience with SQLPage even better. As always, we appreciate your feedback and are here to help if you have any questions or run into issues.

Happy querying!

Get started with SQLPage

SQLPage is the easiest way to turn your SQL queries into beautiful, interactive websites—no traditional coding required. If you can query a database, you can build data-driven web apps.

This is a small bugfix release.

• Fix a bug with zero values being displayed with a non-zero height in stacked bar charts.
• Updated dependencies, including the embedded SQLite database (updated to sqlite v3.49.2)
• Linux release binaries are now dynamically linked again, but use GLIBC 2.28 (released in 2018), which is compatible with older linux distributions, including RHEL 8.
  • This fixes an issue introduced in 0.35 where custom SQLite extension loading would not work on linux.
• When an user requests a page that does not exist (and the site owner did not provide a custom 404.sql file), we now serve a nice visual 404 web page instead of the ugly textual message and the verbose log messages we used to have.
  • still returns plain text 404 for non-HTML requests. For instance, API requests to non-existing routes will return a textual response.
• Rich text editor: implement a readonly mode, activated when the field is not editable
• chart component: remove automatic sorting of categories. Values are now displayed in the order they are returned by the query. (bug)

Get started with SQLPage

SQLPage is the easiest way to turn your SQL queries into beautiful, interactive websites—no backend coding required. Whether you're a data enthusiast, a business analyst, or a developer, SQLPage lets you build data-driven web apps with just SQL, making web development accessible to everyone.

This is a minor bugfix release that addresses color-related regressions reported in v0.35.

Get started with SQLPage

SQLPage is the easiest way to turn your SQL queries into beautiful, interactive websites—no backend coding required. Whether you're a data enthusiast, a business analyst, or a developer, SQLPage lets you build data-driven web apps with just SQL, making web development accessible to everyone.

The headline feature of v0.35 is Single Sign-On (SSO) support using OpenID Connect (OIDC)!
Now, you can protect your entire SQLPage website and let users log in with their existing accounts—Google, Microsoft, GitHub, or your organization's identity provider. This means you can secure your site with industry-standard authentication, making it easier and safer for users to access your app.
Learn how to set up SSO in minutes: SQLPage SSO Guide

• Tooltips now work correctly on line charts, even with hidden series.
• List component no longer truncates text when descriptions are empty.
• Improved memory usage for better performance.
• Updated SQL parser to v0.56 for more compatibility (including new Postgres and MSSQL features).
  • support nested comments in SQL Server
  • support CTEs in DELETE: WITH t (x) AS (SELECT ...) DELETE FROM my_table WHERE id IN (SELECT x FROM t)
  • support the XMLTABLE table-valued function for parsing xml

Download the latest version and start building your own SQL-powered website today: Your First SQL Website

And if you encounter any issue with this new release, please report it ! That will help make SQLPage better for everyone.

• HTML-enhanced Markdown in text components
• Sticky table footers for better data presentation
• Multiple bug fixes

List component's delete_link now uses secure POST requests:

SELECT 'list' AS component;
SELECT 'Delete me' AS title, 'delete_item.sql?id=77' AS delete_link;

Prevents accidental deletions by web crawlers and follows REST best practices

• Files/folders starting with . (e.g., .utils/) are now inaccessible
• Perfect for internal scripts used with sqlpage.run_sql()

/* Before: .price | After: */
._col_price { 
    background: #f8f9fa;
    border-right: 2px solid #dee2e6;
}

• New CSS class pattern: ._col_{column_name}
• Fixes #830

SELECT 'columns' AS component;
SELECT 'View details' AS title; -- No button shown

• Columns without button text now hide empty buttons
• Cleaner interfaces by default

SELECT 
    'table' AS component,
    true AS freeze_footers;
SELECT 
    'Total' AS label,
    SUM(price) AS value,
    true AS _sqlpage_footer;

• Keep summary rows visible during scroll
• Use _sqlpage_footer on your final data row

SELECT 'shell' AS component, true AS rtl;

• Enable RTL mode per page via shell component
• Perfect for Arabic, Hebrew, and Persian content

SELECT 'text' AS component,
       '<div class="alert alert-warning">
       **Important!**
       
       New *HTML-enhanced* content.
       </div>' 
       AS unsafe_contents_md;

• New unsafe_contents_md allows HTML+Markdown mixing

![Alt text](data:image/png;base64,iVBORw0KGg...)

• Embed images directly in Markdown fields

{
  "markdown_allow_dangerous_html": false,
  "markdown_allow_dangerous_protocol": false
}

• Markdown safety controls to change markdown rendering settings

• SQL Server
  Fixed TINYINT handling crashes
• Anchor Links
  Corrected display in tables with fixed headers
• Form Inputs
  Proper handling of 0 values in number fields

1. CSS Updates
   Search/replace .your_column → ._col_your_column if you have custom css targetting tables.
2. Deletion Flows
   Test list components using delete_link.
   You can now add a check that the request method is POST if you want to forbid deletions by simply loading pages.

View full configuration options →

Note

SQLPage lets you build web applications using SQL queries. If you know SQL, you can create complete web applications without spending time on traditional web development languages and frameworks.
Download for Windows, MacOS, or Linux, or try online !

This release fixes multiple bugs, and improves performance.

• Fix a bug where the table component would not format numbers if sorting was not enabled.
• Fix a bug with date sorting in the table component.
• Center table descriptions.
• Fix a rare crash on startup in some restricted linux environments.
• Fix a rare but serious issue when on SQLite and MySQL, some variable values were assigned incorrectly
  • CASE WHEN $a THEN $x WHEN $b THEN $y would be executed as CASE WHEN $a THEN $b WHEN $x THEN $y on these databases.
  • the issue only occured when using in case expressions where variables were used both in conditions and results.
• Implement parameter deduplication.
  Now, when you write select $x where $x is not null, the value of $x is sent to the database only once. It used to be sent as many times as $x appeared in the statement.
• Improve error messages on invalid sqlpage function calls. The messages now contain actionable advice.
• Fix top navigation bar links color. They appeared "muted", with low contrast, since v0.33
• update to apex charts v4.5.0. This fixes a bug where tick positions in scatter plots would be incorrect.
• New function: sqlpage.fetch_with_meta
  • This function is similar to sqlpage.fetch, but it returns a json object with the following properties:
    • status: the http status code of the response.
    • headers: a json object with the response headers.
    • body: the response body.
    • error: an error message if the request failed.
  • This is useful when interacting with complex or unreliable external APIs.

Note

SQLPage lets you build web applications using SQL queries. If you know SQL, you can create complete web applications without spending time on traditional web development languages and frameworks.
Download for Windows, MacOS, or Linux, or try online !

Hey SQL Pagers !

Today, we are releasing SQLPage v0.33.0, which brings cleaner URLs, auto-submitting forms for instant filters, dynamic dropdowns for massive datasets, and fetch upgrades for effortless API calls. Tables now format numbers based on locale, charts are sharper, and new SQL syntax support unlocks powerful queries — all making your apps faster, more dynamic, and easier to build.

Access your pages without the extra “.sql” suffix. For instance, if your file is page.sql, you can now use either:

Big thanks to @guspower for their contributions!

We overhauled our request routing system for smoother, more predictable routing across every request.

SQLPage’s sqlpage.fetch(request) now supports HTTP Basic Auth. Easily call APIs requiring a username/password. For example:

SET result = sqlpage.fetch(json_object(
  'url', 'https://api.example.com/data',
  'username', 'user',
  'password', 'pass'
));

Check out the fetch documentation for more.

Get clearer error messages if your HTTP request definition is off (unknown fields, etc.). Plus, the headers parameter is now optional. SQLPage now sends a User‑Agent header that includes the SQLPage version by default.

• Return the raw request body as a string or base64 encoded string.
• Useful to build REST JSON APIs in SQL easily.
• Example:

  INSERT INTO users (name, email)
  VALUES (
    json(sqlpage.request_body())->>'name',
    json(sqlpage.request_body())->>'email'
  );

Easily manage and inspect HTTP headers with the brand‑new sqlpage.headers function.

We fixed a bug where table cells weren’t getting the right CSS classes—your tables now align perfectly.

Numeric values in tables are now automatically formatted to your visitor’s locale with proper thousands separators and decimal points, and sorted numerically.
Example:

Many thanks @francesco-cattoglio for the contribution !

Customizing your card components is now easier:

• The embed property auto‑appends the _sqlpage_embed parameter for embeddable fragments.
• When rendering an embedded page, the shell component is replaced by shell-empty to avoid duplicate headers and metadata.
  

Set auto_submit to true and your form will instantly submit on any field change—ideal for dashboard filters.

SELECT 'form' AS component, 'Filter Results' AS title, true AS auto_submit;
SELECT 'date' AS name;

Use options_source to load dropdown options dynamically from another SQL file. Perfect for autocomplete with large option sets.

select 'form' as componentt;
select 'my_field' as name, 'select' as type, 'options_source.sql' as options_source;

select 'json' as component;
select id as value, label as label from my_options where label like $search || '%';

With the new description_md property, render markdown in form field descriptions for improved guidance.
Thanks to @theochr72 for the contribution !

Now you’ll get more helpful errors if header components (e.g., json, cookie) are used incorrectly.

We updated ApexCharts to v4.4.0 for smoother charts and minor bug fixes.

Enjoy a refreshed look:

• Tabler Icons are now v3.30.0 with many new icons.
• The CSS framework has been upgraded to Tabler 1.0.0 for improved consistency and a sleeker interface.

• Enhanced CSV Error Messages:
  More descriptive error messages when a CSV import fails (via copy and file upload).

• Postgres CSV Bug Fix:
  A bug that caused subsequent requests to fail after a CSV import error on PostgreSQL is now fixed.
  (See Issue #788 for details.)

Upgraded SQL Parser (v0.54):
Our sqlparser is now at v0.54, with support for advanced SQL syntax:

• INSERT...SELECT...RETURNING:

  INSERT INTO users (name, email)
  SELECT :name, :email
  WHERE :name IS NOT NULL
  RETURNING 'redirect' AS component, 'user.sql?id=' || id AS link;

• PostgreSQL’s overlaps operator:

  SELECT 'card' AS component,
        event_name AS title,
        start_time::text || ' - ' || end_time::text AS description
  FROM events
  WHERE
     (start_time, end_time)
     OVERLAPS
     ($start_filter::timestamp, $end_filter::timestamp);

• MySQL’s INSERT...SET syntax:

  INSERT INTO users
  SET name = :name, email = :email;

Happy coding and keep pushing the boundaries of what you can build with SQL!

Note

SQLPage lets you build web applications using SQL queries. If you know SQL, you can create complete web applications without spending time on traditional web development languages and frameworks.
Download for Windows, MacOS, or Linux

This is a bugfix release.

• Fix a bug where the form component would not display the right checked state in radio buttons and check boxes (#751)
• Fix a bug in the link component where the properties view_link, edit_link, and delete_link had become incompatible with the main link property.
• Updated sqlparser to v0.53 which fixes parse errors when using some advanced SQL syntax
  • adds support for SQLite's UPDATE OR REPLACE syntax
  • adds support for MSSQL's JSON_ARRAY and JSON_OBJECT functions
  • adds support for PostgreSQL's JSON_OBJECT(key : value) and JSON_OBJECT(key VALUE value) syntax
  • fixes the parsing of true and false in Microsoft SQL Server (mssql): they are now correctly parsed as column names, not as boolean values, since mssql does not support boolean literals. This means you may have to replace TRUE as some_property with 1 as some_property in your SQL code when working with mssql.
• When your SQL contains errors, the error message now displays the precise line(s) number(s) of your file that contain the error.

Note

SQLPage lets you build web applications using SQL queries. If you know SQL, you can create complete web applications without spending time on traditional web development languages and frameworks.
Download for Windows, MacOS, or Linux

Dear SQLPage community,

As we close out 2024, we're excited to share significant improvements that make SQLPage more robust and easier to use.

We're also introducing editor.datapage.app - a free, browser-based editor where you can create and deploy SQLPage websites instantly, no installation required!

Wishing you all a Merry Christmas and a Happy New Year! 🎄✨

• Transaction Management
  • Automatic rollback of open transactions on errors, preventing corrupted states
  • Fixed MySQL START TRANSACTION compatibility

Example protection against temporary table issues on postgres:

BEGIN;
CREATE TEMPORARY TABLE t (x int) ON COMMIT DROP;
-- Operations now safely roll back on error
COMMIT;

• Query Execution Safety
  • Prevented statement execution after errors. When an error occurs in a SQL file, you now have the guarantee that no further statements will be executed after the one that caused the error.
  • Added max_recursion_depth control for the run_sql function. See configuration for more information.
  • sqlpage.environment_variable now returns null for unset variables

• Data Visualization

  • Updated ApexCharts to v4.3.0, with multiple small improvements and bug fixes.
  • Fixed stacked bar chart rendering
  • Fixed axis tick amount calculation issues in the chart component.
  • Enhanced map component with theme-aware backgrounds. When using the map component without a basemap, uses a background color that respects the theme color.

• Other Components

  • Enhanced list component with fully clickable items. The entire list item is now clickable, when a link property is provided.
  • Fixed multi-select dropdown behavior on form reset: the dropdown would unexpectedly open when the form was reset.
  • Added checkbox/radio button value property: the value property can now be used in checkbox and radio button components. The custom checked property still works, but it is now optional.
  • Fixed table sorting for columns with spaces in their name.

• New Capabilities

  • sqlpage/on_reset.sql hook, executed after each page execution. See configuration for more information.
  • coalesce support in SQLPage functions: you can now use coalesce inside arguments of sqlpage functions, and it will be evaluated inside sqlpage. For instance, this lets you call sqlpage.link(coalesce($url, 'https://sql-page.com')) to create a link that will use the value of $url if it is not null, or fallback to https://sql-page.com if it is null.
  • New article property for content formatting: the article property in the text component can be used to display text in a more readable, article-like format.
  • Proper JSON handling in SQLite: the JSON function now returns a json object instead of a string in sqlite.

• Quality of Life

  • Improved footer positioning: the page footer (by default: Built with SQLPage) is now displayed at the bottom of the page instead of immediately after the main content.
  • More helpful server startup messages: the welcome message displayed on the terminal when starting the server is now friendlier and more helpful.
  • Fixed sqlpage.header uppercase handling: the sqlpage.header function now correctly handles headers containing uppercase letters.

These updates focus on database reliability, component improvements, and developer productivity - making SQLPage a more robust tool for building web applications with SQL.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4