WordPress is normally installed with MySQL or MariaDB, but in some smaller projects that can feel like overkill. SQLite is a lightweight embedded database system that stores data in a single file and can be enough for the right kind of WordPress site.
How to install WordPress with SQLite
WordPress does not support SQLite natively, so the usual approach is to use a SQLite integration plugin or compatibility layer during setup. After uploading WordPress, place the required SQLite drop-in or plugin files in the correct location and run the normal installation process.
The overall workflow is usually:
- Download and upload WordPress.
- Add the SQLite compatibility plugin or drop-in.
- Make sure the database file location is writable.
- Run the standard WordPress install wizard.
The advantages of installing WordPress with SQLite
The biggest benefit is simplicity. SQLite removes the need to run and manage a separate database server. That can make local development, demos, prototypes, or very small content sites easier to maintain.
SQLite can also be attractive in environments where a full MySQL service is not available or feels unnecessarily heavy.
When SQLite makes sense
SQLite is a practical option for small sites, development environments, temporary projects, or situations where you want the simplest possible deployment. It is generally not the first choice for larger production sites with high concurrency or heavier write activity.
If the site is expected to grow significantly, planning for MySQL or MariaDB from the beginning is still the safer long-term approach.
