Why Squarespace migrated global data workloads from PostgreSQL to CockroachDB

RoachFest 2025 highlighted the critical importance of primary data and metadata for companies managing vast amounts of user-facing data, underscoring the need for data consistency, high availability, and rapid performance. Attendees, including global education platforms and website builders like Squarespace, discussed the limitations of traditional database architectures, such as PostgreSQL's single-primary model, in handling these demands. Squarespace's migration to CockroachDB was showcased as a solution to overcome these challenges, offering built-in replication, automated failover, and horizontal scalability, which allowed the company to manage over 100 migrations without downtime or errors. CockroachDB's approach enabled Squarespace to treat data as globally available infrastructure, facilitating stronger resilience, simpler operations, and a path to global scale. The event generated interest in CockroachDB as a system of record for modernizing user-facing workloads without disruption, with sessions available for viewing on the RoachFest 2025 Hub.