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!
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!