{"repo":"rvkulikov/pg-deps-management","free":true,"listed":false,"github":"https://github.com/rvkulikov/pg-deps-management","clone":"git clone https://github.com/rvkulikov/pg-deps-management.git","description":"Perfectionism through suffering","language":"PLpgSQL","stars":78,"topics":["postgresql"],"license":"MIT","category":"databases-storage","readme_excerpt":"First time? Wanna move column in a table 'cause it hurts your inner perfectionist? You new CTO/DBA decided that your current table layout must be optimized by 4 bytes per row or business will fail? Your code standards changed and all inner joins must be rewritten with where again? Uhm, why not to add some other columns for our primary table? Simple grep in your migration directory for view definition give you 20 results? You look at your migration and see copy-pasted 1000 sloc of other migrations. And the same for rollback?! What is this Complex enhancement/refactoring of https://gist.github.com/mateuszwenus/11187288 See related topics https://wiki.postgresql.org/wiki/Todo#Views and Rules Recursively backup all dependent views, then modify base tables, then recreate all backuped views Supported features Feature View Materialized View Comment -------------------------------- ------ ------------------- ---------------------------------------- Create view Yes Yes With reloptions, tablespace, (no) data Create index N/A Yes Alter owner to Yes Yes Create rule Yes Yes Comment on view Yes Yes Comment on view column Yes Yes Grant privilege on view Yes Yes With grant options Grant privilege on view column Yes Yes With grant options Create policy N/A N/A Usage Options deps save and drop dependencies dry run Run without actually dropping dependencies verbose Show debug log populate materialized view Enable or disable materialized view refresh-on-create via WITH [NO] DATA flag deps restor","default_branch":null,"files":null,"tree":[],"storefront":"/r/rvkulikov","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/rvkulikov/pg-deps-management/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}