Download the PHP package keboola/php-csv-db-import without Composer
On this page you can find all versions of the php package keboola/php-csv-db-import. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download keboola/php-csv-db-import
More information about keboola/php-csv-db-import
Files in keboola/php-csv-db-import
Download keboola/php-csv-db-import
More information about keboola/php-csv-db-import
Files in keboola/php-csv-db-import
Vendor keboola
Package php-csv-db-import
Short Description Handling of large bulk data into database tables.
License MIT
Package php-csv-db-import
Short Description Handling of large bulk data into database tables.
License MIT
Please rate this library. Is it a good library?
Informations about the package php-csv-db-import
Keboola Database table importer
Handling of large bulk data into database tables.
Supported engines:
AWS Redshift
,Snowflake
- Load data from CSV stored in AWS S3
- Load data from another Redshift table in same database
Features
- Full load - destination table is truncated before load
- Incremental load - data are merged
- Primary key dedup for all engines
- Convert empty values to
NULL
(usingconvertEmptyValuesToNull
option)
Development
Preparation
- Create AWS S3 bucket and IAM user using
aws-services.json
cloudformation template. - Create Redshift cluster
- Download Snowflake driver (.deb) and place it into root of repository (
./snowflake-odbc.deb
) - Create
.env
file. Use output ofaws-services
cloudfront stack to fill the variables and your Redshift credentials.
Upload test fixtures to S3:
Redshift settings
User and database are required for tests. You can create them:
Snowflake settings
Role, user, database and warehouse are required for tests. You can create them:
Tests Execution
Run tests with following command.
Redshift and S3 credentials have to be provided.
All versions of php-csv-db-import with dependencies
PHP Build Version
Package Version
Requires
php Version
^7.4|^8
keboola/csv Version ^1.1
tracy/tracy Version ^2.3
aws/aws-sdk-php Version ^3.11
keboola/csv Version ^1.1
tracy/tracy Version ^2.3
aws/aws-sdk-php Version ^3.11
The package keboola/php-csv-db-import contains the following files
Loading the files please wait ....