Skip to content

v0.8.0

Compare
Choose a tag to compare
@github-actions github-actions released this 17 Jul 00:46
· 1910 commits to main since this release
960d1ed

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