SQG - SQL to code generator, can generate typesafe PgBulkInsert code

[uwemaurer]

Hi,

I made a SQL to code generator, which can work with multiple databases and languages.

https://github.com/sqg-dev/sqg/

It can produce Java code for Postgres and one of the features is a typesafe bulk insert function (powered by PgBulkInsert)

A benchmark of the various Java methods to insert data into Postgres showed that (unsurprisingly) the fastest method was binary COPY using PgBulkInsert:

https://sqg.dev/blog/java-postgres-insert-benchmark/

[bytefish]

Thanks for the Benchmarks and adding support for PgBulkInsert. And the recommendation for it. 🤌 I think the recent API updates really make it easier to generate mappings, I am very, very happy to see them in action. 🥹

Is there anything you’d like to see in the library?

Just a minor addition. You can make the code more readable by using a static import:

PgBulkInsert/PgBulkInsert/src/test/java/de/bytefish/pgbulkinsert/test/IntegrationTest.java

Line 27 in 43f6435

import static de.bytefish.pgbulkinsert.PgBulkInsert.*;