@snder convert what exactly? The database content itself or the SQL queries that create and use the data?
Well, I’ve migrated PixFed from YunoHost to a stand-alone but YunoHost uses Postgres for db but there are many issues with Postgres and PixelFed so I want to export the Postgres database (tables and content) and import it in MySQL
@snder is pixelfed compatible with both backends as-is?
He probably isnt using a database abstraction layer. Usually if you do then you can switch to any database under the sun with little issue and more or less the same feature set.
I think pizxelfed is written in PHP which is notorious among its programmers (not saying this is the case with pizelfed) to just skip the abstraction layer all together and code raw SQL. Presuming that is the case this is usually the result, support for just one database and if any other databases are supported the feature set can often lag if it works at all.
That could be, it's written in PHP Laravel indeed
https://pixfed.com - my instance
https://github.com/pixelfed/pixelfed -- the official repo
Ahh.. That's what I also came up with indeed. Maybe just wait for @dansup to fix the Postgres backend then
@freemo