Skip to content

v0.9.0
Compare
Choose a tag to compare
@github-actions github-actions released this 30 Jul 21:56
· 1752 commits to main since this release
v0.9.0
28184fa
This commit was signed with the committer’s verified signature.
lovasoa Ophir LOJKINE
GPG key ID: AC8DB8E033B44AB8
Learn about vigilant mode.

🚀 SQLPage v0.9.0 Release Notes

SQLPage is an open-source low-code web application framework, that allows you to create dynamic websites with nothing more than SQL queries. Make your first SQL website today !

We're thrilled to announce the latest version of SQLPage, packed with exciting new features to enhance your web application development experience entirely in SQL! 🎉 Let's dive into what this release has in store for you:

📦 Introducing the json Component

Create a JSON API directly in SQL with SQLPage! 🚀 Now, building an API over your database is as simple as executing a single SQL statement:

SELECT 'json' AS component, JSON_OBJECT('hello', 'world') AS contents

Seamlessly integrate your data with other applications using this powerful new component.

💨 Improved Performance for Static Elements

We've optimized SQLPage to interpret SELECT statements containing only static values directly, without querying the database. This enhancement significantly boosts the performance of pages that include multiple static elements. Enjoy faster load times and smoother user experiences! 🏎️

🔗 Canonical URL Redirection

Say goodbye to URL ambiguity! We now redirect index pages without a trailing slash to the same page with the trailing slash. This ensures relative links work flawlessly and provides each page with a unique canonical URL. So whether your file resides in myfolder/index.sql, it will be accessible at both mysite.com/myfolder/ and mysite.com/myfolder. Seamless navigation at your fingertips! 🌐

💼 Enhanced Database Drivers

We've updated the database drivers to the latest version and switched to a fork of sqlx. Explore improved compatibility and performance in your SQLPage applications. And let's not forget that our embedded SQLite has also received an update to version 3.41.2, delivering better JSON support and increased performance. 🔄

🔬 Experimental Microsoft SQL Server Support

We're thrilled to offer experimental support for Microsoft SQL Server. If you have a SQL Server database lying around, we'd love for you to test it and report any issues you might encounter. Your feedback is instrumental in refining this exciting feature! 🧪

We can't wait for you to try out SQLPage v0.9.0 and take your web application development to the next level with its powerful SQL-driven capabilities. As always, thank you for your continued support and valuable feedback! Happy coding! 💻

Assets 6
Loading