Zero Downtime Schema Changes with Vercel and Xata by Divyendu Singh
Discover how Xataβs pgrollβpowered platform plus Vercel preview deployments enable zeroβdowntime Postgres schema changes with instant branches.
Just published a deep dive on how every Vercel preview gets a full production database copy.
But that's not even the best bit.
Want to know how to safely update your database schema add a column, rename a field, even do complex behindβtheβscenes transformations while production keeps humming?
28.07.2025 13:20 β π 2 π 2 π¬ 1 π 0
I haven't seen the stars
But I have touched the tall trees
Where's my Nintendo
An original haiku by my ten year old son Duke whilst camping.
26.07.2025 01:01 β π 37 π 1 π¬ 1 π 0
lol
26.07.2025 03:03 β π 1 π 0 π¬ 0 π 0
This matches my experience
24.07.2025 16:57 β π 0 π 0 π¬ 0 π 0
Using GitHub Spark to reverse engineer GitHub Spark
GitHub Spark was released in public preview yesterday. Itβs GitHubβs implementation of the prompt-to-app pattern also seen in products like Claude Artifacts, Lovable, Vercel v0, Val Town Townie and Fl...
GitHub released Spark yesterday, their extremely well crafted prompt-to-app platform for creating and iterating on React apps with user auth and persistent storage
I like it a lot! I reverse engineered it with Spark itself, the details are fascinating simonwillison.net/2025/Jul/24/...
24.07.2025 15:40 β π 114 π 19 π¬ 9 π 5
Xata: Postgres with data branching and PII anonymization | xata
Relaunching Xata as "Postgres at scale". A Postgres platform with Copy-on-Write branching, data masking, and separation of storage from compute.
π£ We have a brand new Postgres platform with:
Instant Copy-on-Write branching
Built-in data anonymization
Separation of storage and compute
100% vanilla Postgres
Itβs for staging/dev environments as well as for production workloads.
Blog post: xata.io/blog/xata-po...
And more details in π§΅
14.05.2025 15:32 β π 3 π 5 π¬ 2 π 1
What time is it? It is PGConf time π
08.05.2025 05:24 β π 1 π 0 π¬ 0 π 0
oh I need something similar, my use case is to run remote ffmpeg
something that can copy the current directory (like docker context), execute the command I provided, sync the target directory back to my machine, something like
remoteexec -c config.yml 'ffmpeg -i input.avi -o output.mp4'
30.04.2025 06:13 β π 0 π 0 π¬ 0 π 0
this should be illegal, if it is not already
23.04.2025 08:27 β π 2 π 0 π¬ 1 π 0
π
18.04.2025 20:49 β π 0 π 0 π¬ 0 π 0
Rest of World is one of my favorite outlets so imagine my surprise & delight opening it today and spotting my friend and former coworker Gulcin talking about the sexism women coders face in Turkey.
Her efforts to organize & encourage this group is really admirable.
restofworld.org/2025/turkeys...
17.04.2025 14:00 β π 12 π 2 π¬ 1 π 0
Are there Senior/Staff+ Engineers on my timeline who want to work on the intersection of #Databases, #Caches, #Infra, Kubernetes/Operators and #Scaling #Algorithms (think time series, predictive scaling etc)?
If so, please drop me a DM. Our small but mighty team at ClickHouse is growing!
14.04.2025 17:54 β π 17 π 4 π¬ 2 π 1
gm
14.04.2025 07:39 β π 0 π 0 π¬ 0 π 0
You have to write SQL queries in uppercase because the language is old and canβt hear you as well as it used to
13.04.2025 08:42 β π 86 π 19 π¬ 5 π 1
zen book strikes again
13.04.2025 07:49 β π 0 π 0 π¬ 0 π 0
The chroot Technique - a Swiss army multitool for Linux systems | Living Systems_
Found this on HN, it is a life saver. I had locked myself out when I was yolo setting up 2FA w/ Yubikey on Ubuntu and this is how I got out. Wanted to document that process but now I can just bookmark this post.
livesys.se/posts/the-ch...
12.04.2025 06:57 β π 0 π 0 π¬ 0 π 0
gm
11.04.2025 05:39 β π 0 π 0 π¬ 0 π 0
One of those techniques which seem so obvious in hindsight. Definitely going to be using this.
08.04.2025 14:58 β π 6 π 1 π¬ 2 π 0
late to the ghiblification party, but here we are
09.04.2025 18:10 β π 1 π 0 π¬ 0 π 0
Can't complaint, was on π₯ yesterday
09.04.2025 07:02 β π 0 π 0 π¬ 0 π 0
pgroll 0.11.0 update: YAML migration, drop name requirement | pgroll
We've just released v0.10 of pgroll, our open-source schema migration tool for Postgres. It includes support for YAML migration files.
π₯ New pgroll release! v0.11 brings:
π YAML support for migrations
π Timestamps now with timezone info
π `name` field is now optional
π» Tables without primary key or unique column can be backfilled
π§Ή Better errors
Zero-downtime Postgres migrations, now smoother.
π Blog: pgroll.com/blog/pgroll-...
08.04.2025 16:19 β π 3 π 2 π¬ 1 π 1
What a beautiful day to play β½οΈ
08.04.2025 16:02 β π 1 π 0 π¬ 0 π 0
Incredibly excited that the @electric-sql.com team shipped Electric Cloud today! ππ
This enables you to use the Electric sync engine without having to commission any infrastructure.
Just give it your Postgres URL and you are ready to sync!
07.04.2025 18:16 β π 5 π 2 π¬ 0 π 0
Yup. I call this stage 5: βacceptanceβ
07.04.2025 11:25 β π 27 π 3 π¬ 1 π 0
gm
07.04.2025 07:16 β π 0 π 0 π¬ 0 π 0
With copy-on-write branching, data masking, separated storage & compute , 100% Postgres
Create and share social media content anywhere, consistently.
Built with π by a global, remote team.
β¬οΈ Learn more about Buffer & Bluesky
https://buffer.com/bluesky
building @inline.chat β’ engineer, designer, founder β’ comaker there.pm β’ pioneer.app alumn
NVMe-first unified storage optimization platform
https://www.simplyblock.io
Co-funded by the European Union.
LinkTree: https://linktr.ee/simplyblock
Find me at https://bsky.app/profile/prolost.com
A #queer software engineer for the past 20+ years. Half of that time with #rustlang. #Linux user since 1998.
In #berlin.
A super nerdy #music collector, #movie fanatic, runner and a #cat lover.
https://github.com/pimeys
https://grafbase.com
He/them
CEO & Co-founder @electric-sql.com
Founder and CEO at Nile (https://www.thenile.dev/). Previously: VP of Engineering at Confluent. Believe to win.
Builder of web things. Still hacking every day. Building tableslayer.com
https://davesnider.com
Creator of Flask β’ sentry.io β₯οΈ writing and giving talks β’ Excited about AI β’ Husband and father of three β’ Inhabits Vienna; Liberal Spirit β’ βmore nuanced in personβ β’ More AI content on https://x.com/mitsuhiko
More stuff: https://mitsuhiko.at/
Lightweight WASM Postgres by @electric-sql.com
https://pglite.dev
Building AI apps? You need sync.
https://electric-sql.com - see also @pglite.dev
πΊπ¦, Postgres, kids, Berlin and everything else. Posts in English, auf Deutsch ΡΠ° ΡΠΊΡΠ°ΡΠ½ΡΡΠΊΠΎΡ. Support Ukraine fighting Russian aggression: https://savelife.in.ua/en/
Software engineer @xata, previously @elastic. Traveler, geek, astrophotographer wannabe, with love for Go, Python, FOSS, Linux and distributed systems.
Software Engineer. Educator. Entrepreneur. Bootstrapping labs.iximiuz.com - a learning platform to help you master Linux, Containers, and Kubernetes π
Dog person, software engineer, pedestrian. Interests: database engineering, GraphQL, Rust, etc.
Building llm-ui.com and limitphone.com.
richardgill.org