<html>
<head>
<style>
p{margin-top:0;margin-bottom:0}
</style>
</head>
<body>
<table class="txc-wrapper" border="0" cellspacing="0" cellpadding="0" width="100%"><tr><td class="txc-wrapper-td"><div class="txc-content-wrapper" style="color:#111;font-family:Apple SD Gothic Neo,Malgun Gothic,'맑은 고딕',sans-serif;font-size:10pt;line-height:1.5;"><p>Hi Legrand & Bruce,</p>
<p><br>Thanks for your thoughts. I think <a href="https://www.slideshare.net/MariaDB/discovering-and-querying-temporal-data" target="_blank" style="">MariaDB's temporal queries</a> could work. <br><br><br></p>
<p><span style="font-family: "vertical-align:baseline;color:rgb(26, 26, 27);letter-spacing:normal;orphans:2;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);text-decoration-style:initial;text-decoration-color:initial;"; font-size: 14px;">If I want to use it in PostgreSQL, I could use Logical Decoding plugins for recording all INSERT/UPDATE/DELETE history of each table:</span><br></p>
<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; padding: 0.25em 0px; border: 0px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 14px; line-height: inherit; font-family: "vertical-align:baseline;color:rgb(26, 26, 27);letter-spacing:normal;orphans:2;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);text-decoration-style:initial;text-decoration-color:initial;";">-<span> </span><a class="s1w8oh2o-27 tTnje" href="https://debezium.io/docs/install/postgres-plugins/" rel="noopener noreferrer" target="_blank" style="margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;color:rgb(0, 121, 211);text-decoration:underline;">https://debezium.io/docs/install/postgres-plugins/</a></p>
<p style="margin:0px;padding:0.25em 0px;border:0px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-weight:400;font-stretch:inherit;font-size:14px;line-height:inherit;font-family:"vertical-align:baseline;color:rgb(26, 26, 27);letter-spacing:normal;orphans:2;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);text-decoration-style:initial;text-decoration-color:initial;">-<span> </span><a class="s1w8oh2o-27 tTnje" href="https://github.com/eulerto/wal2json" rel="noopener noreferrer" target="_blank" style="margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;color:rgb(0, 121, 211);text-decoration:underline;">wal2json</a></p>
<p style="margin:0px;padding:0.25em 0px;border:0px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-weight:400;font-stretch:inherit;font-size:14px;line-height:inherit;font-family:"vertical-align:baseline;color:rgb(26, 26, 27);letter-spacing:normal;orphans:2;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);text-decoration-style:initial;text-decoration-color:initial;"><br></p>
<p style="margin:0px;padding:0.25em 0px 0px;border:0px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-weight:400;font-stretch:inherit;font-size:14px;line-height:inherit;font-family:"vertical-align:baseline;color:rgb(26, 26, 27);letter-spacing:normal;orphans:2;text-align:start;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);text-decoration-style:initial;text-decoration-color:initial;">Do you think PostgreSQL's wal2json already implemented the feature I want?</p>
<p><br></p></div></td></tr></table>
</body>
</html>
<img src="https://confirm.mail.daum.net/confirmapi/v1/users/gogo9th%40hanmail%2Enet/cmails/20190506065641%2EKMCFGFESQ-OwHvOrC0LiaA%40gogo9th%2Ehanmail%2Enet/recipients/pgsql-hackers%40lists%2Epostgresql%2Eorg">