4 ms·
Looks cool. I've tried most clients and been dissapointed - PgAdmin was very unstable on mac, object browser is good when it works but query editor is poor - Po
by garyclarke27 11y ago
Looks cool.
I've tried most clients and been dissapointed - PgAdmin was very unstable on mac, object browser is good when it works but query editor is poor - Postico is pretty but has very limited functionality not suitable for large complex scripts.
The best solution I found was to use Sublime Text with it's build system you can run scripts and get results easily, it has amazing text manipulation features, snippits are powerful, it's rock solid and blazingly fast.
http://blog.code4hire.com/2014/04/sublime-text-psql-build-system/ http://blog.code4hire.com/2014/04/sublime-text-psql-build-sy...
- garyclarke27 11y agoI forgot to mention Sublime Text 3 has hundreds of powerful free packages which are simpple to install including postgresql sql keyword highlighting. https://packagecontrol.io/packages/PostgreSQL%20Syntax%20Highlighting https://packagecontrol.io/packages/PostgreSQL%20Syntax%20Hig...
- infinite8s 11y agoWhat was missing from Postico? Just better SQL editing support?
- garyclarke27 11y agoWhen I last used it about a year ago (i purchased it) it lacked many basic features a deal breaker for me was not showing the line number of errors, this made it useless for large scripts. Sublime Text's search and replace is light years ahead of Postico or PgAdmin. Also syntax highlighting on a nice dark theme is much easier on the eyes and more productive than white theme. Sublime Text 3 also has auto-complete - if you install plugin to search ALL open files not just current, then this works really well so long as you also open files defining your schema. Snippets can add even more powerful auto complete.