phpSQLiteCMS

phpSQLiteCMS is a simple and lightweight open source CMS based on PHP and SQLite. As SQLite is file-based, it just runs "out of the box" without installation.

Contributions

All contributions and PRs are welcome. Be mindful of the goals and roadmap below.

Goals

• Fix all current warnings and errors
• Fix all security issues
• Simplify the codebase

Roadmap

• Remove PostGRE SQL support
• Remove MySQL support
• Remove caching (SQLite3+ is fast anyway, and caching should be server-side)
• Add "Copy URL" feature to File Manager
• Update all code to PHP 7+ standards
• Update all code to PSR-12 standards

System requirements

• Apache webserver with mod_rewrite and .htaccess file support enabled
• PHP 7+
• SQLite 3+

Installation

1. Load up the script files to your server
2. Depending on your server configuration you may need to change the write permissions of the following files/directories:
   • cms/data - directory of the SQLite database files, needs to be writable by the webserver
   • content.sqlite, entries.sqlite and userdata.sqlite - SQLite database files, need to be writable by the webserver
   • cms/cache - cache directory, needs to be writable if you want to use the caching feature
   • cms/media and cms/files - need to be writable if you want to use the file uploader
3. Ready! You should now be able to access the index page by browsing to the address you uploaded phpSQLiteCMS (e.g. https://example.org/path/to/phpsqlitecms/). To administrate the page, go to https://example.org/path/to/phpsqlitecms/cms/. The default admin userdata is: username: admin, password: admin.