3 ms·
Disclaimer: I work at Neon Neon makes this very ergonomic in a cloud setting (actually it works somewhat similarly to how the article does it). You can create
by sakras 2y ago
Disclaimer: I work at Neon
Neon makes this very ergonomic in a cloud setting (actually it works somewhat similarly to how the article does it). You can create a copy-on-write version of your prod database (a branch) and use it for testing. There's also some automation we've built up for doing it from GitHub CI: https://neon.tech/docs/guides/neon-github-app https://neon.tech/docs/guides/neon-github-app
- horse666 2y agoI’d not heard of Neon, it looks interesting. When you say “a copy-on-write version of your prod database”, from reading the docs, this includes both schema and data? I couldn’t find anything on data anonymisation/obfuscation - how do you handle that?
- sakras 2y agoYep - it's an exact copy at the page level, so _everything_ is copied. Regarding data anonymization, you can use the pg_anon extension on your branch. There's a blog post about it: https://neon.tech/blog/easily-anonymize-production-data-in-postgres https://neon.tech/blog/easily-anonymize-production-data-in-p...
- Scramblejams 2y agoLink is currently 404.
- horse666 2y agoUntil Neon can fix that, I found it on the Wayback Machine - https://web.archive.org/web/20240524181543/https://neon.tech/blog/easily-anonymize-production-data-in-postgres https://web.archive.org/web/20240524181543/https://neon.tech...
- ajc23 2y agoyou can use Neon + Neosync on your branches: https://neon.tech/docs/introduction https://neon.tech/docs/introduction