Stream archive: Bulk inserting using transactions with SQLx (2023-10-02)

Channel:
United States Brooks Builds (brookzerker)
Subscribers:
8,090
Published on ● Video Link: https://www.youtube.com/watch?v=jyNwxM98W90


Duration: 1:46:21
93 views
5

We figure out how to implement bulk inserts using a transaction with SQLx.

Links

How to use a transaction as the executor in sqlx: [https://github.com/launchbadge/sqlx/issues/2606](https://github.com/launchbadge/sqlx/issues/2606)

Brooks Builds Axum course (not live yet): [https://learning.brooksbuilds.com/courses/3/access/10](https://learning.brooksbuilds.com/courses/3/access/10)

Postgres documentations on transactions: [https://www.postgresql.org/docs/current/tutorial-transactions.html](https://www.postgresql.org/docs/current/tutorial-transactions.html)

Postgres documentation on rollback: [https://www.postgresql.org/docs/16/sql-rollback.html](https://www.postgresql.org/docs/16/sql-rollback.html)

Postgres documentation on begin: [https://www.postgresql.org/docs/16/sql-begin.html](https://www.postgresql.org/docs/16/sql-begin.html)

Crust of Rust YouTube playlist (deep dive videos!): [https://www.youtube.com/playlist?list=PLqbS7AVVErFiWDOAVrPt7aYmnuuOLYvOa](https://www.youtube.com/playlist?list=PLqbS7AVVErFiWDOAVrPt7aYmnuuOLYvOa)

What the heck is the event loop anyways?: [https://www.youtube.com/watch?app=desktop&v=8aGhZQkoFbQ](https://www.youtube.com/watch?app=desktop&v=8aGhZQkoFbQ)

Reactor pattern: [https://en.wikipedia.org/wiki/Reactor_pattern](https://en.wikipedia.org/wiki/Reactor_pattern)

Tokio tutorial: [https://tokio.rs/tokio/tutorial](https://tokio.rs/tokio/tutorial) -- Watch live at https://www.twitch.tv/brookzerker



Other Videos By Brooks Builds (brookzerker)


2023-10-15Stream archive: Finishing article for SQLx Rust many to many joins (2023-10-09 afternoon)
2023-10-14Stream archive: experimenting with many to many join using sqlx rust (2023-10-09)
2023-10-13Stream archive: sqlx rust seeding, offline mode, joins (2023-10-06 afternoon)
2023-10-12Stream archive: finished sqlx Rust migration article and recording migration video (2023-10-06)
2023-10-11Stream archive: Exploring how we might seed with SQLx (2023-10-05)
2023-10-10Stream archive: experimenting with how to seed with SQLx Rust (2023-10-04 afternoon)
2023-10-09Stream archive: Writing article for sqlx rust migrations (2023-10-04)
2023-10-08Stream archive: Recording SQLx Rust bulk insert with UNNEST (2023-10-03 afternoon)
2023-10-07Stream archive: Finishing SQLx Rust article for bulk inserts with UNNEST (2023-10-03)
2023-10-06Stream archive: Recording video for transaction bulk insert with sqlx rust (2023-10-02 afternoon)
2023-10-04Stream archive: Bulk inserting using transactions with SQLx (2023-10-02)
2023-10-03Stream archive: Recording lesson for SQLx and investigating bulk inserts (2023-09-29)
2023-10-02Stream archive: CRUD with Rust + Postgres (2023-09-29)
2023-10-01Stream archive: Using SQLx Rust to insert into a Postgres Database (2023-09-28 evening)
2023-09-30Stream archive: Which SQLx Rust function or macro should we use? (2023-09-28)
2023-09-29Stream archive: Redoing the connection lesson and learning sqlx queries (2023-09-27 evening)
2023-09-28Stream archive: SQLx Rust (2023-09-27)
2023-09-27Stream archive: Starting article on sqlx and rust! (2023-09-23)
2023-09-27Channel update - My job situation changed!
2023-09-26Stream archive: Reviewing Redis in Axum article and recording a video (2023-09-25 evening)
2023-09-25Stream archive: Finishing rough draft of Redis in Axum + Rust article (2023-09-25)


Tags:
bulk insert
games
postgres
rust
sqlx rust
transaction
twitch
sql