Squarespace transitioned from PostgreSQL to CockroachDB for better scalability and performance, leveraging Change Data Capture (CDC) to facilitate near real-time data migration with minimal downtime. They developed a systematic migration strategy that addressed schema compatibility, data integrity, and rollback capabilities, ultimately achieving a seamless cutover with high data freshness.