Profile avatar
shayonj.bsky.social
Everything, everywhere - always in progress 🏃‍♂️👨🏽‍🍳💻
21 posts 493 followers 229 following
Regular Contributor

"While these tools boost productivity, they’re not a replacement for critical thinking. Taking the time to understand why something works (or breaks) and building strong mental models isn’t just busy work..." www.shayon.dev/post/2025/53...

Some more ramblings from working on PostgreSQL (Had its brief moment on HN) www.shayon.dev/post/2025/40...

Counting is a hard problem.

Planning a wedding with your parents is a group project that no one prepared you for.

Post run, half baked thought: In memory store, flush to S3 every N interval. Reader replicas straight from S3 (?) New S3 primitives (conditional writes, and append only) for strong consistency and other good semantics. Costs ? Unknown 💸

Rollercoaster of emotions next few days.

Very heartwarming to see other companies finding pg_easy_replicate (born out of @TinesEng) useful for large scale PostgreSQL migrations 🫶🏽 github.com/shayonj/pg_e...

Just realized with pg_flo you can use the same DB as both source & destination. This lets you create shadow tables & remap data flows within a single DB using the routing feature. Useful for data migrations when you need time to verify data integrity! www.pgflo.io

Happy to see pg_flo in top 5 on Hacker News today. Looks like all positive feedback. Excited to continue hacking on it.

Wrote a few words about using #PostgreSQL page location (CTID) for large data cleanups as a workaround www.shayon.dev/post/2024/30...

Just shipped the v1 of new table routing feature in pg_flo. This way you can easily route PostgreSQL changes to different tables & column names in the target database. Lots more soon. In the mean time, a small and simple site: www.pgflo.io

Reminder: SQLite is 35% faster than the filesystem while also using 20% less disk space read more here: www.sqlite.org/faste...

Noodling on a tool to sync (CDC)between Postgres DBs. Define rules to anonymize, filter, or transform data before it reaches the destination. Considering a cloud version as well to keep it zero-touch-ops. Just setup & go. Early days, open to feedback. Design is flexible github.com/shayonj/pg_flo

Not a yolo day, today.

Ok so turns out this is possible! There's a Chrome extension called Sky Follower Bridge that does the matching for you. This worked with zero drama.

Giving this starter pack thing a try, if you want a little Postgres in your feed (and who doesn't) here's some folks work a follow - go.bsky.app/Acp7hmk