From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
---|---|
To: | Tim Uckun <timuckun(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: IDE for function/stored proc development. |
Date: | 2016-09-07 23:33:57 |
Message-ID: | 2ff7f438-2588-d800-dc0b-3297b26ef775@BlueTreble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-09-07 23:39:21 | Re: How to assemble all fields of (any) view into a string? |
Previous Message | John R Pierce | 2016-09-07 23:31:02 | Re: How to assemble all fields of (any) view into a string? |