--- title: lobste.rs migrates from MariaDB to SQLite | daily.dev description: lobste.rs attempted a live migration from MariaDB to SQLite, briefly entering read-only mode to complete the switch. The migration was quickly reverted after... canonical: https://daily.dev/posts/lobste-rs-migrates-from-mariadb-to-sqlite-rlqerses0 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: lobste.rs migrates from MariaDB to SQLite | daily.dev og:description: lobste.rs attempted a live migration from MariaDB to SQLite, briefly entering read-only mode to complete the switch. The migration was quickly reverted after... og:url: https://daily.dev/posts/lobste-rs-migrates-from-mariadb-to-sqlite-rlqerses0 og:image: https://api.daily.dev/og/posts/RLQeRSeS0.png og:image:alt: lobste.rs migrates from MariaDB 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. # lobste.rs migrates from MariaDB to SQLite **[Lobsters](https://daily.dev/sources/lobsters)** · 1 min read · 0 upvotes · 0 comments ## Summary lobste.rs attempted a live migration from MariaDB to SQLite, briefly entering read-only mode to complete the switch. The migration was quickly reverted after the site experienced severe performance degradation. The GitHub issue tracking the effort shows the team had previously considered PostgreSQL before settling on SQLite. The rollback is considered temporary, with plans to retry after addressing the performance issues encountered. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [lobste.rs is now running on SQLite](https://daily.dev/posts/lobste-rs-is-now-running-on-sqlite-5hlawqyuh) · Lobsters · 1 upvotes · 0 comments --- Tags: [#performance](https://daily.dev/tags/performance), [#infrastructure](https://daily.dev/tags/infrastructure), [#database](https://daily.dev/tags/database), [#rails](https://daily.dev/tags/rails), [#sqlite](https://daily.dev/tags/sqlite) [View this post on daily.dev](https://daily.dev/posts/lobste-rs-migrates-from-mariadb-to-sqlite-rlqerses0) ```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":"lobste.rs migrates from MariaDB to SQLite","url":"https://daily.dev/posts/lobste-rs-migrates-from-mariadb-to-sqlite-rlqerses0","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/lobste-rs-migrates-from-mariadb-to-sqlite-rlqerses0"},"datePublished":"2026-02-21T22:58:39.913Z","dateModified":"2026-02-21T22:58:58.325Z","description":"lobste.rs attempted a live migration from MariaDB to SQLite, briefly entering read-only mode to complete the switch. The migration was quickly reverted after...","image":"https://media.daily.dev/image/upload/s--foaA6JGU--/f_auto/v1722860399/public/Placeholder%2004","thumbnailUrl":"https://media.daily.dev/image/upload/s--foaA6JGU--/f_auto/v1722860399/public/Placeholder%2004","isAccessibleForFree":true,"articleSection":"Lobsters","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":"Lobsters","logo":"https://media.daily.dev/image/upload/s--tl8v_Fku--/f_auto,t_logo/v1698841318/logos/lobste.jpg","url":"https://daily.dev/sources/lobsters"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/lobste-rs-migrates-from-mariadb-to-sqlite-rlqerses0","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"performance,infrastructure,database,rails,sqlite","timeRequired":"PT1M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Lobsters","item":"https://daily.dev/sources/lobsters"},{"@type":"ListItem","position":3,"name":"lobste.rs migrates from MariaDB to SQLite"}]} ```