{"repo":"dimitri/pgloader","free":true,"listed":false,"github":"https://github.com/dimitri/pgloader","clone":"git clone https://github.com/dimitri/pgloader.git","description":"Migrate to PostgreSQL in a single command!","language":"Common Lisp","stars":6498,"topics":["postgresql","migration","mysql","mssql","sqlite","common-lisp","pgloader","sbcl","clozure-cl","database"],"license":null,"category":"databases-storage","readme_excerpt":"pgloader pgloader is a data loading tool for PostgreSQL, using the COPY command. Its main advantage over just using COPY or \\copy , and over using a Foreign Data Wrapper , is its transaction behaviour, where pgloader will keep a separate file of rejected data, but continue trying to copy good data in your database. The default PostgreSQL behaviour is transactional, which means that any erroneous line in the input data (file or remote database) will stop the entire bulk load for the table. pgloader also implements data reformatting, a typical example of that being the transformation of MySQL datestamps 0000-00-00 and 0000-00-00 00:00:00 to PostgreSQL NULL value (because our calendar never had a year zero ). Version 4 — Clojure/JVM rewrite pgloader v4 is a full rewrite in Clojure, distributed as a single self-contained JAR requiring Java 21 or later . It is a drop-in replacement for v3 and accepts the same .load file syntax and command-line flags. Key improvements over v3: - Single JAR — no native dependencies, no SBCL, no shared libraries - JDBC connection strings — use jdbc:mysql:// , jdbc:postgresql:// , jdbc:sqlserver:// etc. everywhere; driver-specific parameters pass through unchanged - Java heap — no more Common Lisp heap exhaustion on large migrations; tune with standard -Xmx JVM flag - SSL via URI — use ?sslmode=require / ?sslmode=disable in the connection string instead of --no-ssl-cert-verification Documentation Full documentation is available at https://pgloader.rea","default_branch":null,"files":null,"tree":[],"storefront":"/r/dimitri","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dimitri/pgloader/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}