v0.10.2

This small updates fixes a display bug with the map component.

v0.10.1

• Update the SQL parser, with multiple fixes. See https://github.com/sqlparser-rs/sqlparser-rs/blob/main/CHANGELOG.md#0370-2023-08-22

• Display all parameters in the debug component (instead of only row-level parameters).

• Update dashmap for better file lookup performance.

• Fix table sorting.

• Fix a bug with Basic Authentication.
  See #72. Thanks to @edgrip for the contribution !

Contributions

• Bump rustls-webpki from 0.101.3 to 0.101.4 by @dependabot in #68
• Fix broken search in shell template by @maaxleq in #71
• Fix ErrorWithStatus bubbling by @edgrip in #72

New Contributors

• @dependabot made their first contribution in #68
• @maaxleq made their first contribution in #71
• @edgrip made their first contribution in #72

Full Changelog: v0.10.0...v0.10.1

v0.10.0

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

v0.9.5

SQLPage is a web application server that empowers you to effortlessly construct small dynamic web applications solely using SQL queries, freeing you from the complexities of traditional web programming. By combining the power of SQL queries with pre-built web components, you can create powerful and visually appealing web interfaces without the need for HTML, CSS, or JavaScript.

---

SQLPage Release Notes - Version 0.9.5 🚀

New Features

📑 New tab Component for Tabbed Interfaces

Now you can enhance your web applications with tabbed interfaces using the brand new tab component. With just a few lines of SQL, you can create organized and user-friendly tab-based navigation, allowing users to access different sections of your application with ease. Check out the documentation to learn more about using the tab component.

Example:

select 'tab' as component;
select  'Buyers'  as title, $tab='Buyers'  as active;
select  'Sellers' as title, $tab='Sellers' as active;

select  'table' as component;
select * from buyers  where $tab='Buyers';
select * from sellers where $tab='Sellers';

🛠️ Database Driver Improvements

Version 0.9.5 comes with significant enhancements in database drivers, ensuring better performance and improved numeric precision. Several bug fixes have been implemented, particularly around passing values of the NUMERIC, DECIMAL, and JSON data types to SQLPage. These improvements enhance the overall reliability and accuracy of your web applications.

See this discussion about the usage of the JSON data type in SQLPage.

New Data Types

• DECIMAL allows you to precisely manage financial and numeric values, ensuring accurate calculations.
• JSON, on the other hand, enables structured and flexible data storage.

Upgrade and Enhance

With SQLPage 0.9.5, you can further elevate your web application development experience. Embrace the new tab component to create engaging interfaces and leverage the enhanced database drivers for better performance and data manipulation. The inclusion of DECIMAL and JSON data types opens up new possibilities for sophisticated applications.

Upgrade to version 0.9.5 now and unlock the full potential of SQL-driven web application development!

Get Started with SQLPage | GitHub Repository

We're committed to improving your web development journey, one SQL query at a time. Happy coding! 💻🌐

Full Changelog

• components: v0.9.4...v0.9.5
• database drivers: https://github.com/lovasoa/sqlx/compare/v0.6.9..v0.6.11

v0.9.4

Small bugfix release

• Fix a bug with simple queries (ones with only static values) that contained multiple repeated columns
  (such as SELECT 'hello' AS menu_item, 'world' AS menu_item). Only the last column would be taken into account.
  This could manifest as a bug where
  • only the last menu item in the shell component would be displayed,
  • only the last markdown column in a table would be interpreted as markdown,
  • only the last icon column in a table would be displayed as an icon.

v0.9.3

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 !

---

SQLPage v0.9.3 Release Notes 🚀

Faster, Leaner, and More Efficient

Release Date: August 3rd, 2023

Hello SQLPage enthusiasts! We're back with a brand-new update that's geared towards making your web development experience even smoother and swifter. We've fine-tuned, polished, and sprinkled a bit of magic to bring you SQLPage v0.9.3 – a release that's all about speed, performance, and delightful efficiency.

🎨 Icons Loaded at Lightning Speed

We've waved our performance wand and made icons load directly from the SQLPage binary itself. Say goodbye to waiting, and hello to lightning-fast page loads! This tweak not only boosts your website's speed but also earns you extra points on Google's performance audits. Better yet, your site's search result ranking might just get the spotlight it deserves. And the icing on the cake? You can now host your SQLPage website on an intranet without internet access.

Note: Fixes #37.

📦 Compressed Frontend Assets

We've got a nifty trick up our sleeve: we've stored compressed frontend assets right in the SQLPage binary. The result? A slimmer binary size and quicker page loads. This means less load on your server and happier users. It's a win-win!

🔍 Improved Table Search

We've heard you, and we've made table search even smarter. Say goodbye to those pesky bugs where special characters threw your search off balance. Now, finding rows is smoother and more reliable than ever before.

Note: Fixes #46.

📊 Charts on Demand

We believe in efficient loading, so we've taken our charts' JavaScript code and given it its own space. It's now loaded only when needed, reducing the initial JavaScript payload and boosting your site's performance. Whether you're on a snappy broadband connection or a slow mobile network, your SQLPage websites will shine with speed.

SQLPage v0.9.3 is your ticket to a faster, more efficient, and even more delightful web development journey. We've fine-tuned every aspect to ensure your experience is top-notch. Upgrade now, and let your creativity flow without any speed bumps.

Stay tuned for more exciting updates on the horizon. Happy coding! 💻🚀

Got questions, feedback, or ideas? Join the conversation in the SQLPage Community. Together, we're shaping the future of web development!

SQLPage v0.9.3 getting an almost perfect score on Google performance metrics. Using built-in fonts increases the score even further.

v0.9.2

• Added support for more SQL data types. This notably fixes an issue with the display of datetime columns in tables.
  • See: #41
• Updated dependencies, better SQL drivers

v0.9.1

v0.9.1

SQLPage v0.9.1 is a small release that fixes some issues with the Microsoft SQL Server driver.

v0.9.0

🚀 SQLPage v0.9.0 Release Notes

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 !

We're thrilled to announce the latest version of SQLPage, packed with exciting new features to enhance your web application development experience entirely in SQL! 🎉 Let's dive into what this release has in store for you:

📦 Introducing the json Component

Create a JSON API directly in SQL with SQLPage! 🚀 Now, building an API over your database is as simple as executing a single SQL statement:

SELECT 'json' AS component, JSON_OBJECT('hello', 'world') AS contents

Seamlessly integrate your data with other applications using this powerful new component.

💨 Improved Performance for Static Elements

We've optimized SQLPage to interpret SELECT statements containing only static values directly, without querying the database. This enhancement significantly boosts the performance of pages that include multiple static elements. Enjoy faster load times and smoother user experiences! 🏎️

🔗 Canonical URL Redirection

Say goodbye to URL ambiguity! We now redirect index pages without a trailing slash to the same page with the trailing slash. This ensures relative links work flawlessly and provides each page with a unique canonical URL. So whether your file resides in myfolder/index.sql, it will be accessible at both mysite.com/myfolder/ and mysite.com/myfolder. Seamless navigation at your fingertips! 🌐

💼 Enhanced Database Drivers

We've updated the database drivers to the latest version and switched to a fork of sqlx. Explore improved compatibility and performance in your SQLPage applications. And let's not forget that our embedded SQLite has also received an update to version 3.41.2, delivering better JSON support and increased performance. 🔄

🔬 Experimental Microsoft SQL Server Support

We're thrilled to offer experimental support for Microsoft SQL Server. If you have a SQL Server database lying around, we'd love for you to test it and report any issues you might encounter. Your feedback is instrumental in refining this exciting feature! 🧪

We can't wait for you to try out SQLPage v0.9.0 and take your web application development to the next level with its powerful SQL-driven capabilities. As always, thank you for your continued support and valuable feedback! Happy coding! 💻

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