Now SQLPage can connect to ANY relational database
frostbyte_neo
released this
2025-10-14 20:35:33 +00:00
- Added support for the Open Database Connectivity (ODBC) standard.
- This makes SQLPage compatible with many new databases, including:
- ClickHouse,
- MongoDB,
- DuckDB, and through it many other data sources,
- Oracle,
- Snowflake,
- BigQuery,
- IBM DB2,
- Trino, and through it many other data sources
- Added a new
sqlpage.hmac() function for cryptographic HMAC (Hash-based Message Authentication Code) operations.
- Create and verify secure signatures for webhooks (Shopify, Stripe, GitHub, etc.)
- Generate tamper-proof tokens for API authentication
- Secure download links and temporary access codes
- Supports SHA-256 (default) and SHA-512 algorithms
- Output formats: hexadecimal (default) or base64 (e.g.,
sha256-base64)
- See the function documentation for detailed examples
- Fixed a slight spacing issue in the list components empty value display.
- Improved performance of setting a variable to a literal value.
SET x = 'hello' is now executed locally by SQLPage and does not send anything to the database. This completely removes the cost of extracting static values into variables for cleaner SQL files.
- Enable arbitrary precision in the internal representation of numbers. This guarantees zero precision loss when the database returns very large or very small DECIMAL or NUMERIC values.
Downloads