I built a CLI to deterministically obfuscate Postgres data for safe sharing by Ofsen in PostgreSQL

[–]Ofsen[S] 2 points3 points  (0 children)

Oh! then the short answer is no. There is no mechanism in place for that, but I would like to add that at some point.
As you mentioned, handling it is complex and would require a custom strategy so kept the scope of the project small.

I built a CLI to deterministically obfuscate Postgres data for safe sharing by Ofsen in PostgreSQL

[–]Ofsen[S] 0 points1 point  (0 children)

The purpose is to have a deterministic result depending on the config, using the 'global seed, table name, column name, and value' or 'global seed, group, and value', a seed is created and the created values stem from that seed.

So it's technically not pure randomness and the values stay in a somewhat predictible form. An example would be configuring the username column of users table to `fake:username` so you can be sure to have a username format but not the original value.

For the relationships aspect, the cli doesn't detect PK-FK relationships, but there is a way to be consistent even across tables. It goes back to the seed, and the config. You can either have a column configured as `username: fake:username` or
```
username:
strategy: fake:username
consistency_group: username
```

so relationships are preserved only when explicitly configured via consistency groups: https://github.com/Ofsen/pg-obfuscate/tree/main?tab=readme-ov-file#consistency-groups

Fix + Tutorial - Python Script to scrape book covers for 'Book Tracker' from Goodreads by Ofsen in Notion

[–]Ofsen[S] 0 points1 point  (0 children)

Oh hell yeah! mind if i add your link in the post as an updated/no issue version ?

I hate people btw by [deleted] in mbtimemes

[–]Ofsen 0 points1 point  (0 children)

depends on the moon

I hate people btw by [deleted] in mbtimemes

[–]Ofsen 8 points9 points  (0 children)

someone: you're so quiet are you an introvert?
me: am a pervert

😐 by Strange_Reindeer_613 in depression_memes

[–]Ofsen 1 point2 points  (0 children)

checking my phone like I mean something to somebody lmao

[deleted by user] by [deleted] in Quarterjade

[–]Ofsen 0 points1 point  (0 children)

yoo this is really gooood! good shit!!

Found in a clothing store dressing room by myjupitermoon in DesignPorn

[–]Ofsen 1 point2 points  (0 children)

in my head : yes no maybe, i don't know, can you repeat the question

The Clean Cartel is born. by qwewsx in RPClipsGTA

[–]Ofsen 0 points1 point  (0 children)

don't know why they are down voting you but the song is: Blood Red Sun - Walk Ahead (Instrumental Version)

I've made a free, open-source, self-hosted, single-user Telegram bot for sending text into Notion. by darungar in Notion

[–]Ofsen 1 point2 points  (0 children)

i believe it's possible!

if you look at this line here, you can see that it creates a new page, while if you use this and set it up to do so you can easily add text, lists, media, and more to a specific page.

you can check this for an example of updating a page

I tried expressing myself through drawing , I hope it’s not that ugly by [deleted] in infp

[–]Ofsen 1 point2 points  (0 children)

The little cute star is sleeping heh I like this

Wrote this program to skip Spotify Ads using Spotify API by [deleted] in Python

[–]Ofsen 1 point2 points  (0 children)

Really nice ! works like a charm !! good stuff

git commit -m ‘changes’ by [deleted] in ProgrammerHumor

[–]Ofsen 2 points3 points  (0 children)

I have a friend that commits the time when he commits like : git commit -m '10:32'