Portabase Logo
Portabase AgentDatabases

SQLite

Configuration for SQLite.

Configuration

{
  "name": "SQLite - 1",
  "type": "sqlite",
  "host": "db-sqlite",
  "path": "/sqlite-data/workspace/data/app.db",
  "generated_id": "..."
}

Docker Compose Example

Example with a SQLite image.

docker-compose.yml
services:

    sqlite:
      container_name: db-sqlite
      image: keinos/sqlite3
      volumes:
        - sqlite-data:/workspace/data
      working_dir: /workspace
      command: tail -f /dev/null
      stdin_open: true
      tty: true

    agent:
        image: portabase/agent:latest
        volumes:
          - ./databases.json:/config/config.json
        # Map data sqlite folder in order to access it then in agent container
          - sqlite-data:/sqlite-data/workspace/data
        # ... agent configuration ...
        networks:
          - portabase

networks:
  portabase:
    external: true

volumes:
  sqlite-data:

If you use a local SQLite database, you only have to map it in agent volumes /var/lib/myapp:/sqlite-data/workspace/data

On this page