using Piwik for site analytics and have our database on AWS RDS Aurora mysql. For testing, I'm running a local Node/Express server, connected to the Piwik AWS mysql db.

How do I transform the piwik_archive_blob value which we receive as a buffer into a readable JSON object/array?

this is what we have value: <Buffer 78 9c a5 ce 51 0a 83 30 0c 06 e0 bb f4 04 a9 a9 8b 4d ef b0 3b c4 ad 30 41 1c 68 df c4 bb 2f 51 ea 9e 06 63 7b 68 f8 43 93 f0 09 23 af 03 fb b4 b0 0f ... >

We know the value column stores serialized and gzcompressed DataTable objects

We have tried everything from .toString('utf8'), .toString('binary'), JSON.stringify(), to using Gzip and zlib.

The only output we can get is null, x, and [object Object],[object Object],[object Object]....

Any ideas would be appreciated, Thanks.