SQLPage v0.38 released !
Note
SQLPage transforms your SQL queries into web user interfaces. It lets you create web applications quickly, entirely in SQL.
Download for Windows, MacOS, or Linux, or try online!
Main change: SQLPage now works with almost all database management systems, thanks to ODBC. You can now build a SQLPage interface for your cloud databases like Snowflake and BigQuery, for flat files using DuckDB, for multiple heterogeneous data sources with Trino, and more.
Also: new sqlpage.hmac() function (useful when creating webhooks in SQLPage), some speed optimizations, and bug fixes.
Release Notes
🗄️ ODBC Support: Connect to Even More Databases
SQLPage now supports the Open Database Connectivity (ODBC) standard, expanding compatibility to a wide range of databases:
- ClickHouse
- MongoDB (via SQL interface)
- DuckDB, and through it many other data sources
- Oracle
- Snowflake
- BigQuery
- IBM DB2
- Trino, and through it many other data sources
You can now connect SQLPage to almost any major database or analytical system.
When using SQLPage with analytical databases, keep in mind that they usually have a higher per-query overhead. To maintain good performance and fast page loads, structure your SQL to run fewer, broader queries instead of several tiny ones.
🔑 New sqlpage.hmac() Function
A new built-in function for secure HMAC (Hash-based Message Authentication Code) operations.
Use it to:
- Create and verify secure webhook signatures (Shopify, Stripe, GitHub, etc.)
- Generate tamper-proof API tokens or temporary access codes
Features: supports SHA-256 and SHA-512, with hex (default) or base64 encoding.
⚡ Local Execution for Literal Assignments
Setting a variable to a literal (e.g., SET x = 'hello') is now executed locally by SQLPage instead of hitting the database.
This removes unnecessary database roundtrips and makes static variable extraction cost-free. This should incentivize you to write cleaner queries and decompose your code to use more variables.
🔢 Arbitrary Precision for Numeric Values
SQLPage now uses arbitrary-precision numbers internally for numeric values returned by the database.
This eliminates rounding or truncation issues with very large or very small DECIMAL / NUMERIC fields from your database.
🧩 UI Polish: List Component Spacing Fix
Fixed a minor spacing issue in list components when displaying empty values.
The layout now remains consistent regardless of missing or null fields.