Greenmask: PostgreSQL Dump and Obfuscation Tool

• greenmask

  1 386 7.7 Go

  PostgreSQL database anonymization tool

  

• pgsync

  5 2,967 5.6 Ruby

  Sync data from one Postgres database to another

I‘m using https://github.com/ankane/pgsync for that, it has a very easy config yaml and you can just define queries that get pulled from the db.

I have a simple one like „base_tables“ that just pulls me all the fixtures into my local db, then entity specific ones that pull an entity with a specific id + all related entries in other tables for debugging but as long as you can query it you can set up everything very easily.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• Polo

  2 765 0.0 Ruby

  Polo travels through your database and creates sample snapshots so you can work with real world data in development.

  

This is a Rails tool I use: https://github.com/IFTTT/polo — it works well.

• copycat

  13 314 8.8 TypeScript

  Generate deterministic fake values: The same input will always generate the same fake-output. (by snaplet)

  

Check out https://www.snaplet.dev (I'm the founder). We do exactly this.

• dbsnapper

  1 7 8.0 HTML

  Easy database snapshots for development and testing

  

I'm about to release v.2.0 of [DBSnapper](https://dbsnapper.com) which includes the subsetting feature. Works with Postgres and MySQL.

I have a prelease build (v2.0.0-alpha) available at https://github.com/dbsnapper/dbsnapper/releases

And I'm updating the documentation for v2.0.0 in real-time https://docs.dbsnapper.com. The new configuration is there, but I have some work to do adding docs for the new features.

Works with Mac and Linux (Windows soon)

If you're interested in giving the alpha a try, I'd love feedback and can walk you through any issues you might encounter.

Joe

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project