GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → ossc-db → Pg_bulkload

ossc-db / Pg_bulkload

Licence: other
High speed data loading utility for PostgreSQL

Programming Languages

c
50402 projects - #5 most used programming language

Labels

postgresql

Projects that are alternatives of or similar to Pg bulkload

Datoji
A tiny JSON storage service. Create, Read, Update, Delete and Search JSON data.
Stars: ✭ 222 (-5.53%)
Mutual labels:  postgresql
Activerecord Postgres enum
Integrate PostgreSQL's enum data type into ActiveRecord's schema and migrations.
Stars: ✭ 227 (-3.4%)
Mutual labels:  postgresql
Storagetapper
StorageTapper is a scalable realtime MySQL change data streaming, logical backup and logical replication service
Stars: ✭ 232 (-1.28%)
Mutual labels:  postgresql
Ledgersmb
Repository for the LedgerSMB project -- web app for accounting & ERP
Stars: ✭ 222 (-5.53%)
Mutual labels:  postgresql
Db
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Stars: ✭ 2,832 (+1105.11%)
Mutual labels:  postgresql
Pony
Pony Object Relational Mapper
Stars: ✭ 2,762 (+1075.32%)
Mutual labels:  postgresql
Piccolo
A fast, user friendly ORM and query builder which supports asyncio.
Stars: ✭ 219 (-6.81%)
Mutual labels:  postgresql
Django Migration Linter
🚀 Detect backward incompatible migrations for your django project
Stars: ✭ 231 (-1.7%)
Mutual labels:  postgresql
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
Stars: ✭ 15,083 (+6318.3%)
Mutual labels:  postgresql
Devops Bash Tools
550+ DevOps Bash Scripts - AWS, GCP, Kubernetes, Kafka, Docker, APIs, Hadoop, SQL, PostgreSQL, MySQL, Hive, Impala, Travis CI, Jenkins, Concourse, GitHub, GitLab, BitBucket, Azure DevOps, TeamCity, Spotify, MP3, LDAP, Code/Build Linting, pkg mgmt for Linux, Mac, Python, Perl, Ruby, NodeJS, Golang, Advanced dotfiles: .bashrc, .vimrc, .gitconfig, .screenrc, .tmux.conf, .psqlrc ...
Stars: ✭ 226 (-3.83%)
Mutual labels:  postgresql
Create Graphql Api
Set up a Typescript GraphQL API by running one command.
Stars: ✭ 223 (-5.11%)
Mutual labels:  postgresql
Notadd
A microservice development architecture based on nest.js. —— 基于 Nest.js 的微服务开发架构。
Stars: ✭ 2,556 (+987.66%)
Mutual labels:  postgresql
Mobilitydb
MobilityDB is a geospatial trajectory data management & analysis platform, built on PostgreSQL and PostGIS.
Stars: ✭ 229 (-2.55%)
Mutual labels:  postgresql
Pike
Generate CRUD gRPC backends from single YAML description.
Stars: ✭ 222 (-5.53%)
Mutual labels:  postgresql
Massive Js
A data mapper for Node.js and PostgreSQL.
Stars: ✭ 2,521 (+972.77%)
Mutual labels:  postgresql
Heidisql
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL and SQLite, written in Delphi
Stars: ✭ 2,864 (+1118.72%)
Mutual labels:  postgresql
Scany
Library for scanning data from a database into Go structs and more
Stars: ✭ 228 (-2.98%)
Mutual labels:  postgresql
Pguri
uri type for PostgreSQL
Stars: ✭ 235 (+0%)
Mutual labels:  postgresql
Sequelize Auto Migrations
Migration generator && runner for sequelize
Stars: ✭ 233 (-0.85%)
Mutual labels:  postgresql
Sqliterally
Lightweight SQL query builder
Stars: ✭ 231 (-1.7%)
Mutual labels:  postgresql
View All Similar Projects ➔

pg_bulkload

pg_bulkload is a high speed data loading tool for PostgreSQL.

pg_bulkload is designed to load huge amount of data to a database. You can load data to table bypassing PostgreSQL shared buffers.

pg_bulkload also has some ETL features; input data validation and data transformation.

Branches

  • master : branch for pg_bulkload 3.1 Build Status
  • VERSION3_2_DEV : branch for pg_bulkload 3.2 Build Status

How to use

pg_bulkload works with control file like below,

$ pg_bulkload sample_csv.ctl
NOTICE: BULK LOAD START
NOTICE: BULK LOAD END
	0 Rows skipped.
	8 Rows successfully loaded.
	0 Rows not loaded due to parse errors.
	0 Rows not loaded due to duplicate errors.
	0 Rows replaced with new rows.

See documentation about detail usage.

http://ossc-db.github.io/pg_bulkload/index.html

How to build and install from source code

Change directory into top directory of pg_bulkload sorce codes and run the below commands.

 $ make
 # make install

How to run regression tests

Start PostgreSQL server and run the below command.

 $ make installcheck
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].