UTF-8 problems with MySQL, not present in PostgreSQL about ttrss_ynh

[Josue-T]

Hello,

I don't really know about ttrss but there are also a discussion about nextcloud YunoHost-Apps/nextcloud_ynh#107

In my point of view it could be a good idea to migrate to postgresql, but I think in all case, the migration will be not easy.

[supermamie]

I'm not really sure a migration is possible (according to https://discourse.tt-rss.org/t/migration-from-mysql-to-postgresql/265/13 )
What can at least be done is that fresh installs use PostgreSQL, and already used installs stays with MySQL.

According to the linked thread, the only way to do this, without losing everything (but not keeping everything either) is to export the OPML, and export saved articles, then re-import them in another tt-rss.
I have no idea if there is an automatic way of doing this (I did it manually when I switched on my server, but it is still not a yunohost, I'm still testing on a VM)

[ericgaspar]

There is a branch for testing ttrss with PostgreSQL (there is no migration from MySQL. You may want to use a multi instance to keep your previous version of ttrss safe) https://github.com/YunoHost-Apps/ttrss_ynh/tree/PostgreSQL