Pg Loader is a tool that can be used to move your data to PostgreSQL, however, it's not perfect, but can work well in some cases. It's worth looking at to see if it's the direction you want to go. - Source: dev.to / 7 months ago
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 / about 1 year ago
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 / about 1 year ago
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 2 years ago
I would warmly recommend https://pgloader.io but, unfortunately, the Oracle support is still in need of a sponsor :-). Source: over 2 years ago
Https://pgloader.io/ There's been a great tool available for this for many years. Source: over 2 years ago
If you work with postgres, use pgloader. Source: over 2 years ago
Awesome! https://pgloader.io/ can do it in the other direction. - Source: Hacker News / almost 3 years ago
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 / about 3 years ago
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 / over 3 years ago
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 4 years ago
Btw, pgloader works well for these kind of work (importing messy csv or stuff). Source: almost 4 years ago
Do you know an article comparing PGLoader to other products?
Suggest a link to a post with product alternatives.
This is an informative page about PGLoader. You can review and discuss the product here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.