v1.2.0.1

Hotfix flight parameter error #60

v1.2

This release features a architectural refactor making the codebase domain-partitioned and more testable. Sqlit embraces now Textual's reactivity system. In addition to the technical overhaul, this release has had a massive focus on the query editor experience, including Vim motion support, transaction management, and running multiple queries at the same time with stacked result tables.

New Features

Editor & UI

• Standard Keybindings: Added support for standard text editing shortcuts: Ctrl+A, Ctrl+C, Ctrl+V, and Ctrl+Shift+Arrows.
• Comment/Uncomment: Added functionality to quickly toggle comments on code lines.
• Autocomplete: Improved autocomplete suggestions.
• Help Menu: Revamped the help menu
• File Picker: Added a file picker for selecting SQLite databases.
• History search You can now filter query history by content.'
• SSL/TSL support Added 'TLS tab' for encrypted connections. Closes #56

Results & Data

• Export Options: You can now export data directly from the results view to JSON or CSV. Closes #55
• Multiple Results: Added support for viewing multiple result tables simultaneously.
• Multiple concurrent Execution: Run several SQL statements in one query. #33

Transaction Support

• Transaction Mode: Support for queries initiated with BEGIN.
• Quick Transaction: Run the current query as a transaction:

Vim Mode Integration #39

After much thought, I have decided to implement and embrace "pseduo-vim," in the sense that you use familiar vim keys, but with native undo history and clipboard. I've decided to add ctrl+a, ctrl+c,ctrl+v, etc for insert mode, so sqlit is both practical for those who is not familiar with vim, but vim motions are optional. My goal is that sqlit is perfectly intuitive for all users, but vim motions can be used to increase speed.

• Motions: Full support for delete, yank, change.
• Navigation: Added cursor movements (h, j, k, l), line opening (o), and standard motions (g, d, c, y).
• Leader Menu: Encapsulated actions inside a new leader menu.

New Database Support

• Oracle (Legacy)
• IBM Db2
• SAP HANA
• Teradata
• Trino
• Presto
• Apache Flight (@abarmat)

Changes & Refactoring

Keymap Changes

• History Navigation: Remapped history access from h to <Backspace>.
• Tree Search: Removed n/N for up/down navigation in tree search.
• Server Connection: Enter now goes straight to "Connect to Server".

Internal Improvements

• Refactor: Complete code refactor to domain-partitioned architecture.
• Reactivity: Better leverage of Textual's reactivity system.
• Testability: Improved code testability and maintainability.

Bug Fixes

• Fixed miscellaneous cache invalidation issues.
• Fixed Docker discovery bugs.
• Fixed a bug regarding password resetting.
• Fixed an issue where empty columns were displaying incorrectly. Fixes #52

v1.1.14

Changed installation helper from ^i to ^d for universal terminal compatibility

v1.1.13

What's Changed

• Hotfix PyMySQL localhost resolution to IPv6 (PyMySQL/PyMySQL#509)

v1.1.12

What's Changed

Fixed the outdated installation guidance for the old mysql package

v1.1.11

Added max width on columns in result table. Fixes #48
Added preview cell function, replaces the 'v' keybinding
View cell is now inside the results view instead of a floating dialog. Triggered by 'V* keybinding

v1.1.10

Added cloud CLI discovery to 'Connect' module: You have now a convenient way of discovering and connecting to databases connected to your Azure / AWS / Google cloud platform accounts, via their respective CLI's.

Made Docker discovery more reliable - Fix misc bugs
Changed Mysql package to PyMySQL for more reliability
Improved package installation wizard (You can press 'enter' to install with detected manager first, instead of having to copy paste the correct command)
Added Firewall exception creation dialog when connecting to Azure database when you have an authenticated Azure CLI
Added Amazon Redshift adapter
Added BigQuery adapter

v1.1.9

The autocomplete update

This update introduces a sophisticated SQL completion engine with context-aware DML/DDL suggestions, leveraging schema caching and lazy loading table metadata for autocompletions, and a new idle scheduler for background jobs.

It also adds cross-database query handling with capability detection, adapter improvements for various databases.

When no default database is selected, a UI indicator now shows which database you're connected to. Expanding a database with Enter automatically selects it, replacing the previous 'u' shortcut.

Table expansion and querying is now more robust for databases that don't support cross-database queries. This fixes Postgres and D1 tables appearing empty when no default database is selected, and resolves query errors on Azure SQL. For these databases, we now silently reconnect in the background instead of issuing "use" commands, maintaining a seamless experience.

Fixes #43
Highly likely fixes #4

+Added Athena adapter #38 Thanks @floscha

v1.1.8

Added beautiful new themes (Omarchy compatible)
Added option to customize your own theme. Closes #44
Fixed SQL highlighting for light themes
Theme is previewed as you browse

Terminal default (uses your default terminal theme)

Hackerman

Everforest

Kanagawa

Matte-black

Ristretto

Osaka-jade

Sqlit-light

v1.1.7

• Swap out pyodbc with mssql-python to remove ODBC installation requirement for MSSQL. Thanks @dzsquared
• Remove "Advanced" tab for new connection menu
• Fix turso adapter. Thanks @bertilxi Closes #32