v0.34.0

v0.34 (2025-03-23)

✨ Top Features at a Glance

• HTML-enhanced Markdown in text components
• Sticky table footers for better data presentation
• Multiple bug fixes

🔒 Security First

POST-based Deletions

List component's delete_link now uses secure POST requests:

SELECT 'list' AS component;
SELECT 'Delete me' AS title, 'delete_item.sql?id=77' AS delete_link;

Prevents accidental deletions by web crawlers and follows REST best practices

Protected Internal Files

• Files/folders starting with . (e.g., .utils/) are now inaccessible
• Perfect for internal scripts used with sqlpage.run_sql()

🎨 UI & Component Upgrades

Table Styling Revolution

/* Before: .price | After: */
._col_price { 
    background: #f8f9fa;
    border-right: 2px solid #dee2e6;
}

• New CSS class pattern: ._col_{column_name}
• Fixes #830

Column component

SELECT 'columns' AS component;
SELECT 'View details' AS title; -- No button shown

• Columns without button text now hide empty buttons
• Cleaner interfaces by default

Sticky Table Footers

SELECT 
    'table' AS component,
    true AS freeze_footers;
SELECT 
    'Total' AS label,
    SUM(price) AS value,
    true AS _sqlpage_footer;

• Keep summary rows visible during scroll
• Use _sqlpage_footer on your final data row

🌍 Internationalization

Right-to-Left Support

SELECT 'shell' AS component, true AS rtl;

• Enable RTL mode per page via shell component
• Perfect for Arabic, Hebrew, and Persian content

📝 Content Handling

Rich Text Power

SELECT 'text' AS component,
       '<div class="alert alert-warning">
       **Important!**
       
       New *HTML-enhanced* content.
       </div>' 
       AS unsafe_contents_md;

• New unsafe_contents_md allows HTML+Markdown mixing

Base64 Image Support

![Alt text](data:image/png;base64,iVBORw0KGg...)

• Embed images directly in Markdown fields

⚙️ Configuration Tweaks

{
  "markdown_allow_dangerous_html": false,
  "markdown_allow_dangerous_protocol": false
}

• Markdown safety controls to change markdown rendering settings

🐛 Notable Fixes

• SQL Server
  Fixed TINYINT handling crashes
• Anchor Links
  Corrected display in tables with fixed headers
• Form Inputs
  Proper handling of 0 values in number fields

💡 Upgrade Guide

1. CSS Updates
   Search/replace .your_column → ._col_your_column if you have custom css targetting tables.
2. Deletion Flows
   Test list components using delete_link.
   You can now add a check that the request method is POST if you want to forbid deletions by simply loading pages.

View full configuration options →