Readit Newswoyten commented on Ask HN: Any good tools to pgdump multi tenant database? · Posted by u/polishdude20
Thanks for the suggestions!
Yeah due to the unavailability of FK's, I'd have to somehow map certain ID columns to the tables they're for, accounting for slight naming convention differences.
In case you don’t have FKs you could specify virtual foreign keys in Greenmask.
Check out docs for details
https://docs.greenmask.io/latest/database_subset/#virtual-re...
woyten commented on Show HN: Greenmask 0.2 – Database anonymization tool github.com/GreenmaskIO/gr... · Posted by u/woyten
Free feedback for you, nothing personal...
Within 48 hours of needing to do some masking (exporting data from a database to CSV to import it to a less trusted domain's database for testing/benchmarking), I ran across your HN post and tool.
A pair of us had started with a different masking approach I knew was dumb but would work, but I mentioned Greenmask to the guy working with me doing masking as something to perhaps look at to see if it'd help us later/next-time.
He apparently took me up on it more aggressively than I anticipated and today he indicated he had looked at it and found it hard to understand how to use it (documentation-wise). I.e. he tried it but didn't really get anywhere.
I'm not sure precisely what he meant but my perception from whatever he said (I wasn't trying to gather feedback for you at the time) was he didn't have/see any example code showing the different things he could do.
Having skimmed your documentation for 3 minutes just now, I am inclined to agree. Additionally I would observe that your Show HN bullet explanation of your product is actually clearer/tighter than your official documentation page, where my impatient eye tends to glaze over after a few bullets of stuff I am not sure if I care about...
May I ask how often and in what situations you deal with data import tasks like these? This would help me better understand the issue and make the product more user-friendly. I would appreciate your input.
The interesting part is that it’s not just about adding another database driver. I’m revisiting a big part of the codebase and introducing a framework that should make implementing support for new DBMSs much simpler. The goal is to make Greenmask more extensible so that the community can add support for other databases without needing to dig through the entire internal architecture.
Published the first beta of this new approach a few months ago, and now the focus is on stabilizing it and making it production-ready.
MySQL support discussion: https://github.com/GreenmaskIO/greenmask/issues/222
Beta release: https://github.com/GreenmaskIO/greenmask/releases/tag/v1.0.0...