Revisions in Ghost

Article History/Revisions in Ghost are only partially implemented. Here is a way to access the 10 revisions that are currently stored in the SQLite database . . .

It appears that article history/revisions are not a priority at this point for the core development team.

As a front-ender, this has left me a bit uneasy. Sometimes I need to be able to go back and retrieve prior versions of my posts and pages in Ghost. Here is one way to do that if you can access your Ghost files through a cPanel File Manager.

First, here is a screenie from the Ghost Forum Post . . .

https://forum.ghost.org/t/article-history-revisions/2892/3

To figure this out, I first created 10 versions of a new post Jen's First Post. I re-saved the post 10 times, each time after adding "Revision (number)."  . . .

Second, in my cPanel File Manager I navigated to the location of the SQLite database generated by Ghost ghost-local.db under /content/data/ and downloaded that file to my computer . . .

Third I uploaded that ghost-local.db file on the webpage at https://inloop.github.io/sqlite-viewer/ . . .

Then, where the drop-down selector at the top of the page showed actions (12 rows) . . .

I clicked that, scrolled down through the items and selected mobiledoc_revisions (10 rows)

The two columns of interest to me are mobiledoc and created_at which contain the contents of each revision and the date/timestamp showing when each revision was saved.

Another method is provided here:

Reverting to previous post revision in Ghost using SQL
Ghost 5.2 stores the last 10 revisions of blog posts in the database, but currently there’s no interface to revert to a prior version using the web interface. Here’s how you can restore a previous revision if it’s not too later. What to do if you need to revert