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