Re: IDE for function/stored proc development. - Mailing list pgsql-general

From Martijn Tonies \(Upscene Productions\)
Subject Re: IDE for function/stored proc development.
Date
Msg-id D35385E8C9E2409F9147F657BFA3F15C@MARTIJNWS
Whole thread Raw
In response to Re: IDE for function/stored proc development.  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: IDE for function/stored proc development.
List pgsql-general
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


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Setup pgpool-II with streaming replication
Next
From: Nicolas Grilly
Date:
Subject: Re: What limits Postgres performance when the whole database lives in cache?