Quick steps to change URL scheme in a self-deployed Ghose blog:
- Open DB in CLI:
# sqlite3 content/data/ghost.db
- Set the UX properties (optional):
sqlite> .headers ON
&sqlite> .mode column
- Check the settings table (look for key "permalinks"):
sqlite> SELECT * FROM settings;
- Change the URL scheme:
sqlite> update settings set value = '/:id/' where key = 'permalinks';
- Quit database (
sqlite> .quit
) & restart ghost server
N.B: year, month, day, slug, id etc are valid keywords for configuring the URL (let me know if I've missed any).
Statutory Warning: if you're using different database, the steps are similar, but the commands will differ to achieve the same purpose. Also, I'm not to be blamed if you broke your thing while trying this out.