@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?
They do support it yes but there are many commands I can’t run with Postgres that do run with MySQL
@snder You can do the migration issue is there is more than one way to convert some things that might exist in postgresql and some things youd have to convert by hand (like ant PL/SQL). So in practice it likely wont be trivial.
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.
@freemo
That could be, it's written in PHP Laravel indeed
https://pixfed.com - my instance
https://github.com/pixelfed/pixelfed -- the official repo
@dansup