github TableProApp/TablePro v0.2.0

one month ago

Added

  • SSL/TLS connection support for MySQL/MariaDB and PostgreSQL with configurable modes (Disabled, Preferred, Required, Verify CA, Verify Identity) and certificate file paths
  • RFC 4180-compliant CSV parser for clipboard paste with auto-detection of CSV vs TSV format
  • Explain Query button in SQL editor toolbar and menu item (⌥⌘E) for viewing execution plans
  • Connection switcher popover for quick switching between active/saved connections from the toolbar
  • Date/time picker popover for editing date, datetime, timestamp, and time columns in the data grid
  • Read-only connection mode with toggle in connection form, toolbar badge, and UI-level enforcement (disables editing, row operations, and save changes)
  • Configurable query execution timeout in Settings > General (default 60s, 0 = no limit) with per-driver enforcement via statement_timeout (PostgreSQL), max_execution_time (MySQL), max_statement_time (MariaDB), and sqlite3_busy_timeout (SQLite)
  • Foreign key lookup dropdown for FK columns in the data grid — shows a searchable popover with values from the referenced table, displaying both the ID and a descriptive display column
  • JSON column editor popover for JSON/JSONB columns with pretty-print formatting, compact mode, real-time validation, and explicit save/cancel buttons
  • Excel (.xlsx) export format with lightweight pure-Swift OOXML writer — supports shared strings deduplication, bold header rows, numeric type detection, sheet name sanitization, and multi-table export to separate worksheets
  • View management: Create View (opens SQL editor with template), Edit View Definition (fetches and opens existing definition), and Drop View from sidebar context menu. Adds fetchViewDefinition() to all database drivers (MySQL, PostgreSQL, SQLite)

Fixed

  • Fixed crash on launch on macOS 13 (Ventura) caused by missing Swift runtime symbol
  • Fix redo functionality in data grid (Cmd+Shift+Z now works correctly)
  • Fix redo stack not being cleared when new changes are made (standard undo/redo behavior)
  • Fix canRedo() always returning false in data grid coordinator
  • Wire undo/redo callbacks directly to data grid for proper responder chain validation
  • Fix MariaDB connection error 1193 "Unknown system variable 'max_execution_time'" by using the correct max_statement_time variable for MariaDB
  • Query timeout errors no longer prevent database connections from being established

Changed

  • Replace all print() statements with structured OSLog Logger across 25 files for better debugging via Console.app

Don't miss a new TablePro release

NewReleases is sending notifications on new releases.