https://wiki.postgresql.org/api.php?action=feedcontributions&user=Michelp&feedformat=atom
PostgreSQL wiki - User contributions [en]
2024-03-28T14:21:28Z
User contributions
MediaWiki 1.35.13
https://wiki.postgresql.org/index.php?title=Change_management_tools_and_techniques&diff=35374
Change management tools and techniques
2020-09-25T17:33:07Z
<p>Michelp: /* Schema management tools */</p>
<hr />
<div>This page describes various tools and methodologies for conducting database changes and deploying them. It includes tools to manage schema changes (via patches, or by adding complete SQL files), sproc changes and data migrations.<br />
<br />
== Schema management tools ==<br />
* [https://gitlab.com/depesz/Versioning Versioning ] by Hubert "depesz" Lubaczewski [http://www.depesz.com/2010/08/22/versioning/ blog post]<br />
* [https://github.com/theory/sqitch Sqitch] by David Wheeler [http://sqitch.org official website]<br />
* [https://github.com/gilt/schema-evolution-manager Schema evolution manager (sem) ] by Gilt Groupe [https://speakerdeck.com/mbryzek/schema-evolutions-at-gilt-groupe PGDay NYC 2013 presentation]<br />
* [https://github.com/perseas/Pyrseas Pyrseas] <br />
* [https://dbsteward.io/ DBSteward]<br />
* [https://github.com/yandex/pgmigrate PGmigrate]<br />
* [https://djrobstep.com/docs/migra migra: like diff but for PostgreSQL schemas] by djrobstep<br />
* [https://www.postgrescompare.com/ PostgresCompare]<br />
* [https://github.com/eulerto/pgquarrel pgquarrel]<br />
* [https://github.com/bikeshedder/tusker Tusker] by Michael P. Jung<br />
* [https://github.com/michelp/metagration metagration] by [https://github.com/michelp/metagration Michel Pelletier]<br />
<br />
== Functions deployment ==<br />
* [https://github.com/trustly/fdiff fdiff] by Joel Jacobson [http://joelonsql.com/2013/04/24/secure-deployment-of-postgresql-functions/ blog post]<br />
* [http://tech.valgog.com/2012/01/schema-based-versioning-and-deployment.html Schema-based API versioning] by Valentine Gogichashvili<br />
<br />
== Presentations ==<br />
* [https://docs.google.com/presentation/d/1TV0bExFwVy-_d6C7A8Z2JL9Z9tvtkuZv3D58fkC3GWQ/edit?usp=sharing ALTER DATABASE ADD SANITY] by Alexey Klyukin<br />
* [https://djrobstep.com/talks/your-migrations-are-bad-and-you-should-feel-bad Your database migrations are bad and you should feel bad] by djrobstep</div>
Michelp
https://wiki.postgresql.org/index.php?title=OSCON_2019_signup&diff=33586
OSCON 2019 signup
2019-06-25T16:53:13Z
<p>Michelp: /* 1:45pm - 3:05pm */</p>
<hr />
<div>* Time slots are intended to make sure the booth is covered during major breaks around the sessions.<br />
<br />
== Booth Setup Tues July 16 (08:00am - 5:00pm) ==<br />
<br />
* Mark Wong (markwkm@postgresql.org)<br />
<br />
== Wed July 17 (8:00am - 7pm) - Sponsor Reception is 5:45pm-7pm ==<br />
<br />
=== 8:00am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
=== 1:45pm - 3:05pm ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
=== 3:05pm - 5:45pm ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
=== 5:45pm - 7pm '''RECEPTION''' ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
== Thurs July 18 (8am - 3pm) ==<br />
<br />
=== 8am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmai.com)<br />
<br />
=== 1:45pm - 3:00pm ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmai.com)<br />
<br />
----<br />
<br />
Thanks for participating!<br />
<br />
[[Category:PostgreSQL Events]]</div>
Michelp
https://wiki.postgresql.org/index.php?title=OSCON_2019_signup&diff=33585
OSCON 2019 signup
2019-06-25T16:52:27Z
<p>Michelp: /* 1:45pm - 3:00pm */</p>
<hr />
<div>* Time slots are intended to make sure the booth is covered during major breaks around the sessions.<br />
<br />
== Booth Setup Tues July 16 (08:00am - 5:00pm) ==<br />
<br />
* Mark Wong (markwkm@postgresql.org)<br />
<br />
== Wed July 17 (8:00am - 7pm) - Sponsor Reception is 5:45pm-7pm ==<br />
<br />
=== 8:00am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
=== 1:45pm - 3:05pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 3:05pm - 5:45pm ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
=== 5:45pm - 7pm '''RECEPTION''' ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
== Thurs July 18 (8am - 3pm) ==<br />
<br />
=== 8am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmai.com)<br />
<br />
=== 1:45pm - 3:00pm ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmai.com)<br />
<br />
----<br />
<br />
Thanks for participating!<br />
<br />
[[Category:PostgreSQL Events]]</div>
Michelp
https://wiki.postgresql.org/index.php?title=OSCON_2019_signup&diff=33584
OSCON 2019 signup
2019-06-25T16:52:15Z
<p>Michelp: /* 12:30pm - 1:45pm LUNCH */</p>
<hr />
<div>* Time slots are intended to make sure the booth is covered during major breaks around the sessions.<br />
<br />
== Booth Setup Tues July 16 (08:00am - 5:00pm) ==<br />
<br />
* Mark Wong (markwkm@postgresql.org)<br />
<br />
== Wed July 17 (8:00am - 7pm) - Sponsor Reception is 5:45pm-7pm ==<br />
<br />
=== 8:00am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
=== 1:45pm - 3:05pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 3:05pm - 5:45pm ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
=== 5:45pm - 7pm '''RECEPTION''' ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
== Thurs July 18 (8am - 3pm) ==<br />
<br />
=== 8am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmai.com)<br />
<br />
=== 1:45pm - 3:00pm ===<br />
<br />
* Your name and email here<br />
<br />
<br />
----<br />
<br />
Thanks for participating!<br />
<br />
[[Category:PostgreSQL Events]]</div>
Michelp
https://wiki.postgresql.org/index.php?title=OSCON_2019_signup&diff=33583
OSCON 2019 signup
2019-06-25T16:51:10Z
<p>Michelp: /* 3:05pm - 5:45pm */</p>
<hr />
<div>* Time slots are intended to make sure the booth is covered during major breaks around the sessions.<br />
<br />
== Booth Setup Tues July 16 (08:00am - 5:00pm) ==<br />
<br />
* Mark Wong (markwkm@postgresql.org)<br />
<br />
== Wed July 17 (8:00am - 7pm) - Sponsor Reception is 5:45pm-7pm ==<br />
<br />
=== 8:00am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
=== 1:45pm - 3:05pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 3:05pm - 5:45pm ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
=== 5:45pm - 7pm '''RECEPTION''' ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
== Thurs July 18 (8am - 3pm) ==<br />
<br />
=== 8am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
=== 1:45pm - 3:00pm ===<br />
<br />
* Your name and email here<br />
<br />
<br />
----<br />
<br />
Thanks for participating!<br />
<br />
[[Category:PostgreSQL Events]]</div>
Michelp
https://wiki.postgresql.org/index.php?title=OSCON_2019_signup&diff=33582
OSCON 2019 signup
2019-06-25T16:50:50Z
<p>Michelp: /* 5:45pm - 7pm RECEPTION */</p>
<hr />
<div>* Time slots are intended to make sure the booth is covered during major breaks around the sessions.<br />
<br />
== Booth Setup Tues July 16 (08:00am - 5:00pm) ==<br />
<br />
* Mark Wong (markwkm@postgresql.org)<br />
<br />
== Wed July 17 (8:00am - 7pm) - Sponsor Reception is 5:45pm-7pm ==<br />
<br />
=== 8:00am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
=== 1:45pm - 3:05pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 3:05pm - 5:45pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 5:45pm - 7pm '''RECEPTION''' ===<br />
<br />
* Your name and email here<br />
<br />
Michel Pelletier (pelletier.michel@gmail.com)<br />
<br />
== Thurs July 18 (8am - 3pm) ==<br />
<br />
=== 8am - 10:10am ===<br />
<br />
* Your name and email here<br />
<br />
=== 10:10am - 12:30pm ===<br />
<br />
* Your name and email here<br />
<br />
=== 12:30pm - 1:45pm '''LUNCH''' ===<br />
<br />
* Your name and email here<br />
<br />
=== 1:45pm - 3:00pm ===<br />
<br />
* Your name and email here<br />
<br />
<br />
----<br />
<br />
Thanks for participating!<br />
<br />
[[Category:PostgreSQL Events]]</div>
Michelp