Harlequin CHANGELOG

All notable changes to this project will be documented in this file.

Unreleased

0.0.23 - 2023-08-03

• Changes the behavior of the "Run Query" button and ctrl+enter:
  • If text is selected, and that text does not contain parsing errors, the "Run Query" button will show "Run Selection", and ctrl+enter will run the selected text. If multiple queries are selected (separated by semicolons), they will all be run; if multiple select statements are selected, only data from the first selected select statement will be loaded into the Results Viewer (or exported).
  • If no text is selected, Harlequin will run the single query where the cursor is active. Other queries before and after semicolons will not be run.
  • To "Run All", first select all text with ctrl+a, and then run selection with ctrl+enter
• Lowers the maximum number of records loaded into the results viewer to 10,000. (All records can be exported with ctrl+e)

Features

• Adds path autocomplete and validation to the file save/open and export data inputs.

0.0.22 - 2023-08-02

Features

• Export data from a query with ctrl+e (#149 - thank you, @Avsha-Chai).

0.0.21 - 2023-07-28

Features

• Add -u/-unsigned/--allow-unsigned-extensions CLI flag for allowing loading of unsigned extensions.
• File save and open dialog can now expand the user directory (~) (#61)

Bug Fixes

• Error modal no longer crashes.
• Text selection is now maintained when pressing more keys.

0.0.20 - 2023-07-17

Features

• F1 now displays a help screen that lists all keyboard bindings (#20).
• F2 focuses the keyboard on the query editor.
• F5 focuses the keyboard on the results viewer.
• F6 focuses the keyboard on the data catalog.

Bug Fixes

• ctrl+v for paste is now better-supported on all platforms.

0.0.19 - 2023-06-26

Features

• It's back: select text in the query editor using click and drag (#42).

Bug Fixes

• Fixes a bug where PgUp could cause a crash (#46).

0.0.18 - 2023-06-23

Bug Fixes

• Changes format action key binding from ctrl+` to F4. The original binding was causing compatibility
  issues with Windows Powershell and Command Prompt (#82).
• Adds key binding F9 as an alternative to ctrl+b to hide the left-hand panel.
• Fixed query editor scrollbar color to match other widgets (#109)
• Fixed compatibility with Textual v0.28.0 (#115)

0.0.17 - 2023-06-23

Features

• Supports MotherDuck! harlequin md: connects to your MotherDuck instance. Optionally pass token with --md_token <token> and set SaaS mode with --md_saas.

Bug Fixes

• Fixes issues with mouse input and focus by rolling back textual_textarea to v0.2.2

0.0.16 - 2023-06-20

• Press F10 with either the Query Editor or Results Viewer in focus to enter "full-screen" mode for those widgets (and hide the other widgets). (#100)
• Select text in the query editor using click and drag (textual-textarea/#8)

0.0.15 - 2023-06-17

• Adds checkbox for Limit with a configurable input (#35).
• Adds more obvious Run Query button (#76).
• Press ctrl+b to toggle (hide/show) the Data Catalog sidebar. (#29, #103)
• Removes the Header for more working space.

0.0.14 - 2023-06-15

Features

• The schema viewer (now called Data Catalog) now supports multiple databases.
  (#89 - thank you
  @ywelsch!)
• Harlequin can be opened with multiple databases by passing them as CLI args:
  harlequin f1.db iris.db. Databases can also be attached or detached using
  SQL executed in Harlequin.

Bug Fixes

• Reimplements ctrl+` to format files (regression from 0.0.13)
• Updates textual_textarea, which fixes two bugs when opening files
  and another bug related to scrolling the TextArea.

0.0.13 - 2023-06-15

Features

• Harlequin accepts a new argument, -t/--theme to set the Pygments theme for the query editor.
• Harlequin uses the system clipboard for copying and pasting queries.

Under the hood

• Refactors to use the new tconbeer/textual-textarea package.

0.0.12 - 2023-05-31

• improves documentation of ctrl+j as an alternative key binding for running a query (#71 - thank you @carteakey!)

0.0.11 - 2023-05-18

• adds a command-line option (-r, -readonly, or --read-only) for opening
  the database file in read-only mode.
• after a query is executed and the data is loaded, the focus shifts to the data table.

0.0.10 - 2023-05-17

• upgrades duckdb to v0.8.0, which includes some breaking changes around types. Harlequin can no longer support earlier versions of duckdb.

0.0.9 - 2023-05-16

• fixes an issue where a DuckDB Error could cause Harlequin to crash (#56 - thank you @Mause!)
• removes docker builds (app UX was poor in a container)

0.0.8 - 2023-05-15

• Cut, copy, paste in text editor with ctrl+x, ctrl+c, ctrl+u/ctrl+v
• Quit with ctrl+q, instead of ctrl+c
• tab indents selected text or inserts four-ish spaces in text editor; shift+tab dedents selected text
• scroll up and down with ctrl+up and ctrl+down
• fixes an issue where an extra space would be added to the end of lines when pressing enter in some situations.

0.0.7 - 2023-05-12

• Comment selected text with ctrl+/
• Smarter indentation after pressing enter

0.0.6 - 2023-05-09

• Select text in the query editor using shift and arrow keys, etc. Replace/delete/quote selection, etc.
• Improves behavior of inserting opening brackets in the query editor.
• Hopefully fixes Docker build

0.0.5 - 2023-05-08

• Adds column types to the column header in the results viewer.
• Text editor now handles page up/dn and ctrl+right/left keys.
• Fixes compatibility with all Pythons >= 3.8

0.0.4 - 2023-05-05

• All-new text area for query editing, with syntax highlighting, scrolling, and more.
• Loading states and progress bars for long-running queries. Better async use to maintain responsiveness.
• Fixed edge cases around empty and repeated queries.

0.0.3 - 2023-05-04

• Queries now run asynchronously.
• Errors from DuckDB are now handled and shown in a pop-up.
• View columns and data types in the schema viewer sidebar.
• Queries can be formatted using ctrl+`.
• Queries can be saved using ctrl+s and opened (loaded) using ctrl+o.

0.0.2 - 2023-05-02

• View the schema of a DuckDB database in the sidebar.
• Run queries and view the results.

0.0.1 - 2023-05-02

• Use the DuckDB CLI.