How to Install Lite Queen on Ubuntu 24.04

Lite Queen is a lightweight, self-hosted SQLite database management tool designed for simplicity and performance. It provides a fast web interface for managing SQLite databases directly from your browser without needing heavy dependencies or containerization.

This guide shows how to install and configure Lite Queen on Ubuntu 24.04, ensuring it runs as a secure, persistent system service.

Step 1: Install Required Packages

Update the system and install the dependencies needed for downloading and running Lite Queen.

sudo apt update && sudo apt install wget curl -y

Step 2: Create Lite Queen User and Directories

Create a dedicated system user and folder structure to run Lite Queen securely.

sudo useradd -r -s /bin/false -d /opt/lite-queen litequeen
sudo mkdir -p /opt/lite-queen/data
sudo chown -R litequeen:litequeen /opt/lite-queen

Step 3: Download Lite Queen Binary

Download the latest Lite Queen binary from its official GitHub repository.

sudo wget -O /opt/lite-queen/lite-queen https://github.com/kivS/lite-queen/releases/latest/download/lite-queen-linux-x64
sudo chmod +x /opt/lite-queen/lite-queen
sudo chown litequeen:litequeen /opt/lite-queen/lite-queen

Step 4: Create a Systemd Service 

To make Lite Queen run automatically on startup, create a systemd service file.

sudo nano /etc/systemd/system/litequeen.service

Add the following content:

[Unit]
Description=Lite Queen SQLite Database Management
After=network.target

[Service]
Type=simple
User=litequeen
Group=litequeen
WorkingDirectory=/opt/lite-queen
ExecStart=/opt/lite-queen/lite-queen --port 8080 --hostname 0.0.0.0 --data_dir /opt/lite-queen/data
Restart=on-failure
RestartSec=5s
StandardOutput=journal
StandardError=journal

[Install]
WantedBy=multi-user.target

Save and exit the editor.

Step 5: Enable and Start Lite Queen

Reload systemd and start the Lite Queen service.

sudo systemctl daemon-reload
sudo systemctl enable litequeen
sudo systemctl start litequeen

Verify the service is running:

sudo systemctl status litequeen

Step 6: Allow Firewall Access (If UFW Is Active)

If UFW is enabled on your system, open the Lite Queen port (8080):

sudo ufw allow 8080/tcp
sudo ufw reload

Step 7: Access the Lite Queen Web Interface

Once the service is running, open your browser and go to:

http://<your-server-ip>:8080

You’ll be greeted by the Lite Queen web UI where you can manage SQLite databases easily and securely.

Conclusion

You’ve successfully installed and configured Lite Queen on Ubuntu 24.04.
It now runs as a dedicated service, providing a lightweight and efficient interface for managing SQLite databases directly in your browser.

Lite Queen is perfect for developers or administrators who need a quick, local database management tool without relying on heavy or complex database systems.