Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

OpenLegacy Community

  1. Home
  2. SQOL
  3. Release Notes v1.4.0

Release Notes v1.4.0

Scheduled Pinned Locked Moved SQOL
1 Posts 1 Posters 25 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • roi.mR Offline
    roi.mR Offline
    roi.m
    wrote on last edited by
    #1

    Release Notes

    Release Date: January 4, 2026
    Commit Range: 1fb65668be92f706fb3347e0b9aa78c24d4603dc to c0adef4


    🎯 High-Level Summary

    Query Console Enhancements

    Interactive Data Editing & Management

    • Direct cell editing in query results with inline editing for short values and dialog-based editing for long values
    • Visual tracking of modified rows with protected primary key columns
    • One-click UPDATE/DELETE statement generation with automatic WHERE clause creation using primary keys
    • Column sorting with type-aware ordering and automatic ORDER BY clause generation

    Database Schema Management

    Comprehensive Schema Tools

    • Stored procedures browser with metadata viewing and automatic CALL statement generation
    • Visual table designer for CREATE TABLE and ALTER TABLE operations with database-specific DDL generation
    • Interactive schema graph visualization showing tables, relationships, and foreign keys with pan/zoom capabilities

    Hub Integration & Settings

    Enhanced Hub Workflow

    • Personal Hub settings configuration with local storage and admin-controlled visibility
    • Collapsible SQL query editing panel with JDBC style conversion
    • Enhanced asset name suggestions based on SQL operations
    • Success dialogs with OL Hub URL display for created assets

    Query Chat & AI Features

    Intelligent Query Assistance

    • Prompt suggestions for data analysis and schema improvements
    • SQL query extraction from chat messages with direct execution capability
    • Schema optimization recommendations (normalization, indexing, partitioning)
    • Foreign key relationship analysis and referential integrity suggestions

    Connection & Admin Management

    Improved Configuration

    • Schema autocomplete in connection dialog with refresh functionality
    • Admin settings for Hub UI URL configuration
    • Enhanced tooltips and user guidance throughout the application
    • Tab management and conditional log visibility in admin panel

    Editor & UI Improvements

    Modern Development Experience

    • Monaco Editor integration for enhanced SQL editing with syntax highlighting
    • Improved visual styling and user feedback across components
    • Signal-based state management for better reactivity and synchronization

    1 Reply Last reply
    0
    Reply
    • Reply as topic
    Log in to reply
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes


    • Login

    • Login or register to search.
    Powered by NodeBB Contributors
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • World
    • Users
    • Groups