Thin PostgreSQL Clones

Re:Thin PostgreSQL Clones by akartasov on Tuesday January 25, 2022 @05:32AM (#30070293)

I think it will work well for verifying DB changes and optimizing SQL on real data. This seems like a great tool to eliminate the risk of database-related downtime.

[ Parent | on HN ]

Re:Thin PostgreSQL Clones by nicoburns on Tuesday January 25, 2022 @05:38AM (#30070337)

It is, but it introduces new risks. Like your test code emailing all of your production users. And more generally data security issues.

[ Parent | on HN ]

Re:Thin PostgreSQL Clones by akartasov on Tuesday January 25, 2022 @05:57AM (#30070455)

You are absolutely right. Depending on the current environment, you should think about the protection of sensitive data (for example, data masking and obfuscation, access control).

Database Lab Engine provides some possible solutions to protect sensitive data: https://postgres.ai/docs/database-lab/masking

By the way, the Database Lab Engine maintainer is here.

[ Parent | on HN ]