Personal self hosted notes and event logger using PHP and SQLite

Made a quick personal notes and event logger in my spare time to self host. Online services close accounts all the time for no reason and people lose their data so I decided to make something easy to make and use. Just remember to create regular backup of the SQLite database file. If you need to delete and recreate a new fresh SQLite database file run setup.php file again. View the setup.php file once in your web browser so the setup can create a login password and after that open the file setup.php in your ftp server and view the password.

Notes

Requires PHP, SQLite and a web server.

Changelog:
[2026-06-21] Added relative date and time to timestamp

Made for local self hosting only, not for public Internet!

Download

Screenshot

Personal Events Screenshot

Template source:

Related: Personal Self Hosted Notes Web App Script Using PHP, SQLite and TinyMCE

Let me know if you have any comments or if there is any error in this guide.

## Disclaimer

The software provided in this repository is for educational and informational purposes only. Under no circumstances shall the author or contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages arising out of the use or inability to use this software. The author will not be liable for any special, incidental, consequential or indirect damages due to loss of data or any other reason.