v0.8.0

SQLPage v0.8.0 ✨📝

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 !

This changelog provides an overview of the latest updates and improvements made to the SQLPage project. Check out the exciting new features, bug fixes, and more!

🔥 Introducing Powerful SQLite Extensions! 🔌🚀

• We've added a brand new sqlite_extensions configuration parameter that allows you to load SQLite extensions. Unleash the true potential of SQLPage with various use cases, including:
  • 🌍 Building a Geographic Data Application using Spatialite.
  • 📊 Querying CSV Data from SQLPage using vsv.
  • 🔍 Creating a Data Search Engine with FTS5.

💥 Breaking Change: Improved Configuration Priority 💥

• We've changed the order of priority for loading configuration parameters. Now, environment variables take precedence over the configuration file. This simplifies tweaking the configuration of your SQLPage website during deployment.

🐞 Bug Fixes and Enhancements 🛠️🚀

• Fixed the default index page issue in MySQL. Say goodbye to the pesky problem with #23.
• Get ready to explore the world with the new map component! Display maps with markers, perfect for showcasing geographic data from PostGIS or Spatialite.
• Add some flair to your tables! The table component now supports the icon attribute, allowing you to display icons within your tables.
• No more missing text! We've fixed the textarea fields in the form component to properly display the provided value attribute. Thanks to Frank for the contribution!

✨ Enhanced Database Connection Management ✨

• SQLPage now guarantees that a single web request will be handled by a single database connection. This improvement allows you to utilize temporary tables, transactions, and other connection-specific features (e.g., last_insert_rowid) seamlessly. Say hello to better state management between SQL statements in a single .sql file. Please share any performance concerns or feedback you may have. Check out the many-to-many relationship example for inspiration!

💡 Customization and Styling Enhancements 💡

• The table component now supports custom background colors and CSS classes on specific table lines.
• Introducing the new checked attribute for checkboxes and radio buttons. It's time to make your selections with confidence!

Stay tuned for more exciting updates coming your way. Enjoy exploring the power of SQLPage! 😄🚀

Full Changelog: v0.7.2...v0.8.0

v0.8.0-beta

This is a pre-release for beta-testers

• Added a new sqlite_extensions configuration parameter to load SQLite extensions. This allows many interesting use cases, such as
  • using spatialite to build a geographic data application,
  • querying CSV data from SQLPage with vsv,
  • or building a search engine for your data with FTS5.
• Breaking: change the order of priority for loading configuration parameters: the environment variables have priority over the configuration file. This makes it easier to tweak the configuration of a SQLPage website when deploying it.
• Fix the default index page in MySQL. Fixes #23.
• Add a new map component to display a map with markers on it. Useful to display geographic data from PostGIS or Spatialite.
• Add a new icon attribute to the table component to display icons in the table.

v0.7.2

SQLPage v0.7.2 ✨📝

SQLPage is an open-source low-code web application framework, that allows you to create full websites with only simple database queries. Make your first SQL website today !

This changelog provides an overview of the latest updates and improvements made to the SQLPage project. Check out the exciting new features, bug fixes, and more!

v0.7.2: User Authentication 👤🔒

• Introducing the brand new authentication component! Now you can easily handle user authentication and password checking.
• Say hello to the new redirect component, which allows you to redirect users to another page effortlessly.
• The debug component is now documented, providing you with better insights and debugging capabilities.

✨ Enhanced Shell Component Properties ✨

• Added exciting properties to the shell component:
  • the css property lets you add custom CSS to the page for personalized styling.
  • the javascript property enables you to incorporate custom JavaScript. Check out an example on how to integrate a React component.
  • the footer property allows you to set a custom message in the footer of the page.

🆕 New Functions 🆕

• Introducing sqlpage.basic_auth_username function! Now you can easily retrieve the name of the user logged in with HTTP basic authentication.
• Say goodbye to complexity with sqlpage.basic_auth_password function, which enables you to obtain the password of the user logged in with HTTP basic authentication.
• Protect your passwords with confidence using sqlpage.hash_password function. It allows you to securely hash passwords using the same secure algorithm as the authentication component.
• Gain greater control with sqlpage.header function, which lets you read an HTTP header from the request.
• Need a random string? We've got you covered! Use the sqlpage.random_string function to generate random strings, perfect for generating session IDs.

🐞 Bug Fixes and Enhancements 🛠️🚀

• Fixed a bug where the page style would not load on pages that were not in the root directory. Find out more here.
• Corrected the issue of resources being served with the wrong content type.
• Improved compilation of SQLPage as an AWS Lambda function.
• Logging and display of errors have been fixed and enhanced, providing more useful information.

Stay tuned for more exciting updates and improvements coming soon! 😃🚀

v0.7.1

• Better serverless support.
• Add ability to set a footer in pages.
• Improved chart component.
• New horizontal bar charts.

v0.7.0

This version adds support for cookies. You can read user cookies using the new sqlpage.cookie function. For instance:

SELECT 'text' as component, 'You are ' || sqlpage.cookie('username') as contents;

And you can store a new cookie on the user's device with

SELECT 'cookie' as component, 'username' as name, 'John Doe' as value;

v0.6.12

Add support for makdown in tables

v0.6.11

add support for <select> inputs with multiple choices

v0.6.10

Improved chart component

v0.6.9

more markdown, graphical fixes

v0.6.8

fix rendering of pages without a shell