Ghost Release: 1.22.1

TL;DR

Ghost 1.22.1: Migration Script Performance Boost

This minor release significantly improves the performance of the 1.22 migration script, reducing migration time by approximately 80-85%. It also fixes an edge case where invalid author IDs in posts could cause duplicate author relations. These improvements are particularly important for larger Ghost installations with many posts.

Highlight of the Release

• Migration script performance improved by ~80-85% (from ~1 minute to ~10 seconds for 1500 posts)
• Fixed issue with duplicate author relations when posts had invalid author IDs
• Improved data integrity by properly handling edge cases with invalid author data

Migration Guide

No specific migration steps are required for this release. The improvements are automatically applied when upgrading from a version prior to 1.22.0 to version 1.22.1.

If you're upgrading from a version before 1.22.0, you'll benefit from the improved migration script performance automatically.

Upgrade Recommendations

This release is recommended for all users currently on Ghost 1.22.0, especially those with larger blogs containing many posts.

If you haven't yet upgraded to Ghost 1.22.x, it's recommended to skip 1.22.0 and upgrade directly to 1.22.1 to benefit from the improved migration performance.

The upgrade process follows the standard Ghost update procedure and should be straightforward with no additional steps required.

Bug Fixes

Fixed Migration Script Issues

• Fixed an issue where the migration script would create duplicate post-author relations when a post had an invalid author ID
• Improved handling of edge cases by updating posts with invalid author IDs to use the site owner's ID instead
• Ensured proper data integrity during the migration process

New Features

No new features were added in this release. This is a maintenance release focused on performance improvements and bug fixes for the migration script.

Security Updates

No security fixes were included in this release.

Performance Improvements

Migration Script Performance Boost

• Dramatically improved the performance of the 1.22 migration script by optimizing how posts_authors relations are inserted
• Used Knex batch operations for more efficient database operations
• Reduced migration time by approximately 80-85%:
  • Before: ~1 minute for 1500 posts
  • After: ~10 seconds for 1500 posts
• This improvement is especially significant for larger Ghost installations with many posts

Impact Summary

This release significantly improves the performance of the database migration script introduced in Ghost 1.22.0. For larger Ghost installations with many posts, the migration time is reduced by approximately 80-85% (from about 1 minute to about 10 seconds for 1500 posts).

Additionally, it fixes an edge case where posts with invalid author IDs could result in duplicate author relations being created during migration. The fix ensures data integrity by properly handling these edge cases.

While this release doesn't introduce new features, the performance improvements and bug fixes make it an important update for anyone running or planning to upgrade to Ghost 1.22.x, especially for larger blogs where the migration performance gains will be most noticeable.

Full Release Notes