v0.19.0

SQLPage v0.19.0 Released!

We're excited to announce the release of SQLPage v0.19.0!
If you are new here: SQLPage is a small web server that renders your SQL queries as beautiful interactive websites.
This update is focused on improving built-in components and making deployment easier.

Improved User Interface

• Styled tables: Customize the appearance of your tables with new attributes like striped_rows, striped_columns, hover, border, and small. (Refer to documentation: https://sql.ophir.dev/documentation.sql?component=table#component)
  • 
• Input groups: Create visually clear and informative input fields using the new prefix, prefix_icon, and suffix attributes in the form component. This is valuable for adding units, currency symbols, or other visual cues beside your form inputs.
  • 
• Multiple page layouts: Choose your preferred layout with the new configuration options in the shell component. Three options are available: boxed (default), fluid (full width), and horizontal (boxed content with full-width header).
  • 
• Row-level actions: Enhance your tables with the new edit_link, delete_link, and view_link attributes in the list component. These attributes allow you to add icons and links to each row for easy interaction.
  • 
• Enhanced charting: The chart component now leverages the latest versions of the ApexCharts library, providing updated features and bug fixes. (See release notes for details: https://github.com/apexcharts/apexcharts.js/releases)
• New icons: Enjoy a wider selection of icons with the update to Tabler Icon library v2.47. (See changelog: https://tabler.io/icons/changelog)
  • 

Developer Experience Enhancements:

• Dynamic components at top level: Previously restricted, dynamic components can now be used freely at the top level of your SQL files for improved flexibility.
• Custom shells: Take customization to a new level by creating multiple shell-*.handlebars files in the sqlpage directory. This allows defining different shell layouts for various pages within your application. (See documentation: https://sql.ophir.dev/custom_components.sql)
• Environment variable for configuration: Manage configuration more efficiently with the new SQLPAGE_CONFIGURATION_DIRECTORY environment variable. This enables you to define a custom location for your configuration files, independent of the current working directory.

Additional improvements:

• Cookie component behavior now aligns with the documentation, setting cookies for the entire website by default.

We encourage you to explore the new features in v0.19.0 and experience the enhanced capabilities of SQLPage! The full release notes with detailed descriptions and examples are available on GitHub: https://github.com/lovasoa/SQLpage/releases/tag/v0.19.0