I tried a bunch of different IDEs and editors, and the dev toolset that I finally settled on is as follows:
- Atom editor for all coding and refinement
- Jetbrains DataGrip for code execution and most DBA work
- PGAdmin for other DBA that I can't do in DG
- Gitkraken for version control and pushing codebase to remote repo for offsite backup
Atom is simply the best code editor currently available and has a very active dev community.
DataGrip is by no means perfect, partly because it is such a new project. But Jetbrains is very receptive to user input and has a rather aggressive development strategy to implement user requests.
Gitkraken is simply awesome and my go-to GUI for VCS.
An added benefit of this particular toolset is that they work equally well on Mac and Windows.
From: Tim Uckun Sent: Saturday, September 03, 2016 2:37 AM
Does anybody use an IDE for doing heavy duty stored proc development? PGadmin is decent but I am looking for something better.
I have been using the Datagrip app (from Jetbrains), from its beta release up through now v 2016.2 and love it. Full autocomplete, it has my object browser on the left, source code file browser on the right (I have it tied into our git), massively customizable to look and behave any way you want it. It is not effective yet for admin tasks. I really love the modern interface. I have zero connection to the company, paid for a license ($200). Worth every penny.
I’m a hardcore stored proc/func dev, building database api’s for the large systems I design/build…I write a LOT of code and datagrip is where I do it. I also use the crash-prone PgAdminIII for admin stuff like table mods, quick scripting of table def or insert columns, or backups, etc…the normal admin stuff.
MikeS