Jailer VS harlequin

Some other tools I have also enjoyed:

DBVisualizer: https://www.dbvis.com/ (for exploring the schema)

Jailer: https://wisser.github.io/Jailer/ (for data browsing)

Aside from that, it's usually just been a mix of using specialized tools like MySQL Workbench, SQL Developer, pgAdmin and others, or something that tries to do it all like DataGrip.

Didn't actually find anything particularly amazing about DataGrip, but if I'm paying for the JetBrains Ultimate subscription, might as well use it because it's pretty okay.

I also found DBeaver to be a huge improvement over tools I used earlier.

Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer

For the past four months I've been working (part-time, this is OSS after all) on Harlequin, a SQL IDE for DuckDB that runs in your terminal. I built this because I work in Data, and I found myself often reaching for the DuckDB CLI to quickly query CSV or Parquet data, but then hitting a wall when using the DuckDB CLI as my queries got more complex and my result sets got larger.

Harlequin is a drop-in replacement for the DuckDB CLI that runs in any terminal (even over SSH), but adds a browsable data catalog, full-powered text editor (with multiple buffer support), and a scrollable results viewer that can display thousands of records.

Harlequin is written in Python, using the Textual framework. It's licensed under MIT.

Today I released v1.0.0, and I'm excited to share Harlequin with HN for the first time. You can try it out with `pip install harlequin`, or visit https://harlequin.sh for docs and other info.