--- title: Blog: Tech Tales: Leveraging Fly Volumes to Transition... description: Learn about the process of migrating from PostgreSQL to SQLite, including the reasons for migration, performance comparison, removing PostgreSQL from the app,... canonical: https://daily.dev/posts/blog-tech-tales-leveraging-fly-volumes-to-transition-from-postgresql-to-sqlite-xeasivvdh twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Blog: Tech Tales: Leveraging Fly Volumes to Transition from PostgreSQL to SQLite | daily.dev og:description: Learn about the process of migrating from PostgreSQL to SQLite, including the reasons for migration, performance comparison, removing PostgreSQL from the app,... og:url: https://daily.dev/posts/blog-tech-tales-leveraging-fly-volumes-to-transition-from-postgresql-to-sqlite-xeasivvdh og:image: https://api.daily.dev/og/posts/xEASIvVDH.png og:image:alt: Blog: Tech Tales: Leveraging Fly Volumes to Transition from PostgreSQL to SQLite og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Blog: Tech Tales: Leveraging Fly Volumes to Transition from PostgreSQL to SQLite **[Community Picks](https://daily.dev/sources/community)** · 6 min read · 3 upvotes · 1 comments ## Summary Learn about the process of migrating from PostgreSQL to SQLite, including the reasons for migration, performance comparison, removing PostgreSQL from the app, setting up Fly.io to deploy the migration, and closing thoughts. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Community discussion Top comments from developers on daily.dev. **@caicedomateo9** · 1 upvotes > Let's goooo!! --- Tags: [#performance](https://daily.dev/tags/performance), [#postgresql](https://daily.dev/tags/postgresql), [#sqlite](https://daily.dev/tags/sqlite) [View this post on daily.dev](https://daily.dev/posts/blog-tech-tales-leveraging-fly-volumes-to-transition-from-postgresql-to-sqlite-xeasivvdh) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Blog: Tech Tales: Leveraging Fly Volumes to Transition from PostgreSQL to SQLite","url":"https://daily.dev/posts/blog-tech-tales-leveraging-fly-volumes-to-transition-from-postgresql-to-sqlite-xeasivvdh","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/blog-tech-tales-leveraging-fly-volumes-to-transition-from-postgresql-to-sqlite-xeasivvdh"},"datePublished":"2024-05-02T21:09:52.306Z","dateModified":"2024-05-09T08:39:06.345Z","description":"Learn about the process of migrating from PostgreSQL to SQLite, including the reasons for migration, performance comparison, removing PostgreSQL from the app,...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/bc0d6034cdb51cc92ff3ac2768fa05ec?_a=AQAEuiZ","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/bc0d6034cdb51cc92ff3ac2768fa05ec?_a=AQAEuiZ","isAccessibleForFree":true,"articleSection":"Community Picks","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Community Picks","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community","url":"https://daily.dev/sources/community"},"commentCount":1,"discussionUrl":"https://daily.dev/posts/blog-tech-tales-leveraging-fly-volumes-to-transition-from-postgresql-to-sqlite-xeasivvdh","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":3},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":1}],"keywords":"performance,postgresql,sqlite","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Community Picks","item":"https://daily.dev/sources/community"},{"@type":"ListItem","position":3,"name":"Blog: Tech Tales: Leveraging Fly Volumes to Transition from PostgreSQL to SQLite"}]} {"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/blog-tech-tales-leveraging-fly-volumes-to-transition-from-postgresql-to-sqlite-xeasivvdh","comment":[{"@type":"Comment","text":"Let’s goooo!!","datePublished":"2024-05-02T21:13:47.214Z","url":"https://daily.dev/posts/xEASIvVDH#c-PP7gcGdsL","author":{"@type":"Person","name":"Mateo Caicedo","url":"https://daily.dev/caicedomateo9","image":"https://lh3.googleusercontent.com/a/ACg8ocKIg0Z4wwxHEIJzHcTLyB9gAU_hmQQIdOOZiVolvvka6ueW3Q=s96-c"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}}]} ```