PostgreSQL Migrator 1.0: Moving Fast from Oracle and MySQL to PostgreSQL (blog.dalibo.com) 4 points by bersace 2d ago ↗ HN
[–] nohuman-labs 2d ago ↗ I wonder if this tool can support migration without downtime, data increase continuously [–] bersace 2d ago ↗ Integration with debezium is a planned feature.
[–] quietraster 2d ago ↗ migration tooling like this can remove a lot of quiet risk. which mysql edge case was hardest? [–] bersace 2d ago ↗ mysql accepts utf-8 in latin-1 varchar, bad dates, etc. mysql is actually a fractal of bad design for data integrity.For SQL syntax, using bare strings as identifier may be a nightmare: `SELECT 1 'int'` is a column named int.
[–] bersace 2d ago ↗ mysql accepts utf-8 in latin-1 varchar, bad dates, etc. mysql is actually a fractal of bad design for data integrity.For SQL syntax, using bare strings as identifier may be a nightmare: `SELECT 1 'int'` is a column named int.
5 comments
[ 0.60 ms ] story [ 11.5 ms ] threadFor SQL syntax, using bare strings as identifier may be a nightmare: `SELECT 1 'int'` is a column named int.