Converting from MySQL to PostgreSQL

44 %
56 %
Information about Converting from MySQL to PostgreSQL

Published on March 12, 2014

Author: akmed13



How to convert from MySQL to PostgreSQL: discuss history of each, current status, when you might wish to convert, what might motivate you to convert, & how to do so. With references.

PostgreSQL John AshmeadMySQL

MySQL vs PostgreSQL • MySQL covered basics • But a bit flaky in practice, under load • Had looked at PostgreSQL before, but relooked • Others have had similar problems

• Clay tablets • For taxes (but you knew that) • The map replaces the territory The First Database

Size matters! • Ad hoc tools • SQLite • MySQL • PostgreSQL


MySQL History • Named after Widenius’s daughter ‘My’! • Version 5.0 with relational integrity, transactions, & stored procedures (i.e. real) in 2005 • Bought by Sun in 2008 • Eaten by Oracle in 2010 • Forks: MariaDB (by Widenius), Drizzle

PostgreSQL • Ingres • Postgres a seQUEL to Ingres • Postgres95 - released on web • Open source version 1996 • Has caught up with MySQL on speed & reliability, still ahead on features • MySQL is open source, PostgreSQL is open project

Decision Points • New Project • Organizational changes • Accumulated stress • Feature lust • Strategic planning

Why • Features: i.e. PostGIS, FDW, Stored procedure languages • Performance • Reliability • Plays nice with others • Others: culture, fear of Larry Ellison, kool-factor, …

MySQL Gotchas • Nulls->default • Case insensitivity • Select 1/0 -> Null • February 31st

Approachs • hack & go • pivot with frameworks • migration assistants • plan & persevere (step at a time) • halfway houses, i.e. with ODBC

Hack & go • Schema level • Data • Application level • Configuration level • Tools • Documentation • Culture

Pivot with a framework • SQL Alchemy on Python • Ruby on Rails/ ActiveRecord on Ruby • DBI on Perl • Pear DB on PHP

Migration Assistants

Plan & persevere • EnterpriseDB • Internal task force • Culture: desperate late night appeals for help often answered

Summary • PostgreSQL makes sense for new projects • For specific features • As operational core • Should be familiar with alternatives: relational, graph, noSQL, and so on.

Further information • • How_to_make_a_proper_migration_from_MySQL_to _PostgreSQL • postgresql • from-mysql-to-postgresql

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Converting from other Databases to ... - PostgreSQL wiki

Converting from other Databases to PostgreSQL. ... Conversion tool for migrating from MySQL to PostgreSQL by PostgreSQL Inc. Converting MySQL to ...
Read more

Convert / Sync from MySQL to PostgreSQL

MySQL to PostgreSQL database ... DBConvert and DBSync for MySQL and PostgreSQL are reliable database ... Improved engine allows converting large ...
Read more

PostgreSQL to MySQL - Intelligent Converters

PostgreSQL to MySQL; PostgreSQL to Oracle; ... PostgreSQL-to-MySQL is a program to migrate PostgreSQL databases to MySQL, MariaDB or Percona server.
Read more

MySQL to PostgreSQL -

PostgreSQL script file. MySQL to PostgreSQL converter allows users to migrate MySQL database into PostgreSQL format even when there is no connection to ...
Read more

PostgreSQL to MySQL Migration and Sync -

PostgreSQL to MySQL conversion and ... from MySQL to PostgreSQL, from MySQL to MySQL and from ... Improved engine allows converting large databases in ...
Read more

Re: Converting MySQL tinyint to PostgreSQL

... Converting MySQL tinyint to PostgreSQL. From: Martijn van Oosterhout To: Dawid Kuroczko Cc:
Read more

PostgreSQL: The world's most advanced open source database

The official site for PostgreSQL, the world's most advanced open source database. Skip site navigation (1) Skip section navigation (2) Search. Peripheral ...
Read more

Lightbox Technologies Inc - pg2mysql

Lightbox Technologies Inc. specializes in custom application development, web applications, web hosting, ... (PostgreSQL to MySQL Converter)
Read more

Converting MySQL Databases (MySQLToSQL)

Converting MySQL Databases (MySQLToSQL) ... Before converting objects, review the project conversion options in the Project Settings dialog box.
Read more