How to use local sqlite database?

[sedubois]

I want to deploy a demo Rails app to a single VPS using SQLite (DHH wrote that for a project "which is going to be deployed to a single server, you should just use sqlite"). However I didn't find details on how to configure Kamal with sqlite (config/deploy.yml and config/database.yml). Any hints? The setup I tried resulted in kamal setup throwing bind: address already in use.

[sedubois]

address already in use was because nginx was already running on the server and blocking port 80.

For anyone interested, the setup below allowed me to deploy a Rails app with SQLite to a single server. The volumes part is to persist the DB between deploys.

config/deploy.yml:

service: ...
image: ...
servers:
  - <ip address>
registry:
  username: ...
  password:
    - KAMAL_REGISTRY_PASSWORD
volumes:
  - "storage:/rails/storage"
env:
  secret:
    - RAILS_MASTER_KEY

config/database.yml (default - left untouched):

default: &default
  adapter: sqlite3
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  timeout: 5000

production:
  <<: *default
  database: storage/production.sqlite3

[cmoel]

Hi @sedubois. I have similar config/deploy.yml and config/database.yml files and I'm running into permissions issues with the volume on the host. Do you have any guidance for setting the permissions correctly on the host?

[cmoel]

I figured out a solution to the permissions issue I was hitting: named Docker volumes. Here's an example diff to config/deploy.yml:

diff --git a/config/deploy.yml b/config/deploy.yml
index 33ab327..fbb74ec 100644
--- a/config/deploy.yml
+++ b/config/deploy.yml
@@ -45,7 +45,7 @@ env:
     - RAILS_MASTER_KEY

 volumes:
-  - /my-app/db:/rails/db
+  - my-app-db:/rails/db

This created a volume at /var/lib/docker/volumes/my-app-db with the correct permissions (1000 for the user and the group):

root@ubuntu-2gb-ash-1:/var/lib/docker/volumes/private-lessons-db# ls -laF
total 12
drwx-----x 3 root root 4096 Mar 19 09:18 ./
drwx-----x 4 root root 4096 Mar 19 09:18 ../
drwxr-xr-x 6 1000 1000 4096 Mar 19 09:18 _data/