What do you prefer web-based SQL client or desktop SQL client?
I am trying to build a SQL client for Postgres and was curious to know what does everyone prefer?
Desktop. I've found that a lot of web-based SQL clients pose more limitations to how much data you can bring in, causing frustration. Additionally, it seems that the solution to running multiple queries on the web is to open more tabs of the application in your browser... which isn't ideal.
Most of my work involves automating SQL through Python scripts so running queries on desktop solves the above problems and limits the amount of switching back and forth.
Web-based makes it simple. But we need to run serverside code which connects to DB. But auth & auth can be externalized. If Desktop client, it has to support mac, windows & linux. And use auth & auth of DB. Another thing is, if it has to support multiple types of DB, eg MySQL, Postgres etc., it will get complex.
Web. I don't want to run Electron app, and I don't think you can maintain a multiplatform native-feeling app as a single developer; not having the client on all platforms is a dealbreaker to me.