Greg Kontos reduced data storage costs by over 99% by migrating his hobby recipe tracking site from a GCP Cloud SQL instance to using DuckDB. Initially faced with a $68/month cost, with $67 of that for the SQL database, Greg explored various alternatives including serverless databases, dataframes, and local databases. He ultimately chose DuckDB for its SQL-like interface, simplicity, and low cost. Despite some minor issues, the transition was successful, lowering monthly costs to just $0.25 and maintaining functionality.
Table of contents
The ProblemThe SolutionPersistent Database AlternativesMy RequirementsOptionsChoosing DuckDBMaking the SwitchBumps in the RoadNext StepsWrapping UpSort: