RE: Re: Logging the feature of SQL-level read/write commits

2019-05-05 Thread legrand legrand
Hi, good point ! wal2Json seems to correspond to your needs, this is first designed for Change Data Capture, taht could generate a (very) big size of logs. You didn't tell us much about your use case ... and maybe, if the number of data modifications is not too big, and the number of tables to

RE: Re: Logging the feature of SQL-level read/write commits

2019-05-05 Thread Ronny Ko
Hi Legrand & Bruce, Thanks for your  thoughts. I think MariaDB's temporal queries could work.  If I want to use it in PostgreSQL, I could use Logical Decoding plugins for recording all INSERT/UPDATE/DELETE history of each table: - https://debezium.io/docs/install/postgres-plugins/ - wal2json