4 ms·
PG: Great in theory, virtually no GUI tooling that's up to the task. MSSQL: Excellent, wish it ran on Linux.
by breakingcups 11y ago
PG: Great in theory, virtually no GUI tooling that's up to the task.
MSSQL: Excellent, wish it ran on Linux.
- tuyguntn 11y agoCould you elaborate, why PG is great on theory? I have mostly worked with only PG and have little experience with MSSQL, but latest versions of PG is really great.
- breakingcups 11y agoWell, reading about all the features PG has makes me very excited. Purely querying from PG also makes me happy thus far. What I'm uneasy about is administration (backups, etc.). I guess part if it is also that I'm very used to the MS tooling, which is truly superb. This makes some of the administration steps for PG seem a bit outdated and clunky, which could be a very unfair bias from my side. Maybe another way of putting it would be that the core is great, but the edges a bit rough for my spoiled, delicate hands.
- icebraining 11y agoHave you looked at third-party tools? Postgres may not come with everything builtin, but it supports the necessary underlying features for external tools like Barman[1] to work. [1] http://www.pgbarman.org/ http://www.pgbarman.org/
- samspenc 11y agoHave you tried Aqua Data Studio? Its not just for PG - can connect to quite a few different DB types and works really nicely with all of them. Aqua is commercial software, but pretty inexpensive, and we use it at my company to connect to the different databases we work with.
- breakingcups 11y agoI haven't yet, I might look into that.
- subrat_rout 11y agoWhat about pgAdmin3. I have been using is for last two years and it gets the job done.