Snapp x Coolify

[Zai]

Here is a docker compose working with Coolify.
I let you create a pull request on Coolify project, I think it will be better if it's come from you. ;)

services:
  snapp:
    image: 'uraniadev/snapp:latest'
    environment:
      - SERVICE_FQDN_SNAPP_3000
      - ORIGIN=$SERVICE_FQDN_SNAPP
      - DATABASE_PROVIDER=postgres
      - DATABASE_POSTGRES_URL=postgres://$SERVICE_USER_POSTGRES:$SERVICE_PASSWORD_POSTGRES@postgresql:5432/$POSTGRES_DB
      - TOKEN_SECRET=$SERVICE_PASSWORD_SNAPP
      - ADMIN_USERNAME=${SNAPP_ADMIN_USERNAME:-admin}
      - ADMIN_PASSWORD=${SNAPP_ADMIN_PASSWORD:-password}
      - ADMIN_EMAIL=${SNAPP_ADMIN_EMAIL:?}
      - DISABLE_HOME=false
      - ENABLE_SIGNUP=false
      - PORT=3000
    depends_on:
      postgresql:
        condition: service_healthy
    healthcheck:
      test: 'wget --no-verbose --tries=1 --spider http://0.0.0.0:3000 || exit 1'
      interval: 5s
      timeout: 20s
      retries: 10
  postgresql:
    image: 'postgres:16-alpine'
    volumes:
      - 'postgresql-data:/var/lib/postgresql/data'
    environment:
      - POSTGRES_USER=$SERVICE_USER_POSTGRES
      - POSTGRES_PASSWORD=$SERVICE_PASSWORD_POSTGRES
      - 'POSTGRES_DB=${POSTGRES_DB:-snapp}'
    healthcheck:
      test:
        - CMD-SHELL
        - 'pg_isready -U $${POSTGRES_USER} -d $${POSTGRES_DB}'
      interval: 5s
      timeout: 20s
      retries: 10

[urania-dev]

as i really appreciate your work, i'm actually working on next version that has priority as i don't have much time to dedicate to the project (not as much as i would), but i'm happy to do this too once the next version will be release (we are close to version 1 :) )

thank you again and i'll let you know more soon!

[urania-dev]

once the 0.9-rc version get fixed and tested i'll look into this :)

[Zai]

I just completed a fresh install of version uraniadev/snapp:0.9-rc-004 on Coolify.

I will share it in a few days, giving me time to test for bugs

[Zai]

docker-compose working with uraniadev/snapp:0.9-rc-009 on Coolify

services:
  snapp:
    image: 'uraniadev/snapp:0.9-rc-009'
    environment:
      - SERVICE_FQDN_SNAPP_3000
      - PUBLIC_URL=$SERVICE_FQDN_SNAPP
      - ORIGIN=$SERVICE_FQDN_SNAPP
      - DATABASE_PROVIDER=postgres
      - 'DATABASE_URL=postgres://$SERVICE_USER_POSTGRES:$SERVICE_PASSWORD_POSTGRES@postgresql:5432/$POSTGRES_DB'
      - TOKEN_SECRET=$SERVICE_PASSWORD_SNAPP
      - 'ADMIN_USERNAME=${SNAPP_ADMIN_USERNAME:?}'
      - 'ADMIN_EMAIL=${SNAPP_ADMIN_EMAIL:?}'
      - 'ADMIN_PASSWORD=${SNAPP_ADMIN_PASSWORD:?}'
      - DISABLE_HOME=false
      - ENABLE_SIGNUP=true
      - PORT=3000
    depends_on:
      postgresql:
        condition: service_healthy
    healthcheck:
      test:
        - CMD
        - curl
        - '-f'
        - 'http://0.0.0.0:3000/health'
      interval: 5s
      timeout: 20s
      retries: 10
  postgresql:
    image: 'postgres:16-alpine'
    volumes:
      - 'postgresql-data:/var/lib/postgresql/data'
    environment:
      - POSTGRES_USER=$SERVICE_USER_POSTGRES
      - POSTGRES_PASSWORD=$SERVICE_PASSWORD_POSTGRES
      - 'POSTGRES_DB=${POSTGRES_DB:-snapp}'
    healthcheck:
      test:
        - CMD-SHELL
        - 'pg_isready -U $${POSTGRES_USER} -d $${POSTGRES_DB}'
      interval: 5s
      timeout: 20s
      retries: 10

[urania-dev]

i'll finish a couple of edits (the home is still a work in progress) and i'll send the request! 👍

[urania-dev]

Today im gonna try reinstall coolify and test this, if not i'll try on the Cloud Just to do the PR.

I'll ask you if i get stuck somewhere!

[urania-dev]

So, i tried. The psql compose you provided worked flawlessy, but inspired by the with-[database-provirer] from gitea and other services already there i tried also other combo.

Resulted in an array of errors from the late SQLite versions of the app which I had Just figured out. It has been a busy period, Sorry.

It this new 011 version and mysql works i'll make the PR

[Zai]

To create coolify template I dont think you need to have all supported db. From what I can see, Postgres is the most used DB.

[urania-dev]

no i know, but i already mapped the possiblity on app, it make sense to open the possibility to people :)

[urania-dev]

coollabsio/coolify#5446

[Zai]

Awesome :)