Why did pgloader get so much faster?

Migrate from MySQL to PostgreSQL. In one command.

Given a MySQL connection string, pgloader query the catalogs to list your tables, constraints and indexes and know how to transform this schema into a PostgreSQL equivalent, applying advanced casting rules that you can edit in the command.

Migrate some tinyint to boolean and some others to smallint all from the same tool!

View details »

MySQL to PostgreSQL with Custom Type Casting

CSV data format

Load any CSV file. Real quick.

The current version of pgloader is up to ten times faster than the previous one. The new command syntax is really powerful, and as it's different enough from the previous version, pgloader includes a command line switch to upgrade your setup for you.

View details »

Transform your data. While streaming.

pgloader includes reformating modules allowing you to reformat your data, such as transforming a couple of integer columns into a single ip address, or a couple of floats into a single point. Of course, you can add any transformation you like and easily get to use it with pgloader loading your code!

View details »

Transform Data