Does anybody use an IDE for doing heavy duty stored proc development? PGadmin is decent but I am looking for something better.
I have tried jetbrains with the db browser plugin and on the surface it seems like a good choice but it's really buggy when working with procs.
I also tried datagrip by jetbrains and that too seems to be all over the place. It has some amazing features for working with the database but some of the simplest stuff is lacking or half baked.
I looked at atom and could not find any useful plugins for PG.
Anybody have experience with something awesome?
I am using the Emacs - but any editor should be ok. There is one rule - edit file first, and import to database as next step. PGadmin is pretty bad tool for maintaing stored procedures.