Skip to content

v0.10.0
Compare
Choose a tag to compare
@github-actions github-actions released this 20 Aug 22:15
· 2113 commits to main since this release
v0.10.0
8cb743d
This commit was signed with the committer’s verified signature.
lovasoa Ophir LOJKINE
GPG key ID: AC8DB8E033B44AB8
Verified
Learn about vigilant mode.

SQLPage Release Notes - Version 0.10.0 🌟

SQLPage continues to evolve, bringing you exciting new features and enhancements to simplify your web application development process. Let's dive into the significant improvements introduced in version 0.10.0:

Database Dialect Recognition

📝 Improved SQL Parsing

SQLPage now intelligently parses .sql files based on the dialect of the database they are executed against, replacing the previous "Generic" dialect. This enhancement enables you to harness more database-specific features within SQLPage, eliminating any confusion.

Important Note: While this change should not affect most existing apps, it could potentially break your web application if you were relying on an SQL dialect syntax not directly supported by your database. Hence, the major version change. Please report any bug you might encounter.

Enhanced Chart Component

📊 Download Chart Data

With the newly introduced toolbar attribute of the chart component, you can now offer your users the ability to download chart data in various formats, including SVG, PNG, and CSV. This feature simplifies the process of providing large datasets and allowing users to effortlessly download them as CSV files from an intuitive UI.

SELECT 'chart' AS component, 1 AS toolbar; SELECT quarter AS label, sum(sales) AS value FROM sales GROUP BY quarter;

Embrace the Dark Side

🌒 Dark Theme

SQLPage now offers a sleek dark theme, allowing you to choose between a light and dark appearance for your web application. You can select the dark theme using the theme parameter of the shell component.

SELECT 'shell' AS component, 'dark' AS theme;

Explore Dark Theme

Usability and Reliability

🔧 Various Improvements

  • Fixed a bug where the default index page was displayed when index.sql couldn't be loaded, providing a clear error page instead.
  • Enhanced scrollbar appearance, improving user experience.
  • Create a single database connection by default when using sqlite://:memory:, simplifying the use of temporary tables and connection-specific features.
  • When no component is selected, data is now displayed with the debug component by default, making any simple SELECT statement a valid SQLPage file.
  • Improved error handling with stylish error pages, even for errors occurring at the top of the page.
  • Added the ability to retry database connections on startup, ensuring SQLPage waits for the database to become available.

Configuration Details

Upgrade to SQLPage 0.10.0 and take advantage of these enhancements to streamline your web application development. We're dedicated to providing you with a seamless and efficient web development experience.

Get Started with SQLPage | GitHub Repository

Elevate your SQL-driven web applications with SQLPage 0.10.0. Happy coding! 💻🚀

1 / 1

Assets 6
Loading