SQLc is the perfect tool for those who don't like ORMs
Click this link https://sponsr.is/bootdev_dreamsofcode and use my code DREAMSOFCODE to get 25% off your first payment for boot.dev. 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 boot.dev
Video Links:
SQLc: https://sqlc.dev/
Code: https://github.com/dreamsofcode-io/sqlc
Repository Design Pattern: / repository-design-pattern
Gear Used:
Keyboard: ZSA Voyager
Mouse: https://amzn.to/3UbDaHM
Camera: https://amzn.to/4eFPvvP
Lens: https://amzn.to/3YmMR8v
Microphone: https://amzn.to/4eFPvvP
Video Interface: https://amzn.to/3zUjRvF
Audio Interface: https://amzn.to/3U8Zd1s
Join this channel to get access to perks:
/ @dreamsofcode
Join Discord: / discord
Join Twitter: / dreamsofcode_io
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
Смотрите видео SQLc is the perfect tool for those who don't like ORMs онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Dreams of Code 14 Октябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 99,740 раз и оно понравилось 3.5 тысяч людям.