Use Transactions When Manually Accessing SQL Databases

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


Duration: 0:00
118 views
4

When connecting to a database manually to run commands it's important that those commands succeed so that we know what the state of the data is in. Transactions can help us. In this video I make the case for us to use SQL transactions when connecting manually for that protection.

This should work in all SQL databases that support transactions even though I'm showing Postgres using PSQL here.

Want to learn more? I have some courses you may be interested in at https://learning.brooksbuilds.com/



Other Videos By Brooks Builds (brookzerker)


2024-10-27Creating my own HTTP server in Rust part 2
2024-10-24Creating my own HTTP server in Rust part 1
2024-10-23stream archive: Creating a course for Diesel (Rust ORM) (2024-10-24)
2024-10-23A chat with Tech Recruiter Will Wegert
2024-10-21stream archive: Creating a course for Diesel (Rust ORM) (2024-10-22)
2024-10-20stream archive: Creating a course for Diesel (Rust ORM) (2024-10-21)
2024-10-18Learning FusionAuth part 6
2024-10-17Learning FusionAuth part 5
2024-10-16Learning FusionAuth part 4.5
2024-10-16stream archive: Creating a course for Diesel (Rust ORM) (2024-10-17)
2024-10-15Use Transactions When Manually Accessing SQL Databases
2024-10-14Learning FusionAuth part 3.5
2024-10-14stream archive: Creating a course for Diesel (Rust ORM) (2024-10-15)
2024-10-13stream archive: Creating a course for Diesel (Rust ORM) (2024-10-14)
2024-10-13Learning FusionAuth part 3
2024-10-12Learning FusionAuth part 2
2024-10-11Learning FusionAuth part 1
2024-10-11Creating a stream manager day 7
2024-10-10stream archive: Creating a course for Diesel (Rust ORM) (2024-10-09)
2024-10-09Creating a Stream Manager day 6
2024-10-08Creating a stream manager day 5