copycat
OnlineSchemaChange
Our great sponsors
copycat | OnlineSchemaChange | |
---|---|---|
13 | 3 | |
316 | 954 | |
4.8% | 1.0% | |
8.8 | 8.1 | |
2 months ago | 14 days ago | |
TypeScript | Python | |
MIT License | GNU General Public License v3.0 or later |
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.
OnlineSchemaChange
-
How Modern SQL Databases Are Changing Web Development - #3 Better Developer Experience
I’ve been through multiple incidents where everything worked fine in the testing environment but ended up locking the production database for minutes when deployed. A category of open-source tools called OSC (Online Schema Change) exists to mitigate such pain, like gh-ost used by GitHub and OSC used by Meta. They work by creating a set of "ghost tables" to apply the migrations, copy over old data from the original tables, and catch up with new writes simultaneously. When all old data is migrated, you can trigger a cutover to make the "ghost tables" production. Check the post below for a great introduction and comparison:
-
Postgres schema changes are still a PITA
For larger companies, with more data and high-traffic tables, schema changes may happen less often, but they still need to worry about things like downtime caused by locking. They require long internal guides on performing schema changes correctly (e.g. GitLab, PayPal), custom tools (e.g. Meta, Square), and they often document incidents or near-incidents caused by schema migrations (e.g. GitHub, Doctolib, GoCardless).
- Migrating Facebook to MySQL 8.0
What are some alternatives?
Replibyte - Seed your development database with real data ⚡️
ServiceStack.OrmLite - Fast, Simple, Typed ORM for .NET
faker - Generate massive amounts of fake data in the browser and node.js
reshape - An easy-to-use, zero-downtime schema migration tool for Postgres
falso - All the Fake Data for All Your Real Needs 🙂
helm-charts - neondatabase helm charts
fakey - web-based fake data generator.
postgres-wasm - A PostgresQL server in your browser
Mongo Seeding - 🌱 The ultimate solution for populating your MongoDB database.
ClickHouse - ClickHouse® is a free analytics DBMS for big data
greenmask - PostgreSQL database anonymization tool
webusb - Connecting hardware to the web.