--- title: "Deploy SQLite3" description: "SQLite3 is a lightweight database" category: "Storage" url: https://railway.com/deploy/jOiNFt --- # Deploy SQLite3 SQLite3 is a lightweight database **[Deploy SQLite3 on Railway](https://railway.com/template/jOiNFt)** - **Creator:** Thalles Passos's Projects - **Category:** Storage - **Total deploys:** 861 ## Template content ### SQLite3 - **Source:** https://github.com/railwayapp-templates/sqlite - **Public domain:** Yes ## Documentation

SQLite Template

SQLite3 is a lightweight, serverless, open-source database engine used for local storage in applications. It requires no configuration and supports SQL for data manipulation. # ✨ Features - SQLite3 database - SQLite Web Interface - `trains` table with sample data about Thomas & Friends (do you still need more features?) # 🤔 How to use ## 🌎 WebUI Usage 1. Open the project named "SQLite Template" 2. Go to the "Variables" tab and view the `SQLITE_WEB_UI_PASSWORD` variable, this is the password you'll need to access the web interface 3. Back to `Deployments`, in the top you'll see a URL which you can use to access the web interface 4. Click on the URL and you'll be redirected to the web interface, type your password and you'll be able to manage your database That's it! You can now manage your SQLite3. ## ⚙️ `seed_db.sql` Usage After you've deployed this template, you'll find a copy of this project in your Github. From there you can populate `seed_db.sql` with your own SQL code. The file will only be executed when you change anything in it and will run only once. ## ⚙️ `init_db.sql` Usage This file is used to initialize the database. It includes sample data for a `trains` table. # 📙 Learn more - [SQLite3](https://www.sqlite.org/index.html) - [SQLite Web](https://github.com/coleifer/sqlite-web) ## Similar templates - [Garage S3 Storage](https://railway.com/deploy/garage-s3-storage) — Ultra-light S3 server: fast, open-source, plug-and-play. - [Redis](https://railway.com/deploy/redis-1) — Self Host Latest Redis with Railway - [EasyImg](https://railway.com/deploy/easyimg) — Simple self-hostable Nuxt.js personal image hosting system. Open this page in a browser: https://railway.com/deploy/jOiNFt