shayonj

15 ms·

211.
by shayonj 3y ago
Thanks for giving it a try. Please don't hesitate to open bugs/feature requests.
212.
by shayonj 3y ago
Love pglogical. I was thinking, it'd be nice to orchestrate this setup using pglogical too. Would attempt it if there is interest. Especially with bi-directional replication setup.
213.
by shayonj 3y ago
I will update the readme to mention this - but the lib takes care of updating sequence with the data catchup: https://github.com/shayonj/pg_easy_replicate/blob/13ad6af51f...
214.
by shayonj 3y ago
Thanks for taking a look! Thats right, it was a typo. Mean't zero data loss and minimal downtime. There are some strategies in the readme like using weighted based DNS failover to reduce the downtime even less without requiring applica
215.
Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate(github.com)
306 points by shayonj 3y ago|62 comments
216.
Rails Postgres ActiveRecord patches for common production workloads(github.com)
4 points by shayonj 4y ago|0 comments
217.
Building a simple dynamic job scheduler with Sidekiq(tines.com)
13 points by shayonj 4y ago|0 comments
218.
by shayonj 5y ago
Very interesting. Just so I understand - are you asking how does pg-osc updates the references in view(s) when pg-osc performs an ALTER on a table that is being referred in these view(s)? If so, it actually doesn't handle that currentl
219.
by shayonj 5y ago
Except for few cases, it doesn't. This thread above on MySQL and online DDL is ncie. https://news.ycombinator.com/item?id=30581314 pg-osc doc says that since the alter statements can vary in nature, it supports if a re
220.
by shayonj 5y ago
Thanks for the suggestion, I will def take that into consideration. With SERIALIZABLE currently the transaction and lock with it is harmless, but perhaps the design will change at some point in future.
221.
by shayonj 5y ago
Yeah, I have been mostly erring on the side of caution since the use cases can vary a lot. Transactional DDLs are a big savior for sure. Were there specific features that seemed redundant? I am always looking to iterate on this. - Author of
222.
by shayonj 5y ago
Hello! Author of the post here - Yeah I agree, it's certainly a bit wasteful, especially during the operation. You can clean up the table automatically in the end with --drop. Love the concept and path with Reshape btw, I think its ver
223.
by shayonj 5y ago
Author of the post here - Thank you and appreciate the submission.
224.
by shayonj 5y ago
This is very cool! I no longer work on Rails on daily basis, but would have loved to have this. I built something similar called `pg-osc` / `pg-online-schema-change` for PostgreSQL workloads. It does zero downtime migrations using trig
225.
Show HN: Pg-osc: Zero downtime schema changes in PostgreSQL(github.com)
9 points by shayonj 5y ago|0 comments
226.
by shayonj 5y ago
Thank you! I appreciate it. Yeah, didn't get much attention, I was curious to get feedback/thoughts from the HN community. Perhaps, I will re-share later after few more changes are live.
227.
by shayonj 5y ago
Thank you! I totally messed up the social rollout with edits in content and title. I've set up the aliases now.
228.
Show HN: pg-online-schema-change – Zero downtime schema changes in PostgreSQL(shayon.dev)
8 points by shayonj 5y ago|0 comments
229.
pg-osc: Zero downtime schema changes in Postgres(shayon.dev)
7 points by shayonj 5y ago|4 comments
230.
by shayonj 5y ago
thats a good call out - i suppose infra eng can mean different things. This was a bit more operationally focused i agree. I was thinking of talking about HA and replication, but also wanted something relatively short, perhaps another post :
231.
by shayonj 5y ago
I like that analogy :)
232.
by shayonj 5y ago
Love transactional DDL! Have only used on side projects for now.
233.
by shayonj 5y ago
I have definitely seen that as well. I have yet to play with postgis specifically, i have read many good things. Thinking of un-archiving some old side projects and experimenting with postgis!
234.
Why I Enjoy PostgreSQL – Infrastructure Engineer's Perspective(shayon.dev)
194 points by shayonj 5y ago|59 comments
235.
by shayonj 5y ago
This is very interesting, thanks for sharing. I had been noodling on the concept of zero downtime schema changes in postgres as well, and recently started https://github.com/shayonj/pg-online-schema-change . Its inspire
236.
by shayonj 6y ago
Loom | Senior Infrastructure Engineer | San Francisco, CA | REMOTE, VISA | FULLTIME Loom is on a mission to empower everyone at work to communicate more effectively, wherever they are. We are already trusted by over 9M users across 120k+ co
237.
Show HN: Ruby gem to get any emergency numbers for any country in the world(rubygems.org)
1 points by shayonj 10y ago|0 comments
238.
by shayonj 12y ago
Built this over the weekend, with one objective in mind - learn by doing. Would love to hear any feedback/comments/bug reports :).
239.
Show HN: Chrome extension to automatically copy and/or search the selected text(chrome.google.com)
9 points by shayonj 12y ago|1 comments
240.
by shayonj 13y ago
We are in the process of launching a service that would utilize a marketplace feature and currently looking into options available. I am wondering how is Stripe Marketplace different compared to Balanced marketplace with the escrow feature.

More ›