Click this link and use my code DREAMSOFCODE to get 25% off your first payment for . That’s 25% off your first month or your first year, depending on the subscription you choose. When it comes to working with a database in Go, I often make use of the Repository Design Pattern, which wraps the queries into type safe functions. Whilst this is my preferred approach, it does take a lot of time as it's mostly tedious to do. Fortunately, there's a new tool out there called SQLc which solves this, and many other problems. This video is sponsored by Video Links: - SQLc: - Code: - Repository Design Pattern: @pererikbergman/repository-design-pattern-e28c0f3e4a30 Gear Used: Keyboard: ZSA Voyager Mouse: Camera: Lens: Microphone: Video Interface: Audio Interface: Join this channel to get access to perks: Join Discord: Join Twitter: 00:00:00 Intro 00:01:49 SQLc 00:04:02 Sponsor 00:05:43 Simple Example 00:07:22 Define Schema 00:08:14 Define Queries 00:09:03 Query Annotations 00:10:11 Code Gen Config 00:10:55 Installing SQLc 00:11:28 Generated Code 00:12:18 Integration 00:14:07 Insert Query 00:16:12 Returning * 00:17:49 Overrides 00:20:04 json tags 00:20:31 Embedded Structs 00:22:05 Prepared Statements 00:22:36 Transactions 00:26:25 Query Organization