Skip to content

Releases: chop-dbhi/sql-importer

Fix missing CSV delimiter

27 Sep 14:20
Compare
Choose a tag to compare
Pass in CSV reader in order to set delimiter

Signed-off-by: Byron Ruth <b@devel.io>

Ignore drop table or view errors

19 Sep 16:29
Compare
Choose a tag to compare
Ignore errors during drop table or view

Other than a connection issue, the only error would be
the view or table does not exist.

Signed-off-by: Byron Ruth <b@devel.io>

1.2.3: Add method to initialize fields in profiler

19 Sep 14:45
Compare
Choose a tag to compare
This is only required if there are no data records in the CSV file.

Signed-off-by: Byron Ruth <b@devel.io>

Increase partition size, skip view creation if too wide

12 Sep 17:46
Compare
Choose a tag to compare
Increase max column partition size

Signed-off-by: Byron Ruth <b@devel.io>

Skip unique indexes on text columns

12 Sep 14:53
Compare
Choose a tag to compare
Skip unique indexes for text column types

Signed-off-by: Byron Ruth <b@devel.io>

Add auto-split support

12 Sep 14:05
Compare
Choose a tag to compare
Implement auto-split for very wide tables

Postgres has an upper limit of 1600 columns per table, but a CSV file
can theoretically have any number. This feature implicitly partitions
the columns into separate tables and creates a view on top of it to
join the data back together.

Signed-off-by: Byron Ruth <b@devel.io>

Support really long lines in CSV

08 Sep 21:05
Compare
Choose a tag to compare
Increase max scanner buffer size

Signed-off-by: Byron Ruth <b@devel.io>

Bulk loading

06 Sep 19:28
Compare
Choose a tag to compare
Change repo to library, move command to cmd/sql-importer

In addition, support for a bulk load has been added. The sql-importer
program can take a directory name and recursively imports CSV files
using the parent directory as the schema name.

Signed-off-by: Byron Ruth <b@devel.io>

1.0.0 Final

05 Sep 14:56
Compare
Choose a tag to compare
Add files for creating releases

Signed-off-by: Byron Ruth <b@devel.io>