stream_to / copy operator #1411

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Closed

lacasaprivata2 opened this issue Aug 29, 2021 · 1 comment

lacasaprivata2 commented Aug 29, 2021

Hi there!

It seems as though many other libraries, in particular pqxx, implement the COPY operator through a stream_to interface

is there an equivalent in sqlx so that one can properly do batch insertions?

Collaborator

abonander commented Aug 30, 2021

Not yet. Discussion for such a feature already exists in #36 and a low-level interface has been implemented in #1345 so closing this as duplicate.

If you're on Postgres, you can use UNNEST for batch insertions which is pretty fast compared to executing a statement for each row; see our FAQ for details: https://github.com/launchbadge/sqlx/blob/master/FAQ.md#how-can-i-bind-an-array-to-a-values-clause-how-can-i-do-bulk-inserts

abonander closed this as completed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment