v0.12.0-beta

v0.12 Beta release

• variables . SQLPage now support setting and reusing variables between statements. This allows you to write more complex SQL queries, and to reuse the result of a query in multiple places.

  -- Set a variable
  SET person = 'Alice';
  -- Use it in a query
  SELECT 'text' AS component, 'Hello ' || $person AS contents;

v0.11.1

⚠️ Security update

Fixes a potential exposure of database credentials if they are in the configuration file (not in an environment variable), and the web_root is the current working directory (the default). See #89

Full Changelog: v0.11.0...v0.11.1

v0.11.0

SQLPage Release Notes - Version 0.11.0 🚀

We're thrilled to introduce SQLPage version 0.11.0, packed with exciting new features and enhancements to supercharge your web application development journey. Let's dive into the remarkable improvements this release brings:

Unlock the Power of Environment Variables!

🔐 Support for Environment Variables

In this release, we're introducing a game-changer: the ability to read environment variables directly from your SQL code using sqlpage.environment_variable('VAR_NAME'). This opens up a world of possibilities for dynamic and secure configuration within your SQLPage applications.

Enhanced Database Connectivity

🌐 Better Connection Options for MSSQL

We've expanded our support for database connectivity by providing enhanced connection options for MSSQL. Now, connecting to your Microsoft SQL Server databases is more straightforward and versatile than ever. Notable, you can set your application's name in the connection string, and configure the window size for optimal performance.

Unleash Creativity with New Icons

🎨 Fresh Icons for Every Component

Elevate your UI game with a wide array of new icons available for use across all components. Explore the possibilities and enhance the visual appeal of your web application. Check out the new icons.

Empowering CSS Upgrades

🌟 New CSS Library Version

We've leveled up our CSS library, giving you more power when crafting custom components. Stay on the cutting edge of web design with the latest CSS enhancements. Explore the updates.

Tailored Web Root Configuration

📂 Configure Your Web Root

With the new release, you can now configure SQLPage to start in one directory while serving SQL files from another. This flexibility enables you to structure your project in a way that suits your workflow seamlessly. Learn more in the configuration documentation.

Friendly Welcome Message

👋 A Warm Welcome to SQLPage

Experience a friendlier introduction to SQLPage with our new welcome message:

SQLPage is now running on http://127.0.0.1:8080/
You can write your code in .sql files in /path/to/your/website/directory.`

Empowering Functions for Developers

🧰 New Developer Tools

We've introduced two new functions to empower developers:

• sqlpage.current_working_directory(): Easily retrieve the current working directory of the SQLPage process.
• sqlpage.version(): Quickly obtain the version of SQLPage you're using.

Upgrade to SQLPage 0.11.0 today, and embark on a journey of limitless possibilities in web application development. We're dedicated to providing you with the tools and features you need for a seamless and efficient coding experience.

Get Started with SQLPage | GitHub Repository

Unleash your creativity and build extraordinary SQL-driven web applications with SQLPage 0.11.0.

Happy coding! 💻🚀

Full Changelog: v0.10.3...v0.11.0

v0.10.4-beta1

mssql connections

v0.10.3

mssql connection string improvements

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.