shayonj

10 ms·

181.
by shayonj 2y ago
Any post from brandur is a must read. Love the post
182.
by shayonj 2y ago
Does anyone with more context know how are they rearranging the memory bits mentioned in the article. Are they patching this using malloc/realloc or is it something entirely different?
183.
The Value of Sitting on an Idea(shayon.dev)
5 points by shayonj 3y ago|0 comments
184.
Incidents and the Requirement of Slowing Down(shayon.dev)
1 points by shayonj 3y ago|0 comments
185.
by shayonj 3y ago
this is very interesting, thank you for sharing!
186.
100x Faster Query in Aurora Postgres with a lower random_page_cost(shayon.dev)
4 points by shayonj 3y ago|1 comments
187.
by shayonj 3y ago
+1 for Route53 Groups and B/G setups. We did something similar with PG upgrades, no downtime with AWS R53 groups & retry inflight queries with a custom Rails ActiveRecord transaction patch. Trade off: For a few seconds some request
188.
Ask HN: What are some good CI platforms to train and tune AI models?
1 points by shayonj 3y ago|0 comments
189.
Shipping Fast Requires a High Degree of Trust(shayon.dev)
3 points by shayonj 3y ago|0 comments
190.
pg_easy_replicate 2.0 zero downtime upgrades with support for recreating indices(shayon.dev)
4 points by shayonj 3y ago|0 comments
191.
by shayonj 3y ago
Hi! The author here. I appreciate your reply here and in few other threads for this post too. I think they are very well thought out. I also like how it brewed more branches of other good discussions. I totally agree that this decision isn&
192.
by shayonj 3y ago
Very interesting! Thanks for sharing
193.
by shayonj 3y ago
Thank you :)
194.
by shayonj 3y ago
Great call!
195.
by shayonj 3y ago
ah! thats a blast from the past. I maintain pg-osc (online schema change tool for postgres) and very much agree that FKs make OSC hard.
196.
by shayonj 3y ago
That is great and I noticed it’s something I have always assumed should be the case - no indirect access to the database outside your application / ORM. Because then you open a can of worms.
197.
by shayonj 3y ago
I agree and makes sense. Starting out with them and then challenging the setup is a good practice. I like the idea of moving to a lighter data integrity setup too (ofc when possible)
198.
Do you really need foreign keys?(shayon.dev)
117 points by shayonj 3y ago|176 comments
199.
by shayonj 3y ago
This is great! I wrote a tool that automates most of the things you came across. If you find it useful or would like to extend it with your feedback/ideas, I'd love to have them! Thanks for sharing https://github.com&#x
200.
Turn any Git directory into a SQLite DB and make your own Spotify Wrapped(twitter.com)
5 points by shayonj 3y ago|0 comments
201.
by shayonj 3y ago
Tried something similar here: https://github.com/shayonj/branch_base Lmk what you think :)
202.
Show HN: Git Wrapped (like Spotify) for any git directory using SQLite(github.com)
7 points by shayonj 3y ago|0 comments
203.
New Chrome extension to easily sanitize personal information from HAR files(chrome.google.com)
4 points by shayonj 3y ago|0 comments
204.
Show HN: SanitizHAR: A simple Chrome extension to sanitize HAR file contents(github.com)
7 points by shayonj 3y ago|0 comments
205.
by shayonj 3y ago
Yep it does. We have used with AWS Aurora. You will need to update the parameter group settings to ensure logical replication is enabled.
206.
by shayonj 3y ago
Thats right! Its mostly a CLI orchestration tool (mentioned in the readme), with some logging, stats and safety checks so that user/engineer can be mostly hands off during the process. Perhaps, even automate the entire process by wirin
207.
by shayonj 3y ago
Cool idea!
208.
by shayonj 3y ago
These are great shouts! Thank you so much for sharing. One of the operations I ran with this was ~500GB and yeah it takes a few hours to catchup. For us, it wasn't an issue, especially also since we were on AWS Aurora. However, that sa
209.
by shayonj 3y ago
Great question: so you can watch the stats command. The command returns a JSON every second which has a switchover_completed_at field. It is updated the as soon as the switchover is complete. UPDATE: Some more reading material here: https:
210.
by shayonj 3y ago
That’s a great question: internally what we have done is when preparing the new empty database, we also run a “bundle exec rake db:schema:load” against it. Depending on your setup, it can be hard to do. I am exploring some options like load

More ›