Postico
Postico copied to clipboard
Add support for Snowflake via JDBC
I used Postico every day when the company I was working for back then was using Amazon Redshift. When we transitioned to Snowflake, I had to replace Postico with Snowflake's web-based query editor which works well but lacks some of features of a native macOS app.
Nearly all of the projects I'm involved in and everyone I know is using Snowflake or is in the process of transitioning. I was wondering how much effort it would be to add JDBC support and change parts of the connection modal so that Postico supports Snowflake.
I understand you've built a prototype for JDBC-based connection strings in #377 (link to post) so I'm hoping Postico maybe already uses JDBC under the hood.
BTW I'm not expecting full support for the Snowflake SQL dialect. If I could use Postico to connect to Snowflake databases and run queries, read-only if need be, I'd be a happy man.
Let me know if I can support in any way e.g. by providing more information or contributing code or resources. I've never developed a macOS app but I do have a software engineering background so I could roll up my sleeves.