Show HN: DuckDB Powered SQL Editor https://ift.tt/Fxhom5X

Show HN: DuckDB Powered SQL Editor Hi guys, I made an SQL editor that utilizes the duckDB engine to process your queries. As a result, the speed gains are +25% when compared to using any standard editor that connects through JDBC. I built this because I work on a small data team and we can't justify an OLAP database. Postgres is amazing but, if I try to run any extremely complex queries I get stuck waiting for several minutes to see the result. This makes it hard to iterate and get through any sort of analysis. That's when I got the idea to use duckDB's processing engine rather than the small compute available on my Postgres instance. I didn't enjoy writing SQL in a Python notebook and wanted something like dBeaver that just worked, so I created soarSQL. Try it out and let me know if it has a place in your toolkit! https://soarsql.com April 5, 2025 at 01:40AM