v0.9.0: support for SQL Server, creating json APIs in sqlpage, and performance optimizations
frostbyte_neo
发布于
2023-07-30 21:40:00 +00:00
| 2506 次提交 在此版本后已推送到 main
- Added a new
json component, which allows building a JSON API entirely in SQL with SQLPage !
Now creating an api over your database is as simple as SELECT json AS component, JSON_OBJECT(hello, world) AS contents.
SELECT statements that contain only static values are now interpreted directly by SQLPage, and do not result in a database query. This greatly improves the performance of pages that contain many static elements.- Redirect index pages without a trailing slash to the same page with the trailing slash. This ensures that relative links work correctly, and gives each page a unique canonical URL. (For instance, if you have a file in
myfolder/index.sql, then it will be accessible at mysite.com/myfolder/ and mysite.com/myfolder will redirect to mysite.com/myfolder/).
- Update the database drivers to the latest version, and switch to a fork of
sqlx that opens the door to supporting Microsoft SQL Server in the future. This also updates the embedded version of SQLite to 3.41.2, with many cool new features such as:
- better json support
- better performance
- Add experimental support for Microsoft SQL Server. If you have a SQL Server database lying around, please test it and report any issue you might encounter !
下载附件