Hacker News new | ask | show | jobs
by mlinster 154 days ago
Unless you use stored procedures in MySQL, recreating the tables and schemas in Postgres should be straightforward. Postgres now offers a 'MySQL Adapter', a.k.a. Foreign Data Wrapper (https://github.com/EnterpriseDB/mysql_fdw), that makes it straightforward to load data from MySQL into Postgres.

I know you mentioned that all you know about databases is following instructions, but maybe the folks at EDB or Percona can give you a hand.

Postgres will be around for a long time, and I think it's pretty obvious that MySQL won't.

1 comments

I'll read up on that, thanks!