SQLPage is a small web server that renders your SQL queries as beautiful interactive websites. This release has seen significant new features and fixes from new contributors, which is great and show the health of the project ! If you feel something is missing or isn't working quite right, all your contributions are always welcome.

On a side note, I gave a talk about SQLPage last December at PGConf.eu. It is a great detailed introduction to SQLPage, and I recommend it if you want to learn more about the project.

  1. New tracking component for beautiful and compact status reports: This feature adds a new way to display status reports, making them more visually appealing and concise.

    1. screenshot

  2. New divider component to add a horizontal line between other components: This simple yet useful addition allows for better separation of elements on your pages.

    1. image

  3. New breadcrumb component to display a breadcrumb navigation bar: This component helps users navigate through your website's hierarchical structure, providing a clear path back to the homepage.

    1. image

  4. Multi-column layouts with embed attribute in card component: This feature enables you to create more complex and dynamic layouts within cards.

    1. image

  5. Customizable y-axis step size in chart component with ystep attribute: This feature gives you more control over the chart's appearance, especially for situations with multiple series.

  6. Updated default graph colors for better distinction: This enhancement ensures clarity and easy identification of different data series.

  7. ID and class attributes for all components for easier styling and referencing: This improvement simplifies custom CSS customization and inter-page element linking.

  8. Implementation of uploaded_file_mime_type function: This function allows you to determine the MIME type of a uploaded file.

  9. Upgraded built-in SQLite database to version 3.45.0: This ensures compatibility with recent SQLite features and bug fixes. See sqlite release notes

  10. Unicode support for built-in SQLite database: This enables case-insensitive string comparisons and lower/upper case transformations.

  11. Improved card component with smaller margin below footer text: This fix ensures consistent and visually balanced card layouts.

SQLPage blog

Alexis's performance monitoring tool
Alexis built a performance monitoring tool with SQLPage
Come and see us in Athens !
PGConf 2024 is coming to Athens, Greece. And we will be there to talk about SQLPage & Archeology !
JSON in SQL: A Comprehensive Guide
A comprehensive guide to working with JSON data in SQLite, PostgreSQL, MySQL, and SQL Server.
How archaeology is gradually entering the era of free software
A team of french archaeologists is working on the first all-digital excavation site, using SQLPage
Introduction video
A 30-minute live presetation of SQLPage, its raison d'être, and how to use it.
SQLPage website update
Performance, security, and new features
New SQLPage, and a talk at PGConf.eu
SQLPage v0.18.0 is out, and there is detailed introduction to SQLPage on youtube
SQLPage v0.17
SQLPage v0.17 introduces file uploads, HTTPS, and more.
Come see me build twitter live on stage in Prague
I will speak about SQLPage at pgconf.eu in Prague on December 14th. Come see me !
I’m sorry I forked you
SQLPage forked the sqlx database drivers library. Here is why.
3 solutions to the 3 layer problem
What is the 3 layer problem, and how SQLPage solves it?
SQLPage versus No-Code tools
What are the advantages and disadvantages of SQLPage compared to No-Code tools?
Repeating yourself thrice won't make you a 3X developer
A dive into the traditional 3-tier architecture and the DRY principle, and how tools like SQLPage helps you avoid repeating yourself.