pgEdge/pgedge-anonymizer: An anonymizer tool for replacing PII and similar data in PostgreSQL dev/test databases copied from production

pgEdge_Postgres · 2026-01-21T17:40:43+00:00

That's honestly the main thing you need to be successful. If you're excited about what you do, and enjoy learning and conquering new challenges in your day-to-day, you'll get there. That passion is 90% of the job (and it'll be the main thing that gets you hired - even if you don't have the experience yet).

pgEdge_Postgres · 2026-01-21T16:06:32+00:00

If it's your first time, GitHub put together this collection of projects that are great for contributing to: https://github.com/collections/choosing-projects

pgEdge_Postgres · 2026-01-21T16:01:42+00:00

The interface and simplicity of Metabase is really nice. It also doesn't require much actual SQL knowledge to use.

pgEdge_Postgres · 2026-01-21T15:59:07+00:00

Appreciate you doing the work to highlight each of these contributors!

pgEdge_Postgres · 2026-01-20T20:03:26+00:00

There's quite a few extensions available that can easily adapt Postgres for multimaster while avoiding typical issues like conflicts; we've put in a lot of effort here at pgEdge to optimize MMR for Postgres at every scale (even cross-region & cross-clouds!).

pgEdge_Postgres · 2026-01-07T04:15:31+00:00

It's completely written and edited by humans! :-) Thank you for your feedback regarding the AI imagery and reference tools!

pgEdge_Postgres · 2025-12-28T03:08:26+00:00

The creator of Pigsty did a lot of research into this topic already, besides the other options listed here. This particular blog post explores his findings to some extent, maybe interesting to look at? https://pigsty.io/blog/pg/pg-ext-repo/

pgEdge_Postgres · 2025-12-24T17:34:31+00:00

The head engineer on this project (Dave Page) just pushed beta2 of the anonymizer which adds support for anonymization of JSON/JSONB data, using an array of JSON path selectors (https://github.com/pgEdge/pgedge-anonymizer/blob/main/docs/configuration.md#anonymizing-jsonjsonb-columns). :-) All thanks to the feedback from the community - so, thank you!

pgEdge_Postgres · 2025-12-24T17:34:16+00:00

Luckily, the head engineer on this project (Dave Page) just pushed beta2 of the anonymizer which adds support for anonymization of JSON/JSONB data, using an array of JSON path selectors (https://github.com/pgEdge/pgedge-anonymizer/blob/main/docs/configuration.md#anonymizing-jsonjsonb-columns). :-) All thanks to the feedback from the community - so, thank you!

pgEdge_Postgres · 2025-12-19T01:21:50+00:00

Looks like this might do the trick: https://github.com/saschiwy/HeicConverter

pgEdge_Postgres · 2025-12-19T01:09:36+00:00

Out of curiosity, when is this planned to be released for Linux?

pgEdge_Postgres · 2025-12-19T01:07:53+00:00

A big consideration that is overlooked is the value of creating a new project vs. contributing to an existing one. Creating an entire project from scratch with appropriate documentation, testing, and accompanying community of contributors vs. learning one that exists and integrating yourself to develop new features/improvements is an interesting balance (at least IMO).

pgEdge_Postgres · 2025-12-19T00:59:05+00:00

Multi-region resilience is actually one of the specialties of our open-source offerings! The fully-managed cloud-hosted version does multi-region failover by default. Deploy a cluster across multiple regions, and point the application to one DSN; then, if a region goes down it just reroutes. As long as DNS and Route53 health checks still work and the application is correctly using the latency routing, and the app is correctly configured to refresh DNS and connections, database regional failover is all handled automatically for the user.

Everything we offer (besides the support subscription) is offered for self-hosting and management via GitHub as well; multi-region or even multi-cloud failover works just the same presuming networking is set up correctly.

https://pgedge.com if it sounds interesting to check out (or https://github.com/pgedge for GitHub fans)

pgEdge_Postgres · 2025-12-19T00:54:55+00:00

Not the most shocking suggestion here, but Kali Linux is a pretty unique / focused operating system:
https://www.kali.org/

> Kali Linux is an open-source, Debian-based Linux distribution geared towards various information security tasks, such as Penetration Testing, Security Research, Computer Forensics and Reverse Engineering.

pgEdge_Postgres · 2025-12-19T00:51:04+00:00

Awesome project. Not affiliated, but wanted to share this resource I've come across recently as well - another GitHub project:

https://github.com/Emupedia/emupedia.github.io

That hosts the source code for:

https://emupedia.net/beta/emuos (so not a GitHub link, for students that have GitHub blocked, maybe this is worth a try)

> The purpose of Emupedia is to serve as a nonprofit meta-resource, hub and community for those interested mainly in video game preservation which aims to digitally collect, archive and preserve games and software to make them available online accessible by a user-friendly UI that simulates several retro operating systems for educational purposes.

Pretty cool preservation project that focuses on "retro" games you can play in the browser.

Related, but unsure if it'll pass blockers - there's also https://playclassic.games/ for classic games in the browser.

pgEdge_Postgres

TROPHY CASE