SQLite databases are a file on disk instead of a database server like PostgreSQL and MySQL.
⚠️ Since SQLite is a file, it will only work with a single server.
Rails
To use SQLite with your Hatchbox applications, you will need to tell your application to store the SQLite database in a shared location.
You can specify this with the DATABASE_URL
env var:
DATABASE_URL=sqlite3:///home/deploy/myapp/shared/production.sqlite3
Or in your database.yml
:
sqlite3:///home/deploy/myapp/shared/production.sqlite3
Change "myapp" to the name of your application.