Let Postgres Do the Work (2013)

Re:Let Postgres Do the Work (2013) by jeffasinger on Saturday November 26, 2016 @05:12PM (#13046200)

At work we use a rather idiosyncratic tool called RoundhousE to deploy our SQL. It treats sql labelled as a stored procedure differently, and will run the file on every deploy, as opposed to scripts that alter the schema, which are only ran once, and may not be modified.

The system works pretty well.

[ Parent | on HN ]

Re:Let Postgres Do the Work (2013) by slagfart on Saturday November 26, 2016 @05:31PM (#13046311)

You don't need a tool for this. If you store base data in one schema, and functions/views in another, you can update this second schema willy nilly without worrying about damaging your data.

Just start the second file with DROP SCHEMA IF EXISTS schemaname CASCADE; CREATE SCHEMA schemaname;. Then, make sure any functions/views/permissions built on top of this schema are also contained within this file.

[ Parent | on HN ]

Re:Let Postgres Do the Work (2013) by inopinatus on Saturday November 26, 2016 @06:21PM (#13046612)

Or you can just pull the SQL for the stored procedure from a table column and execute it dynamically.

Now it's an ops problem :-)

[ Parent | on HN ]

Re:Let Postgres Do the Work (2013) by jessaustin on Sunday November 27, 2016 @07:54AM (#13048903)

Haha, usually we hear this from smart guys who have been working for about 8 months...

[ Parent | on HN ]

Re:Let Postgres Do the Work (2013) by angersock on Saturday November 26, 2016 @10:45PM (#13047573)

Oh, that's slick. Nice!

[ Parent | on HN ]