0
I Use This!
Low Activity
Analyzed about 18 hours ago. based on code collected 2 days ago.

Project Summary

Loading data into PostgreSQL

pgloader is a data loading tool for PostgreSQL, using the COPY command.

Its main avantage over just using COPY or \copy and over using a Foreign Data Wrapper is the transaction behaviour, where pgloader will keep a separate file of rejected data and 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 bulk load for the whole table.

pgloader also implements data reformating, the main example of that being a transformation from MySQL dates 0000-00-00 and 0000-00-00 00:00:00 to PostgreSQL NULL value (because our calendar never had a year zero).

Tags

copy csv data database dbf geolite import load loading migration mysql postgresql sqlite sqlloader

In a Nutshell, pgloader...

Quick Reference

Project Security

Vulnerabilities per Version ( last 10 releases )

There are no reported vulnerabilities

Project Vulnerability Report

Security Confidence Index

Poor security track-record
Favorable security track-record

Vulnerability Exposure Index

Many reported vulnerabilities
Few reported vulnerabilities

Did You Know...

  • ...
    use of OSS increased in 65% of companies in 2016
  • ...
    you can subscribe to e-mail newsletters to receive update from the Open Hub blog
  • ...
    in 2016, 47% of companies did not have formal process in place to track OS code
  • ...
    by exploring contributors within projects, you can view details on every commit they have made to that project
About Project Security

Languages

SQL
51%
Lisp
30%
Clojure
16%
8 Other
3%

30 Day Summary

Oct 21 2026 — Nov 20 2026

12 Month Summary

Nov 20 2025 — Nov 20 2026
  • 59 Commits
    Up + 56 (1866%) from previous 12 months
  • 6 Contributors
    Up + 4 (200%) from previous 12 months