There isn’t a ‘easy’ way to convert PostgreSQL to MySQL or is there?

Follow

@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

@freemo

They do support it yes but there are many commands I can’t run with Postgres that do run with MySQL

@freemo

@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.

Ahh.. That's what I also came up with indeed. Maybe just wait for @dansup to fix the Postgres backend then

@freemo

@snder

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.

@dansup

Sander is looking for a way to export #postgres #data and import into #Mysql easily

@freemo @snder

Sign in to participate in the conversation
CleverLibre Social

CleverLibre Social is an inclusive social instance for open discussion, learning, and community.
All cultures welcome.
Hate speech and harassment strictly forbidden.