GoAdmio
GoAdmio Documentation

SQLite

From the GoAdmio knowledge base.

SQLite

This page explains the SQLite screen in GoAdmio. It lets you create and manage SQLite databases for any domain account — a lightweight, file-based alternative to MySQL/MariaDB.

Location: Admin Panel → Databases → SQLite
Location (User Panel): Databases → SQLite


Overview

SQLite is an embedded, file-based relational database. Unlike MySQL/MariaDB, which runs as a separate server process, SQLite stores an entire database in a single file on disk. It requires no daemon, no users, no privileges — the application simply opens the file.

GoAdmio includes SQLite management so accounts can host applications that use SQLite without needing a MySQL database. Common use cases:

  • Lightweight applications — small CMSs, forums, and tools that default to SQLite
  • Local development — a full database with no server setup
  • Read-heavy sites — SQLite performs well for read-intensive workloads
  • Portable backups — the database is a single file, easy to copy
  • Small business tools — invoicing, inventory, and note apps
> Note: SQLite is not a replacement for MySQL in multi-user, write-heavy, or high-concurrency environments. It locks the entire database file during writes, so concurrent writers can block each other. For WordPress, Laravel, and most CMSs, use MySQL Databases.

SQLite vs. MySQL/MariaDB

| Feature | SQLite | MySQL/MariaDB |
|---|---|---|
| Storage | Single file | Server process with data directory |
| Setup | None — file is the database | Requires database, user, privileges |
| Concurrency | One writer at a time | Many concurrent writers |
| Best for | Small apps, embedded use, read-heavy | CMSs, multi-user apps, high concurrency |
| Backup | Copy the file | mariadb-dump |
| Portability | Excellent — copy anywhere | Requires export/import |
| Users / privileges | None — file permissions only | Per-user grants |

> Tip: If your application supports both, choose SQLite for small, single-user, or embedded deployments. Choose MySQL for anything with multiple concurrent writers or multiple users.


What the Page Shows

| Field / Column | Description |
|---|---|
| Domain | The hosting account/domain the SQLite database belongs to |
| Name | The database file name (e.g., app.db, blog.sqlite) |
| Search | Filter the list of existing databases |
| Create | Create a new SQLite database |
| Actions | Delete the database file |

> Tip: The database file is created inside the account's home directory — usually in the domain's document root or in a dedicated data folder. Verify the location before creating.


How to Create an SQLite Database

Via the Admin Panel

  1. Log in to the GoAdmio Admin Panel (or User Panel).
  2. Navigate to Databases → SQLite.
  3. Select the Domain.
  4. Enter a Name for the database (e.g., app.db, blog.sqlite).
  5. Click Create.
The database file is created. You can now point your application at it by its full path.

Via CLI

SQLite databases are just files, so you can create one from the shell:

```bash

Create an empty SQLite database file


sqlite3 /home/<user>/www/<domain>/app.db "VACUUM;"

Or simply create a file the application will initialize

touch /home/<user>/www/<domain>/app.db
↑