Shepherd successfully migrated its pricing engine database from SQLite to Postgres with zero downtime. The new architecture improves scalability, performance, and developer experience. The migration included converting synchronous functions to asynchronous, leveraging a serverless architecture with Neon, and automating ETL
Table of contents
HistoryThe Impetus for ChangeKey Questions Driving the MigrationStepsStep 1: Choosing the Right DatabaseStep 2: Code ChangesStep 3: Deployment ChangesStep 4: Developer ExperienceRoadblocksEnsure database is in same region as application serverCachingParallelize FunctionsConnection PoolingClosing ThoughtsFootnotesSort: