Server Version#: 4.108.0
Player Version#:
Hi, I am using PMS’s built in Sqlite3 to clean up certain tags in my database. Is there a way to use regular expressions?
SQLite doesn’t support regex. The closest you can get is the LIKE syntax. See the docs for details.
Yes, I know that.
But with standard SQLite I can load a regexp-extension that supplies those capabilities. But this extension does not work with PMS. Are there any other options?
You can use standard sqlite as long as you aren’t interacting with the icu columns in the metadata_items table. These rely on code that is contained within PMS (effectively an extension) but most tables don’t rely on this.
Thanks. I will try that.
With icu you mean International Components for Unicode, right?
Well, it seems not only meta-data_items are affected. For instance, when I try to change a tag in the ‘tags’-table using plain sqlite3, I get
Error: near line xx: in prepare, unknown tokenizer: collating (1).
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
