Harlequin CHANGELOG

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

Unreleased

0.0.28 - 2023-09-07

• Buffers are now restored when harlequin is restarted (#175).

[0.0.27] - 2023-08-23

New Features

• UI glow-up: Colors are more consistent, and themes set the styling for the entire app (#81). Try harlequin -t zenburn or harlequin -t one-dark for a new look.
• Harlequin's query editor now supports more key bindings: ctrl+z and ctrl+y to undo/redo, and shift+delete to delete an entire line.

Fixes

• It is now easier to focus on the current editor buffer, instead of the tabs above it.

0.0.26 - 2023-08-21

New Features

• Harlequin supports multiple buffers (for tabbed editing). Create a new tab with ctrl+n, close a tab with ctrl+w, and switch to the next tab with ctrl+k. Opening, saving, and running queries are operations on the current buffer and have no effect on the other buffers.

0.0.25 - 2023-08-13

New Features

• Harlequin now returns the result of multiple select queries to different tabs in the Results Viewer. To run multiple queries, type them into the Query Editor (separated by semicolons), then press ctrl+a to select all, and then ctrl+enter to run the selection (#34).
• If there are multiple results tabs, you can switch between them with j and k.
• ctrl+e exports the data from the current (visible) data table.

Bug Fixes

• Fixes issues with the loading state when loading large result sets.

0.0.24 - 2023-08-04

New Features

• Adds a new CLI option, --extension or -e, which will install and load a named DuckDB extension.
• Adds a new CLI option, --force-install-extensions, which will re-install the extensions provided
  with the -e option.
• Adds a new CLI option, --custom-extension-repo, which enables installing extensions other than
  the official DuckDB extensions.
• Taken together, Harlequin can now be loaded with the PRQL extension. Use PRQL with Harlequin:

  harlequin -u -e prql --custom-extension-repo welsch.lu/duckdb/prql/latest

  (#152 - thank you @dljsjr!)

0.0.23 - 2023-08-03

Features

• 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
• Adds path autocomplete and validation to the file save/open and export data inputs.

Other Changes

• Lowers the maximum number of records loaded into the results viewer to 10,000. (All records can be exported with ctrl+e)

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.