Ghost Release: 1.25.4

TL;DR

Ghost 1.25.4 brings significant improvements to the Koenig editor beta, adding rich-text caption support and fixing several critical bugs. This release also introduces hidden functionality for importing and exporting additional tables like clients and trusted domains, plus adds protection against SQLite3 database limitations for larger Ghost installations.

Highlight of the Release

• Rich-text formatting support in Koenig editor captions
• Automatic URL-to-embed card conversion for improved content creation
• New /image {url} slash command shortcut
• Hidden functionality to import/export additional database tables
• Protection against SQLite3 database limitations for large Ghost installations

Migration Guide

No migration steps are required for this update. The release is a standard minor version update that can be installed using your normal update process.

The new import/export functionality for additional tables is currently hidden and not officially announced, so no migration or changes to existing workflows are necessary unless you specifically want to use these features.

Upgrade Recommendations

This is a recommended update for all Ghost users, especially those who:

1. Use the Koenig editor beta and have experienced any of the fixed bugs
2. Manage larger Ghost installations with SQLite3 databases containing 1000+ posts
3. Need the ability to import/export client and trusted domain data

The update includes important bug fixes and performance improvements with no breaking changes, making it a safe upgrade for all installations.

Bug Fixes

Koenig Editor Fixes

• Fixed issue where cards were being lost on copy/paste operations when they immediately followed a list
• Fixed problem with duplicate images appearing when dropping an image file on an existing image card
• Resolved error that occurred when dropping an image before the editor had focus

Database Handling

• Added protection against "too many SQL variables" error in SQLite3 when handling large databases
• Implemented recursive query strategy with offset/limit for SQLite3 to prevent bootstrap failures when managing 1000+ posts

New Features

Koenig Editor Enhancements

• Rich-text caption support: Captions now support HTML formatting, allowing for more expressive image descriptions
• Auto-convert URLs: URLs pasted on blank lines are automatically converted to embed cards
• New slash command: Added support for /image {image url} shortcut in the slash menu

Import/Export Improvements (Hidden Features)

• Additional table export: Added option to export extra tables using include parameter (e.g., include=clients)
• Additional table import: Support for importing more tables including clients and trusted domains
• Duplicate protection: Added safeguards against duplicate trusted domains during imports

Security Updates

No specific security fixes were included in this release.

Performance Improvements

Database Optimization

• Implemented a recursive query strategy specifically for SQLite3 databases to handle large post collections
• This prevents the "too many SQL variables" error that previously occurred when Ghost tried to fetch all posts and relations for sites with more than 999 posts
• The optimization ensures the URL service can complete its bootstrap process even for larger Ghost installations

Impact Summary

Ghost 1.25.4 delivers meaningful improvements to the Koenig editor beta experience, making content creation more efficient and reliable. The rich-text caption support enhances the visual storytelling capabilities, while the automatic URL-to-embed conversion streamlines the workflow for adding external content.

Behind the scenes, this release addresses an important database limitation for larger Ghost installations using SQLite3, ensuring stable performance even with 1000+ posts. This fix prevents bootstrap failures that could previously occur during URL service initialization.

The addition of hidden functionality for importing and exporting additional tables (clients, trusted domains) lays groundwork for future features while providing advanced users with immediate access to these capabilities through the include parameter.

Overall, this release combines user-facing editor improvements with important technical enhancements that improve stability and expand Ghost's capabilities.

Full Release Notes