# \#sqlite

**URL:** https://community.fly.io/tag/sqlite/40.md

[Latest](https://community.fly.io/latest.md) · [Categories](https://community.fly.io/categories.md) · [Tags](https://community.fly.io/tags.md)

---

## [How to deploy a Deno app with data from Deno KV and JSON files?](https://community.fly.io/t/how-to-deploy-a-deno-app-with-data-from-deno-kv-and-json-files/28447)

<div class="topic-metadata">

**Author:** [@Ooker](https://community.fly.io/u/Ooker)\
**Replies:** 16\
**Last updated:** [August 9, 2026, 8:17pm UTC](https://community.fly.io/t/how-to-deploy-a-deno-app-with-data-from-deno-kv-and-json-files/28447 "2026-08-09T20:17:14Z")

</div>

Background My app was built specifically for Deno Deploy so it’s tightly coupled with Deno KV. Also, there are JSON files that are constantly modified on the local to provide another set of data. Before Deno Deploy Class…

---

## [Setting up an Django app to use a Fly volume for the SQLite database](https://community.fly.io/t/setting-up-an-django-app-to-use-a-fly-volume-for-the-sqlite-database/27779)

<div class="topic-metadata">

**Author:** [@dwadler](https://community.fly.io/u/dwadler)\
**Replies:** 10\
**Last updated:** [May 3, 2026, 9:04pm UTC](https://community.fly.io/t/setting-up-an-django-app-to-use-a-fly-volume-for-the-sqlite-database/27779 "2026-05-03T21:04:34Z")

</div>

I have a django that I’ve been running for years on a local Ubuntu server that I’m trying to move to fly.io without any success. It isn’t clear what the relationship is between the name of the db.sqlite3 database and th…

---

## [FlareWarden — Uptime Monitoring Built on Fly.io (Show & Tell / Soft Launch)](https://community.fly.io/t/flarewarden-uptime-monitoring-built-on-fly-io-show-tell-soft-launch/27355)

<div class="topic-metadata">

**Author:** [@Zane\_Milakovic](https://community.fly.io/u/Zane_Milakovic)\
**Replies:** 0\
**Last updated:** [March 12, 2026, 3:17pm UTC](https://community.fly.io/t/flarewarden-uptime-monitoring-built-on-fly-io-show-tell-soft-launch/27355 "2026-03-12T15:17:37Z")

</div>

Hey everyone, I’ve been building on Fly.io for about 4 years now — started with BrickDrop (a Lego rental subscription service), and now I’m working on something new: FlareWarden. FlareWarden detects your SSL, DNS, payme…

---

## [Using snapshots for SQLite backups?](https://community.fly.io/t/using-snapshots-for-sqlite-backups/26806)

<div class="topic-metadata">

**Author:** [@porton](https://community.fly.io/u/porton)\
**Replies:** 1\
**Last updated:** [January 12, 2026, 2:07pm UTC](https://community.fly.io/t/using-snapshots-for-sqlite-backups/26806 "2026-01-12T14:07:28Z")

</div>

For now, I want to save money and not use PostgreSQL. So, I want a single volume with SQLite inside and its multiple backups in different regions. Backups need to be as secure as the app itself is. First, I don’t see “…

---

## [Why is /data/dev.db referenced in litestream.yml in docs?](https://community.fly.io/t/why-is-data-dev-db-referenced-in-litestream-yml-in-docs/26729)

<div class="topic-metadata">

**Author:** [@justinb](https://community.fly.io/u/justinb)\
**Replies:** 0\
**Last updated:** [January 3, 2026, 2:19am UTC](https://community.fly.io/t/why-is-data-dev-db-referenced-in-litestream-yml-in-docs/26729 "2026-01-03T02:19:06Z")

</div>

Here in the docs, the litestream.yml references /data/dev.db which is typically a development database which is not present in production, where this runs. I think, by default it is usually /data/sqlite.db . The generat…

---

## [Volume grew 20GB → 80GB overnight](https://community.fly.io/t/volume-grew-20gb-80gb-overnight/26670)

<div class="topic-metadata">

**Author:** [@waverlycabinets](https://community.fly.io/u/waverlycabinets)\
**Replies:** 1\
**Last updated:** [December 19, 2025, 4:23pm UTC](https://community.fly.io/t/volume-grew-20gb-80gb-overnight/26670 "2025-12-19T16:23:43Z")

</div>

I’m running a Remix app on Fly.io that grew from 20GB to 80GB overnight. We’re running litestream and passing backups to Tigris Object Storage. Does anyone know what might be happening? It started two days ago.

---

## [Volume vol\_45lmj7xokynn0xjr cannot mount (IAD) - 502 error on snapshot restore](https://community.fly.io/t/volume-vol-45lmj7xokynn0xjr-cannot-mount-iad-502-error-on-snapshot-restore/26438)

<div class="topic-metadata">

**Author:** [@david-cuadrado](https://community.fly.io/u/david-cuadrado)\
**Replies:** 5\
**Last updated:** [November 14, 2025, 5:34pm UTC](https://community.fly.io/t/volume-vol-45lmj7xokynn0xjr-cannot-mount-iad-502-error-on-snapshot-restore/26438 "2025-11-14T17:34:38Z")

</div>

Hello Fly.io Support team, I have an application: accounts-manager-ansgt in region IAD. My volume (vol\_45lmj7xokynn0xjr) cannot be mounted — I get: “insufficient resources to create new machine with existing volume”. …

---

## [Recover volume in pending\_destroy state - data still needed](https://community.fly.io/t/recover-volume-in-pending-destroy-state-data-still-needed/26392)

<div class="topic-metadata">

**Author:** [@enesccinar](https://community.fly.io/u/enesccinar)\
**Replies:** 1\
**Last updated:** [November 6, 2025, 8:29am UTC](https://community.fly.io/t/recover-volume-in-pending-destroy-state-data-still-needed/26392 "2025-11-06T08:29:38Z")

</div>

Hi Fly team, I’m hoping you can help me recover a volume that has gone into pending\_destroy state. Region: lax Volume ID: vol\_2gk9vwe9mz8v76wm Volume name: pb\_data State: pending\_destroy Created: over 2 years ago T…

---

## [Update beyond my control in my project in production environment-lost data](https://community.fly.io/t/update-beyond-my-control-in-my-project-in-production-environment-lost-data/26257)

<div class="topic-metadata">

**Author:** [@ersinyirik](https://community.fly.io/u/ersinyirik)\
**Replies:** 7\
**Last updated:** [October 21, 2025, 8:17pm UTC](https://community.fly.io/t/update-beyond-my-control-in-my-project-in-production-environment-lost-data/26257 "2025-10-21T20:17:02Z")

</div>

My production machine has reverted to the date I last deployed, and all changes I made through the panel and database content have also reverted to that date. My project is django+wagtail, and I’m currently using SQLite …

---

## [Multiple \[\[metrics\]\] entries without process groups?](https://community.fly.io/t/multiple-metrics-entries-without-process-groups/26251)

<div class="topic-metadata">

**Author:** [@dtkav](https://community.fly.io/u/dtkav)\
**Replies:** 0\
**Last updated:** [October 20, 2025, 6:18pm UTC](https://community.fly.io/t/multiple-metrics-entries-without-process-groups/26251 "2025-10-20T18:18:50Z")

</div>

Hi, I’m running a pocketbase app with litestream and hoping to collect metrics for both. In my fly.toml file I put: \[\[metrics\]\] port = 9091 path = "/metrics" \[\[metrics\]\] port = 9090 path = "/metrics" but pro…

---

## [Litestream v0.5.1 Released](https://community.fly.io/t/litestream-v0-5-1-released/26176)

<div class="topic-metadata">

**Author:** [@benbjohnson](https://community.fly.io/u/benbjohnson)\
**Replies:** 0\
**Last updated:** [October 13, 2025, 10:56pm UTC](https://community.fly.io/t/litestream-v0-5-1-released/26176 "2025-10-13T22:56:11Z")

</div>

A few weeks ago, we release Litestream v0.5.0 and it was a big release! We revamped the underlying storage architecture to improve storage efficiency and restore times dramatically. However, with every big change there …

---

## [Deployment fails when SQLite migration is slow](https://community.fly.io/t/deployment-fails-when-sqlite-migration-is-slow/25942)

<div class="topic-metadata">

**Author:** [@emschwartz](https://community.fly.io/u/emschwartz)\
**Replies:** 2\
**Last updated:** [September 15, 2025, 6:19pm UTC](https://community.fly.io/t/deployment-fails-when-sqlite-migration-is-slow/25942 "2025-09-15T18:19:55Z")

</div>

I’m running into problems deploying an SQLite/Litestream-based app on Fly when a migration runs slowly. For example, a migration might create a new index for a large table. If the migration takes too long, Fly kills the …

---

## [LiteFS exists, but Drizzle can't find database](https://community.fly.io/t/litefs-exists-but-drizzle-cant-find-database/25909)

<div class="topic-metadata">

**Author:** [@mnlfischer](https://community.fly.io/u/mnlfischer)\
**Replies:** 5\
**Last updated:** [September 15, 2025, 10:12am UTC](https://community.fly.io/t/litefs-exists-but-drizzle-cant-find-database/25909 "2025-09-15T10:12:57Z")

</div>

I try to figure out why drizzle can not connect to the database file. When I ssh into the container I can see that the file is in place. Drizzle migrations found it with the same env variable and migrations have no issue…

---

## [Using s3 and Wasabi for Build](https://community.fly.io/t/using-s3-and-wasabi-for-build/25421)

<div class="topic-metadata">

**Author:** [@chavenor](https://community.fly.io/u/chavenor)\
**Replies:** 9\
**Last updated:** [July 19, 2025, 9:55pm UTC](https://community.fly.io/t/using-s3-and-wasabi-for-build/25421 "2025-07-19T21:55:49Z")

</div>

Looks like a CA issue. Setting up the domain for production. Configuring the DNS and we should be good to go. 2025-07-17T15:34:15.525 app\[781560db495558\] iad \[info\] INFO Starting init (commit: d0572327e)... 2025-07-1…

---

## [Litestream bucket - no application. How to restore .lz4 files?](https://community.fly.io/t/litestream-bucket-no-application-how-to-restore-lz4-files/25392)

<div class="topic-metadata">

**Author:** [@Recall45](https://community.fly.io/u/Recall45)\
**Replies:** 0\
**Last updated:** [July 14, 2025, 7:04pm UTC](https://community.fly.io/t/litestream-bucket-no-application-how-to-restore-lz4-files/25392 "2025-07-14T19:04:51Z")

</div>

Long story short - I have an orphan volume on trigris containing litestream backups for a SQLite database Before, I accessed this data through the app using litestream CLI, but now the app no longer exists. How can I r…

---

## [Litestream with dynamic lease](https://community.fly.io/t/litestream-with-dynamic-lease/25217)

<div class="topic-metadata">

**Author:** [@tim\_othee](https://community.fly.io/u/tim_othee)\
**Replies:** 4\
**Last updated:** [June 30, 2025, 12:48pm UTC](https://community.fly.io/t/litestream-with-dynamic-lease/25217 "2025-06-30T12:48:17Z")

</div>

Following the sunsetting of LiteFS Cloud, I have setup Litestream on my app as per the Continuous backup via Litestream documentation to backup my litefs running with consul for dynamic leases. It works well but only as…

---

## [Machine suspended and it won't start again. (not another post about cold start)](https://community.fly.io/t/machine-suspended-and-it-wont-start-again-not-another-post-about-cold-start/24984)

<div class="topic-metadata">

**Author:** [@vuleje](https://community.fly.io/u/vuleje)\
**Replies:** 7\
**Last updated:** [May 28, 2025, 2:32pm UTC](https://community.fly.io/t/machine-suspended-and-it-wont-start-again-not-another-post-about-cold-start/24984 "2025-05-28T14:32:39Z")

</div>

I had pocketbase Docker app, it was deployed 9 months ago and i didn’t touch it since then, it was running without any problem. Yesterday it suddenly got suspended and it wont start again, tried restarting, log are empty…

---

## [Why would SQLite data disappear when scaling machines?](https://community.fly.io/t/why-would-sqlite-data-disappear-when-scaling-machines/24916)

<div class="topic-metadata">

**Author:** [@Recall45](https://community.fly.io/u/Recall45)\
**Replies:** 3\
**Last updated:** [May 20, 2025, 10:29pm UTC](https://community.fly.io/t/why-would-sqlite-data-disappear-when-scaling-machines/24916 "2025-05-20T22:29:18Z")

</div>

Context: I have an app with 60+ users The app arq is meant to be for fast development and easy maintainability. I used SQLite. Yesterday I scaled the number of fly machines of that application. The application has a v…

---

## [Can you have two Tigris buckets in an app?](https://community.fly.io/t/can-you-have-two-tigris-buckets-in-an-app/24867)

<div class="topic-metadata">

**Author:** [@Alex21](https://community.fly.io/u/Alex21)\
**Replies:** 2\
**Last updated:** [May 18, 2025, 1:44am UTC](https://community.fly.io/t/can-you-have-two-tigris-buckets-in-an-app/24867 "2025-05-18T01:44:52Z")

</div>

If I already have one bucket, my-app-bucket-1, in an app, then: fly --app my-app storage create --name my-app-bucket-2 returns Error: A Tigris project named my-app-bucket-1 already exists for app my-app If I can’t …

---

## [how to attach a volume snapshot to a vm?](https://community.fly.io/t/how-to-attach-a-volume-snapshot-to-a-vm/24780)

<div class="topic-metadata">

**Author:** [@yuvalp98](https://community.fly.io/u/yuvalp98)\
**Replies:** 3\
**Last updated:** [May 7, 2025, 6:01am UTC](https://community.fly.io/t/how-to-attach-a-volume-snapshot-to-a-vm/24780 "2025-05-07T06:01:52Z")

</div>

I accidently deleted my db in my volumes, so I want to use its latest snapshot to restore the data. I created a new volume based on this snapshot but I cant attach it to a VM. How do I do it? should I delete the VMs with…

---

## [Fly deploy via Github Actions fails - Rails 8 - Sqlite](https://community.fly.io/t/fly-deploy-via-github-actions-fails-rails-8-sqlite/24731)

<div class="topic-metadata">

**Author:** [@danwetherald](https://community.fly.io/u/danwetherald)\
**Replies:** 3\
**Last updated:** [May 1, 2025, 8:41pm UTC](https://community.fly.io/t/fly-deploy-via-github-actions-fails-rails-8-sqlite/24731 "2025-05-01T20:41:23Z")

</div>

When deploying on GH Actions we get this error. Everything from local fly deploy works just fine. Error: failed to fetch an image or build from source: error building: failed to solve: process "/bin/sh -c groupadd --sys…

---

## [Splitting front end, back end, and DB in a single "app"](https://community.fly.io/t/splitting-front-end-back-end-and-db-in-a-single-app/24705)

<div class="topic-metadata">

**Author:** [@commadelimited](https://community.fly.io/u/commadelimited)\
**Replies:** 6\
**Last updated:** [April 29, 2025, 9:12am UTC](https://community.fly.io/t/splitting-front-end-back-end-and-db-in-a-single-app/24705 "2025-04-29T09:12:42Z")

</div>

I have an existing application hosted on Fly: fairly vanilla Django with a SQLite backend. However I’d like to split the app into a more pure “frontend” (via Angular) and backend (using Django Rest Framework). I’d also l…

---

## [CD - Can't get the Github Branch Preview Workflow to work](https://community.fly.io/t/cd-cant-get-the-github-branch-preview-workflow-to-work/24618)

<div class="topic-metadata">

**Author:** [@Guled](https://community.fly.io/u/Guled)\
**Replies:** 1\
**Last updated:** [April 23, 2025, 9:12am UTC](https://community.fly.io/t/cd-cant-get-the-github-branch-preview-workflow-to-work/24618 "2025-04-23T09:12:46Z")

</div>

I have been following the guide here Git Branch Preview Environments on Github · Fly Docs For a basic Ruby on Rails application running SQLite3 & Tigris and I cannot really get it to work? Anyone else had success with …

---

## [Sunsetting LiteFS Cloud](https://community.fly.io/t/sunsetting-litefs-cloud/20829)

<div class="topic-metadata">

**Author:** [@benbjohnson](https://community.fly.io/u/benbjohnson)\
**Replies:** 25\
**Last updated:** [April 18, 2025, 7:55pm UTC](https://community.fly.io/t/sunsetting-litefs-cloud/20829 "2025-04-18T19:55:42Z")

</div>

Last year we released a managed service called LiteFS Cloud that continuously backs up LiteFS clusters. We’ve decided to wind it down. LiteFS Cloud will continue to be available until October 15, 2024. LiteFS Will Keep …

---

## [Struggle to deploy a new Rails application (Litestream + Tigris)](https://community.fly.io/t/struggle-to-deploy-a-new-rails-application-litestream-tigris/24492)

<div class="topic-metadata">

**Author:** [@Guled](https://community.fly.io/u/Guled)\
**Replies:** 9\
**Last updated:** [April 8, 2025, 8:45am UTC](https://community.fly.io/t/struggle-to-deploy-a-new-rails-application-litestream-tigris/24492 "2025-04-08T08:45:38Z")

</div>

fly launch is failing for me This has worked before, I’m wondering if something off Here is the application I’m trying to deploy

---

## [sqlite connection started hanging](https://community.fly.io/t/sqlite-connection-started-hanging/24442)

<div class="topic-metadata">

**Author:** [@jtauber](https://community.fly.io/u/jtauber)\
**Replies:** 14\
**Last updated:** [April 3, 2025, 2:38pm UTC](https://community.fly.io/t/sqlite-connection-started-hanging/24442 "2025-04-03T14:38:35Z")

</div>

After running without problems for a year, a site of mine with a read-only sqlite database stopped working. I narrowed down the problem to the connection to sqlite timing out. Nothing has changed on my side so not sure …

---

## [Fly.io WireGuard tunnel private networking to Turso](https://community.fly.io/t/fly-io-wireguard-tunnel-private-networking-to-turso/24410)

<div class="topic-metadata">

**Author:** [@chris-io](https://community.fly.io/u/chris-io)\
**Replies:** 0\
**Last updated:** [March 31, 2025, 3:07am UTC](https://community.fly.io/t/fly-io-wireguard-tunnel-private-networking-to-turso/24410 "2025-03-31T03:07:00Z")

</div>

How many I have my NextJS App Router web application hosted on Fly.io connect to my Turso database also hosted on Fly.io (I’m grand-fathered in, Cloud Providers - Turso), in the same region (ie. both in Fly.io sea Seattl…

---

## [Good news to the LiteFS community](https://community.fly.io/t/good-news-to-the-litefs-community/24386)

<div class="topic-metadata">

**Author:** [@gcv](https://community.fly.io/u/gcv)\
**Replies:** 0\
**Last updated:** [March 28, 2025, 6:14am UTC](https://community.fly.io/t/good-news-to-the-litefs-community/24386 "2025-03-28T06:14:43Z")

</div>

I didn’t remember the previous article on Macaroons explicitly mentioning the internal use of LiteFS. It’s great to know that LiteFS is an important part of Fly’s infrastructure. The documentation should emphasize this m…

---

## [Fly.io + Marmot + PocketBase = Distributed PocketBase](https://community.fly.io/t/fly-io-marmot-pocketbase-distributed-pocketbase/14129)

<div class="topic-metadata">

**Author:** [@x0ha1b](https://community.fly.io/u/x0ha1b)\
**Replies:** 3\
**Last updated:** [March 24, 2025, 2:50pm UTC](https://community.fly.io/t/fly-io-marmot-pocketbase-distributed-pocketbase/14129 "2025-03-24T14:50:46Z")

</div>

I’ve been working on creating a developer friendly quickly deployable demo for PocketBase with Fly.io. While there are still some rough edges, I believe it creates a pretty compelling case for how one can create a distri…

---

## [Writebook - Once](https://community.fly.io/t/writebook-once/24239)

<div class="topic-metadata">

**Author:** [@Recall45](https://community.fly.io/u/Recall45)\
**Replies:** 22\
**Last updated:** [March 14, 2025, 5:46pm UTC](https://community.fly.io/t/writebook-once/24239 "2025-03-14T17:46:56Z")

</div>

Hi! Today im trying to deploy Writebook a free and polish DIY reading book platform. Unfortunately they dont provide instructions on how to deploy in fly and they have an interactive terminal set up. Fly.io doesnt cop…

[Next page](https://community.fly.io/tag/sqlite/40.md?match_all_tags=true&page=1&tags%5B%5D=sqlite)
