
Ghost blog with SQLite — lightweight, no MySQL needed.

A lightweight Ghost deployment using SQLite instead of MySQL. Ideal for personal blogs, small publications, or servers with limited resources (e.g. 2GB RAM). Uses significantly less memory than the standard Ghost template.
Ghost is a powerful app for professional publishers to create, share, and grow a business around their content. It comes with modern tools to build a website, publish content, send newsletters & offer paid subscriptions to members.
https://<your-domain>/ghost.https://<your-domain>.Run the following command in your Ghost service (for how to run commands, see this documentation):
ghost config url https://your-new-domain
Then, restart your Ghost service.
To enable email functionality for member invitations and notifications, configure the mail environment variables in your Ghost service:
mail__transport: Email service (e.g., SMTP, Mailgun, SendGrid)mail__options__service: Service name (e.g., Gmail, Mailgun)mail__options__auth__user: Your email usernamemail__options__auth__pass: Your email password or API keyTo configure newsletter delivery:
https://<your-domain>/ghostIf you forgot your Ghost admin password, you can reset it by running the following command in your Ghost service:
cd /var/lib/ghost && sqlite3 content/data/ghost-local.db "UPDATE users SET password='\$2a\$12\$1hiHKBSMnfHOjS0BQ227sO38Y9JpxnNMKutH573F8zMvkRljPFyGe' WHERE email = 'your-email@example.com';"
Replace your-email@example.com with the email address you use to log in. The password will be reset to password123.
If you want to use a different password, you can generate a bcrypt hash using this tool: Bcrypt Generator.