Stream archive: Recording video for transaction bulk insert with sqlx rust (2023-10-02 afternoon)
1We finish the article and record a lesson for bulk importing using transactions in sqlx in Rust.
Links
SQLx FAQ: [https://github.com/launchbadge/sqlx/blob/main/FAQ.md#how-can-i-bind-an-array-to-a-values-clause-how-can-i-do-bulk-inserts](https://github.com/launchbadge/sqlx/blob/main/FAQ.md#how-can-i-bind-an-array-to-a-values-clause-how-can-i-do-bulk-inserts)
Postgres copy: [https://www.postgresql.org/docs/16/sql-copy.html](https://www.postgresql.org/docs/16/sql-copy.html)
Postgres unnest: [https://www.postgresql.org/docs/current/functions-array.html#id-1.5.8.25.6.2.2.19.1.1.1](https://www.postgresql.org/docs/current/functions-array.html#id-1.5.8.25.6.2.2.19.1.1.1)
Postgres populate (where it says copy and prepared transaction are the fastest): [https://www.postgresql.org/docs/current/populate.html](https://www.postgresql.org/docs/current/populate.html)
Postgres prepared transaction: [https://www.postgresql.org/docs/current/sql-prepare-transaction.html](https://www.postgresql.org/docs/current/sql-prepare-transaction.html)
eyre crate: [https://crates.io/crates/eyre](https://crates.io/crates/eyre)
SQLx discussion of why we need &mut *: [https://github.com/launchbadge/sqlx/issues/2606](https://github.com/launchbadge/sqlx/issues/2606)
Tokio tutorial: [https://tokio.rs/tokio/tutorial](https://tokio.rs/tokio/tutorial) -- Watch live at https://www.twitch.tv/brookzerker