1.40.0.7775 Database Changes?

General Discussions
1

Hi.

I saw the warning on the release notes for those on the beta pass you just published @drzoidberg33 . Could you or someone from the team elaborate on the database changes? I’m specifically interested in knowing whether there were changes to:

  • media_items table
  • taggings table
  • tags table
  • fts4_tag_titles_after_insert_icu trigger
  • fts4_tag_titles_before_delete_icu trigger

Thanks.

2

We’ve changed the format of the extra_data columns and it affects all tables with this column.

Newer versions of SQLite support a JSON data type and we’ve converted the data in this column to utilize this as it’s perfectly suited to the type of data stored in there. This is also the reason why it’s incompatible with old PMS version which don’t have the updated SQLite library.

3

Thanks. When I install it I’ll ask if I have any further questions about it, as it seems I’m using the extra_data field from the tags table.

4

Does it affect how fast the data is read and if it will be visible in the everyday usage of plex?

5

No, but it will help going forward with further database improvements we will be implementing.

2 Likes
6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.