All Templates / Storage

SQLite3

SQLite3

SQLite3 is a lightweight database

Deploy SQLite3

SQLite3

railwayapp-templates/sqlite

Just deployed

/data

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


Template Content

Deploy Now

Details

Thalles Passos's Projects

Created on Aug 5, 2023

701 total projects

308 active projects

96% success on recent deploys

Shell, Python, Dockerfile

Storage



More templates in this category

View Template
ReadySet

ReadySet

A lightweight caching engine for Postgres


Milo's Projects

View Template
Flare

Flare

A modern, lightning-fast file sharing platform built for self-hosting


FlintSH's Projects

View Template
EdgeDB

EdgeDB

EdgeDB template based on their Docker deployment guide


Ajit Krishna's Projects