Created attachment 182435 [details] pgloader port shar file Pgloader loads data into PostgreSQL using the COPY streaming protocol,and doing so with separate threads for reading and writing data.Asynchronous IO,compiled to the metal programming language. pgloader knows how to read data from MySQL,SQLite or dBase databases,and knows how to discover the schema and properly cast data types over.It also knows how to read CSV files in several definitions of CSV,and fixed columns files. WWW: http://pgloader.io
Created attachment 182680 [details] v2 v1 depend sbcl which do not support multi-thread for default build.The upstream author advice to use ccl which has multi-thread support and has more efficiently garbage collection,see: https://github.com/dimitri/pgloader/issues/551
Created attachment 182794 [details] v3,add man doc Add man file for pgloader
Created attachment 182960 [details] pgloader3.shar v4 v4，replace ${MV} with ${INSTALL_PROGRAM}
Created attachment 183350 [details] pglader3.shar v5: 1.remove do-build 2.make ccl do not use /root/.cache dir now portlint clean poudriere testport pass.
New patch move to here for review: https://reviews.freebsd.org/D11212
ping
Assignee timeout. Give back to the pool.
hi @tz , this is a very useful tool , please take it at your convenience.
Hello Jov, version 3.4.1 was released last week. Do you mind to update your PR? Also: there is already databases/pgloader with version 2.3.1. After looking into the GitHub account of the project it seems, that the 2.x branch got its last change five years before today. :D So i would prefer to see an update of the current port instead of creating a new one. I couldn't find any information about current support of 2.x, but i assume there isn't any. Or do you have other reasons to choose a new port over an update? Greetings, Torsten
Created attachment 184291 [details] pgloader3.shar update to 3.4.1
(In reply to Torsten Zuehlsdorff from comment #9) I have updated this PR to 3.4.1. pgloader3 is not compatible with pgloader2. While pgloader 2.x was written in Python years ago, the author rewrites the pgloader 3.x with common lisp recently. The concept and configuration of pgloader3 are far more different with pgloader2.End user needs to learn the new usage and rewrite and test the configuration before the update. There may be someone still using pgloader2, I do not want to break their work and make them unhappy for this POLA violation. Any idea？
This seems reasonable enough - even if pgloader2 isn't develop anymore its still usable. In this case we will need to add PKGNAMESUFFIX for differentiation between the ports. Also i looked at your patches, especially the Makefile patch. Wouldn't it be cleaner to patch out the "clones" block instead of out-commenting each clone?
Created attachment 184338 [details] pgloader3.shar 1.use PKGNAMESUFFIX = 3 2.make the patch of Makefile simple. Make no target depends on clones, I think this patch is smaller than comment out the "clones" block.
This looks fine on a short glance. I will have time in the beginning of the next week to commit it! :)
(In reply to Torsten Zuehlsdorff from comment #14) Thanks!
Hi Torsten, please have a look if you have time:)
A commit references this bug: Author: tz Date: Mon Aug 7 13:46:51 UTC 2017 New revision: 447494 URL: https://svnweb.freebsd.org/changeset/ports/447494 Log: New port: databases/pgloader3 Pgloader loads data into PostgreSQL using the COPY streaming protocol,and doing so with separate threads for reading and writing data.Asynchronous IO,compiled to the metal programming language. pgloader knows how to read data from MySQL,SQLite or dBase databases,and knows how to discover the schema and properly cast data types over.It also knows how to read CSV files in several definitions of CSV,and fixed columns files. WWW: http://pgloader.io PR: 219165 Submitted by: Jov <amutu@amutu.com> Changes: head/databases/Makefile head/databases/pgloader3/ head/databases/pgloader3/Makefile head/databases/pgloader3/distinfo head/databases/pgloader3/files/ head/databases/pgloader3/files/patch-Makefile head/databases/pgloader3/files/patch-pgloader__wrapper.sh head/databases/pgloader3/pkg-descr
Finally. I'm sorry it took me so long.