PGLoader Reviews and details

Social recommendations and mentions

• We need to talk about parentheses

  Examples (for Common Lisp, so not citing Emacs): reddit v1, Google's ITA Software that powers airfare search engines (Kayak, Orbitz…), Postgres' pgloader (http://pgloader.io/), which was re-written from Python to Common Lisp, Opus Modus for music composition, the Maxima CAS, PTC 3D designer CAD software (used by big brands worldwide), Grammarly, Mirai, the 3D editor that designed Gollum's face, the ScoreCloud app... - Source: Hacker News / 3 months ago

• We migrated our PostgreSQL database with 11 seconds downtime

  I worked on migrating our MySQL system to PostgreSQL using pgloader ( https://pgloader.io/ ). There were some hiccups, things that needed clarification in documentation, and some additional processes that needed to be done outside of the system to get everything we need in place, it was a amazing help. Not sure the project would've been possible without it. Data mapping from PostgreSQL to PostgreSQL as in the... - Source: Hacker News / 4 months ago

• Time For Me To Fly… To Render

  Initially, I started down the pgloader path, which seemed to be a common approach for the database conversion. However, using my M1-chip MacBook Pro led to some unexpected issues. Instead, I opted to use NMIG to convert MySQL to PostgreSQL. For more information, please check out the “Highlights From the Database Conversion” section below. - Source: dev.to / about 1 year ago

• What ETL tool you use with Postgres ?

  I would warmly recommend https://pgloader.io but, unfortunately, the Oracle support is still in need of a sponsor :-). Source: over 1 year ago

• Introducing pgsqlite, a pure python module for import sqlite into postgres

  Https://pgloader.io/ There's been a great tool available for this for many years. Source: over 1 year ago

• Could I slim this CSV to SQL code down at all?

  If you work with postgres, use pgloader. Source: almost 2 years ago

• Migrating from SQLite to PostgreSQL

  Awesome! https://pgloader.io/ can do it in the other direction. - Source: Hacker News / about 2 years ago

• In MySQL, never use “utf8”. Use “utf8mb4”

  Maybe this is a cynical take - but we used https://pgloader.io/ a few years ago to migrate to Postgres, and have never been happier. - Source: Hacker News / over 2 years ago

• Migrating Facebook to MySQL 8.0

  We also did a MySQL 5.7 to PG 9.6 migration (thanks to https://pgloader.io/) and we got some pretty immediate speed improvements (2-5x). We shot ourselves in the foot a few weeks later with some poorly written RLS policies, but it was overall a smooth experience. - Source: Hacker News / almost 3 years ago

• Data Migration for a Biotech Firm

  You didn't say whether the architecture and tools have been selected yet, but I recommend PostgreSQL, which supports Windows, and pgloader. A new paper about the latter has this blurb, which you may find useful:. Source: almost 3 years ago

• Fastest Way to Load Data Into PostgreSQL Using Python

  Btw, pgloader works well for these kind of work (importing messy csv or stuff). Source: about 3 years ago