Why store markdown version in 'post_content_formatted' column in DB?

  • Aahan Krish

    (@aahan)


    12 years, 4 months ago

    Hello Matt,

    From the looks of it, if I am not wrong, Markdown on Save Improved will soon make its way into Jetpack. It’s probably the one being used on WordPress.com as well.

    But the problem remains. Certain edits (e.g. ‘Quick Edit’) delete the Markdown version of the post stored in post_content_filtered column in the database.

    I see that it’s the intended behavior of post_content_filtered column, but in that case why use it at all? Why not some other column, that can store the Markdown version permanently? (Is it because, using any other column would make it difficult to replace Markdown/HTML in the editor when editing?)

    Do you have any plans to “fix” this behavior?

    http://wordpress.org/plugins/markdown-on-save-improved/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Matt Wiebe

    (@mattwiebe)

    12 years, 4 months ago

    > From the looks of it, if I am not wrong, Markdown on Save Improved will soon make its way into Jetpack. It’s probably the one being used on WordPress.com as well.

    Well yeah, I wrote the WP.com version, so there are definite similarities between that and MoSI. One of the differences is that WP.com Markdown is per-site rather than per-post, which in that case should eliminate the bug you’re describing.

    If you have any other bugs where the Markdown content is deleted, please describe in detail. I can’t guarantee that I’ll fix anything, since this plugin will be deprecated in favour of Jetpack Markdown. I’ll put a migration plan in place as well.

    Thread Starter Aahan Krish

    (@aahan)

    12 years, 4 months ago

    One of the differences is that WP.com Markdown is per-site rather than per-post, which in that case should eliminate the bug you’re describing.

    Actually the issue persists on WordPress.com, which is why I was kinda worried.

    If you have any other bugs where the Markdown content is deleted, please describe in detail.

    I thought you were aware of this, which is why the lack of much detail.

    Anyway, I noticed that the markdown content stored in post_content_filtered gets deleted (i.e. when you edit a post you see HTML instead of Markdown) when:

    • you make changes to a post (title, tags, categories, etc.) using the ‘Quick Edit’ option in the All Posts listing screen (edit.php?)
    • you do bulk edits to posts
    • you switch between revisions of a post
    • a scheduled post is (automatically) published
    • a post is saved from an external editor (i.e. not the WordPress post editor)

    These are the cases I noticed, and there may be more, which is why I think post_content_filtered is a bad place to store Markdown content which we want to be available at all times.

    I can’t guarantee that I’ll fix anything, since this plugin will be deprecated in favour of Jetpack Markdown.

    Will be waiting, thank you! 🙂

    Related: http://wordpress.stackexchange.com/q/113387/10691

    leucome

    (@leucome)

    12 years, 2 months ago

    I also thought that may be a good idea to store it somewhere more permanent.

    leucome

    (@leucome)

    12 years, 2 months ago

    Maybe even a storage for each revision . So we can recover the markdown at same time.

    Anonymous User 6386592

    (@anonymized-6386592)

    12 years, 1 month ago

    Any update on this? It seems WordPress.com is still broken.

    Plugin Author Matt Wiebe

    (@mattwiebe)

    12 years, 1 month ago

    If something is broken on WordPress.com, please report it there. 🙂

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Why store markdown version in 'post_content_formatted' column in DB?’ is closed to new replies.

Tags