Thread: IDE for function/stored proc development.
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?
Hi
2016-09-03 11:36 GMT+02:00 Tim Uckun <timuckun@gmail.com>:
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.
Regards
Pavel
I was hoping there was some IDE which made that process seamless. Something like PgAdmin but better editing features and features like "find definition" or "find usages" and such. The jetbrains products come close but as I said they are buggy and don't work very well with postgres.
On Sat, Sep 3, 2016 at 11:03 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hi2016-09-03 11:36 GMT+02:00 Tim Uckun <timuckun@gmail.com>: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.RegardsPavel
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
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.
On Sep 3, 2016, at 9:28 AM, Mike Sofen <msofen@runbox.com> wrote: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
On 09/03/2016 02:36 AM, Tim Uckun wrote: > 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? Yes. Short answer: psql Long answer: psql is the glue that ties together my work. 1) Working in it I have access to \e for editing general scripts and \ef for function scripts. Coming in 9.6 \ev for working on views. Handy for testing out ideas. It is also possible to use DO to try out code snippets. 2) For the most part the objects I create originate as scripts that I can run either from within psql using \i or pass in with -f or a redirection. 3) I use Sqitch(http://sqitch.org/) to manage the object deployment and it uses psql when talking to Postgres. Currently I use Atom to do my heavy duty text editing, but I am not tied to it as any competent text editor can generate/work with the scripts I mention above. Makes it easy to switch from machine to machine with out dragging an IDE along. -- Adrian Klaver adrian.klaver@aklaver.com
Hello Tim,
We will be releasing Database Workbench with PostgreSQL support later this week, it’s a Windows application but works fine on Linux/MacOS via Wine.
Here’s the link to our website, feel free to check some screenshots
With regards,
Martijn Tonies
Upscene Productions
Martijn Tonies
Upscene Productions
From: Tim Uckun
Sent: Saturday, September 03, 2016 2:49 PM
To: Pavel Stehule
Cc: pgsql-general
Subject: Re: [GENERAL] IDE for function/stored proc development.
I was hoping there was some IDE which made that process seamless. Something like PgAdmin but better editing features and features like "find definition" or "find usages" and such. The jetbrains products come close but as I said they are buggy and don't work very well with postgres.
On Sat, Sep 3, 2016 at 11:03 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hi2016-09-03 11:36 GMT+02:00 Tim Uckun <timuckun@gmail.com>: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.RegardsPavel
On Mon, Sep 5, 2016 at 10:02 AM, Martijn Tonies (Upscene Productions) <m.tonies@upscene.com> wrote:
Hello Tim,We will be releasing Database Workbench with PostgreSQL support later this week, it’s a Windows application but works fine on Linux/MacOS via Wine.Here’s the link to our website, feel free to check some screenshotsWith regards,
Martijn Tonies
Upscene ProductionsFrom: Tim UckunSent: Saturday, September 03, 2016 2:49 PMTo: Pavel StehuleCc: pgsql-generalSubject: Re: [GENERAL] IDE for function/stored proc development.I was hoping there was some IDE which made that process seamless. Something like PgAdmin but better editing features and features like "find definition" or "find usages" and such. The jetbrains products come close but as I said they are buggy and don't work very well with postgres.On Sat, Sep 3, 2016 at 11:03 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:Hi2016-09-03 11:36 GMT+02:00 Tim Uckun <timuckun@gmail.com>: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.RegardsPavel
Good day, Martijn
I looked at your purchase, and did not see any Postgres version. Am I missing (/misunderstanding) something here?
Kind regards,
Na-iem Dollie
Good morning,
>I looked at your purchase, and did not see any Postgres version. Am I missing (/misunderstanding) something here?
It’s not yet available, please wait until the end of the week 
That being said, the pricing will be the same as for MySQL.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Martijn Tonies
Upscene Productions
http://www.upscene.com
Attachment
I do use Dbwrench, but is pretty basic, no fancy procedures / function development support.
Enviado do meu smartphone Sony Xperia™
---- Pavel Stehule escreveu ----
Hi
2016-09-03 11:36 GMT+02:00 Tim Uckun <timuckun@gmail.com>:
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.
Regards
Pavel
---- Martijn Tonies (Upscene Productions) escreveu ----
> Good morning,
>
> >I looked at your purchase, and did not see any Postgres version. Am I missing (/misunderstanding) something here?
>
> It’s not yet available, please wait until the end of the week
>
> That being said, the pricing will be the same as for MySQL.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
Would be nice to have a table which enlist all features (in rows) and databases (in cols), and on intersections, add the "since date... ", "from date ..." or "planned" status...
You can split the table by bundle (basic /enterprise) so you will help your visitors to better understand your offer...
Just my 2c.
Sorry for being off topic...
Edson Richter
On 9/3/16 7:49 AM, Tim Uckun wrote: > I was hoping there was some IDE which made that process seamless. > Something like PgAdmin but better editing features and features like > "find definition" or "find usages" and such. The jetbrains products > come close but as I said they are buggy and don't work very well with > postgres. Keep in mind that workflow doesn't work well if you need to deploy to production on a regular basis. The workflow I generally use is sqitch[1] and a thin wrapper that runs my unit tests (you do write unit tests for your functions, right? :)). Something like: revert_to=`sqitch tag|tail -n2|head -n1` # Get second to last deployed tag sqitch rebase -y --onto $revert_to $DB && sqitch rebase -y --onto $revert_to $DB && db/run_test $DB Normally you won't be re-deploying that much, so that would be pretty fast. Note that you'll want to create a separate sqitch migration for each object. [1] http://sqitch.org/ -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461
Hi, For what it's worth, Database Workbench with PostgreSQL support was released Yesterday. http://www.upscene.com/database_workbench/whatsnew With regards, Martijn Tonies Upscene Productions -----Original Message----- From: Jim Nasby Sent: Thursday, September 08, 2016 1:33 AM To: Tim Uckun ; Pavel Stehule Cc: pgsql-general Subject: Re: [GENERAL] IDE for function/stored proc development. On 9/3/16 7:49 AM, Tim Uckun wrote: > I was hoping there was some IDE which made that process seamless. > Something like PgAdmin but better editing features and features like > "find definition" or "find usages" and such. The jetbrains products > come close but as I said they are buggy and don't work very well with > postgres. Keep in mind that workflow doesn't work well if you need to deploy to production on a regular basis. The workflow I generally use is sqitch[1] and a thin wrapper that runs my unit tests (you do write unit tests for your functions, right? :)). Something like: revert_to=`sqitch tag|tail -n2|head -n1` # Get second to last deployed tag sqitch rebase -y --onto $revert_to $DB && sqitch rebase -y --onto $revert_to $DB && db/run_test $DB Normally you won't be re-deploying that much, so that would be pretty fast. Note that you'll want to create a separate sqitch migration for each object. [1] http://sqitch.org/ -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
On 08/09/16 19:42, Martijn Tonies (Upscene Productions) wrote: > Hi, > > For what it's worth, Database Workbench with PostgreSQL support was > released Yesterday. > > http://www.upscene.com/database_workbench/whatsnew > > > With regards, > > Martijn Tonies > Upscene Productions [...] Hmm... exe's don't work natively on Linux...
Hi, >> For what it's worth, Database Workbench with PostgreSQL support was >> released Yesterday. >> >> http://www.upscene.com/database_workbench/whatsnew >> >> >> With regards, >> >> Martijn Tonies >> Upscene Productions >[...] > >Hmm... exe's don't work natively on Linux... Of course they don't. Here's some guides for Wine - we have several customers using the product on Linux all the time. http://www.upscene.com/company/support Hope this helps. With regards, Martijn Tonies Upscene Productions http://www.upscene.com
On Sat, 2016-09-03 at 21:36 +1200, Tim Uckun wrote: > 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've not yet used it much but dbeaver http://dbeaver.jkiss.org/ seems robust. Both the Enterprise and Community edition are free. Community edition is open source, EE is not. it may be worth a look