{"repo":"oelmekki/pgrebase","free":true,"listed":false,"github":"https://github.com/oelmekki/pgrebase","clone":"git clone https://github.com/oelmekki/pgrebase.git","description":"Easy postgres codebase injection - aka postgres non data live reload","language":"Go","stars":339,"topics":["go","golang","plpgsql","postgres","postgresql"],"license":null,"category":"databases-storage","readme_excerpt":"PgRebase Note to Github user: development is now happening on Gitlab, Github's repository is just a mirror. Please open any issue on Gitlab rather than Github. PgRebase is a tool that allows you to easily handle your postgres codebase for functions, triggers and views. Why If you started outsourcing data manipulation to your database through postgresql cool features, you probably realized this is painful. Postgresql's functions, triggers and views are not your usual codebase, they live in postgres, and you often have to drop them if you want to edit them, eg when you change a function signature. You could edit them directly in psql, but then it's migrating servers / other devs installation that becomes difficult. The classic tool for this is the migration software, asking you to manage migration files. This is great for handling tables, not so great to make frequent changes to your functions. Can we do better? What PgRebase allows you to manage your functions/triggers/views as plain files in filesystem. You put them in a sql/ directory, one file per function/trigger/type/view. No need to add drop statement in those files, PgRebase will take care of it. In watch mode (useful for development), just save your file, pgrebase will update your database. In normal mode (useful for deployment), pgrebase will recreate all functions/triggers/views found in your filesystem directory. You can now work with postgres codebase live reload, then call pgrebase just after your migration task i","default_branch":null,"files":null,"tree":[],"storefront":"/r/oelmekki","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/oelmekki/pgrebase/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."}