copycat
pgsync
Our great sponsors
copycat | pgsync | |
---|---|---|
13 | 5 | |
316 | 2,967 | |
4.8% | - | |
8.8 | 5.6 | |
2 months ago | 26 days ago | |
TypeScript | Ruby | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
copycat
- Resend – Incident report for February 21st, 2024
-
Greenmask: PostgreSQL Dump and Obfuscation Tool
Check out https://www.snaplet.dev (I'm the founder). We do exactly this.
- Pgtemp: The easiest way to write tests with Postgres in Rust, without Docker
-
Supabase Branching
Testing with product workloads today? If you need to test with production workloads today, check out Snaplet and Postgres.ai. Both are great partners of Supabase.
-
How Modern SQL Databases Are Changing Web Development - #3 Better Developer Experience
It’s worth noting that being able to branch production data for testing easily doesn’t mean you should just do it. It poses a significant risk of leaking sensitive user data. You should consider using tools like Snaplet to transform and anonymize sensitive columns.
- Show HN: Seed your Postgres development database with production-like data
- Show AWS: Snaplet clones a subset of your Postgres RDS instance, whilst anonymizing the data, so that you can restore it into your development environments: Local, staging, and preview.
- Show HN: Seed your Postgres database with production-like data
-
Databricks acquires serverless Postgres vendor bit.io
[disclosure: I'm the founder of Snaplet]
I think there are a lot of different reasons why people may want to use a service like bit.io, but if you want a database with data in it to code against, run tests against, reproduce production related data-bugs, and run e2e tests against then check out https://www.snaplet.dev.
-
Postgres WASM by Snaplet and Supabase
For now, this is very experimental - but it has a lot of potential. If you want to get involved, please reach out to us or the team at [Snaplet(https://www.snaplet.dev/). The work they're doing over at Snaplet is incredible, and we've had a blast collaborating with them.
pgsync
- PgSync: Sync data from one Postgres database to another
-
Greenmask: PostgreSQL Dump and Obfuscation Tool
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.
-
Available options for migrating from Rhel6 PG10 to Rhel8 PG14
Alternatively, something like https://github.com/ankane/pgsync could be used, but I have much less experience with that kind of approach.
-
Data sync options when upgrading from v10.21 to v14.6
pgsync from an EC2 instance that can connect to both target and destination https://github.com/ankane/pgsync
-
Open-sourcing Datanymizer: in-flight template-driven data anonymization
It looks very similar to pgsync. https://github.com/ankane/pgsync
What are some alternatives?
Replibyte - Seed your development database with real data ⚡️
pg_search - pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL’s full text search
faker - Generate massive amounts of fake data in the browser and node.js
rom-sql - SQL support for rom-rb
falso - All the Fake Data for All Your Real Needs 🙂
Mobility - Pluggable Ruby translation framework
helm-charts - neondatabase helm charts
dbsnapper - Easy database snapshots for development and testing
fakey - web-based fake data generator.
Discourse - A platform for community discussion. Free, open, simple.
postgres-wasm - A PostgresQL server in your browser
Backup - Easy full stack backup operations on UNIX-like systems.