gh-ost
duckduckgo-locales
gh-ost | duckduckgo-locales | |
---|---|---|
32 | 2,078 | |
11,997 | 94 | |
1.0% | - | |
7.4 | 0.0 | |
16 days ago | 9 days ago | |
Go | Perl | |
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.
gh-ost
- "At GitHub we do not use foreign keys, ever, anywhere"
-
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:
-
We migrated to SQL. Our biggest learning? Don't use Prisma
Sounds like it's basically explained in the gh-ost readme https://github.com/github/gh-ost#how
I think it amounts to "use views to decouple access to the table with a fixed interface" and "use triggers for migrating data between tables"
-
Ask HN: Is PostgreSQL better than MySQL?
Gh-ost is the new hotness. Simple to use and lots of great features: https://github.com/github/gh-ost
-
My Green/blue AWS db deployment strategy for avoiding data loss due to table locks
If the performance of the db is a concern during migrations (locking, high cpu consumption for large writes) there are tools that can help and do similiar to what your describing but with the benefit that they are battle tested tools. This one spring to mind https://github.com/github/gh-ost there are other options as well and its worth reading the trade off docs
-
Changing column from longtext to mediumtext taking over 2 hours
Not sure which version of MySQL you're using, but one approach would be to use a tool like pt-online-schema-change (from Percona) or g-host -- which will create a duplicate table and then swap it in place of the original table. It's a safer approach when operating in production environments. Here's a good comparison of the tools many people use https://planetscale.com/docs/learn/online-schema-change-tools-comparison
-
Ask HN: Do you use foreign Keys in Relational Databases
No, especially on large tables with billions of records. They make online schema changes impossible. More details: https://github.com/github/gh-ost/issues/331#issuecomment-266...
-
Migrating a production database without any downtime
Tip #4: Consider slow-running migrations. Some tables can be so large that the traditional migration way is simply not a viable option for them. In such cases, you can consider embedding the data migration code right into your application, or use a special utility like GitHub's online schema migration for MySQL. A slow-running migration can work in production for days or even weeks. It gradually converts the data by small chunks, so you can carefully balance the load on the database while making sure that it doesn't cause slowness or downtime.
-
How do you handle RDS schema migrations?
GitHub gh-ost
-
Changing Tires at 100mph: A Guide to Zero Downtime Migrations
Actually I never tried but I was scared by the small print of GH not using RDS themselves [1] and Ghost relying on lower-level features that might be not easily available in RDS. Also I had the impression you have to setup a normal non-RDS replica attached to your RDS master?
[1] https://github.com/github/gh-ost/blob/master/doc/rds.md
duckduckgo-locales
-
Alice's Adventures in a Differentiable Wonderland
No, I think the inspiration is more direct https://duckduckgo.com/?q=lewis+carroll+alice+in+wonderland+...
-
Biden signs TikTok 'ban' bill into law, starting clock for ByteDance to divest
Yea caught me, I self reported to try and trick everyone. Jokes aside my comment was based on net neutrality if you don’t remember https://duckduckgo.com/?q=net+neitrality+bot+comments
Some of the stuff that really chipped at our privacy as our isps got to sell our dns pings to advertisers and social media. Have a good day citizen.
- A24's New AI-Generated 'Civil War' Ads Generate Controversy
-
DuckDuckGo AI Chat
AI Chat is separate from the search engine. On the search engine we have DuckAssist, which is currently grounded in Wikipedia (more sources coming): https://duckduckgo.com/?q=what+is+the+stoichiometric+ratio+b...
- Collection of notebooks showcasing some fun and effective ways of using Claude
-
Microsoft killed my favorite keyboard
that one is good, but I detest keyboards with their own magic little dongle since it's a damn fine thing to misplace
I'm surprised OP didn't enjoy https://www.microsoft.com/en-us/d/surface-ergonomic-keyboard... which is currently listed as out of stock but I dunno if that means "permanently" or what, but they seem to be available via 3rd party channels
Its "klacking" aside, pour one out for https://duckduckgo.com/?q=microsoft+natural+elite+keyboard&t... which I loved, although I'll be straight that I love the Surface Ergonomic better because I think its keytravel is much, much nicer and no weirdo + shaped cursor keys, the inverted T like $diety intended
-
Ask HN: Where are all the touch-based art forms?
Sculpture can be tactile. I know it's not purely tactile, but thinking of it in that way is becoming a lot more common (eg at the Louvre). And then I went to find a URL for the tactile dome at the Exploratorium in San Francisco (https://www.exploratorium.edu/visit/tactile-dome) and it turns out there are lots of tactile galleries now:
https://duckduckgo.com/?q=tactile+gallery&t=fpas&ia=web
- Show HN: QR Builder
- Find My Device on Android
-
Insurers Are Spying on Your Home from the Sky
https://duckduckgo.com/?q=ontario+minimum+automobile+insuran...
https://www.ontario.ca/document/official-mto-drivers-handboo...
https://www.ibc.ca/insurance-basics/auto/types-of-auto-cover...
For the US:
https://www.forbes.com/advisor/car-insurance/minimum-require...
What are some alternatives?
pg-online-schema-change - Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL [Moved to: https://github.com/shayonj/pg-osc]
Searx - Privacy-respecting metasearch engine
doctrine-test-bundle - Symfony bundle to isolate your app's doctrine database tests and improve the test performance
hn-search - Hacker News Search
squawk - 🐘 linter for PostgreSQL, focused on migrations
brave-browser - Brave browser for Android, iOS, Linux, macOS, Windows.
pg_squeeze - A PostgreSQL extension for automatic bloat cleanup
Tutanota makes encryption easy - Tuta is an email service with a strong focus on security and privacy that lets you encrypt emails, contacts and calendar entries on all your devices.
hub - A command-line tool that makes git easier to use with GitHub.
SimpleLogin - The SimpleLogin back-end and web app
Jenkins - Jenkins automation server
torsocks - Library to torify application - NOTE: upstream has been moved to https://gitweb.torproject.org/torsocks.git