Re: IDE for function/stored proc development.
От | Martijn Tonies \(Upscene Productions\) |
---|---|
Тема | Re: IDE for function/stored proc development. |
Дата | |
Msg-id | D35385E8C9E2409F9147F657BFA3F15C@MARTIJNWS обсуждение исходный текст |
Ответ на | Re: IDE for function/stored proc development. (Jim Nasby <Jim.Nasby@BlueTreble.com>) |
Ответы |
Re: IDE for function/stored proc development.
|
Список | 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 по дате отправления: