Raw SQL Queries in Go LIKE a 10x Engineer! - Repository Pattern Example

Показать описание

I'm sure as a Go engineer you've had to work with raw SQL queries in Go before! Maintaining raw SQL queries can be a pain. So in this video, I discuss a pattern I've been following recently to help manage SQL queries within my repository implementations. It's a simple concept but nonetheless, I thought it was worth a video as I've seen some pretty unmaintable code dealing with this in the past. This is also a pretty good example of the repository pattern in Golang.

samvcodes

Рекомендации по теме

Комментарии

Your teaching style is good keep up the good work.

katungiyassin

You can get type-safe raw sql if you're using jetbrains IDEs with autocomplete and suggestions because all the ides are well-integrated with databases & its own dbms. They can compared your created tables in the db with your raw sql and highlight any errors in the raw sql.

ArcticPrimal

Using testcontainers (or similar tool) is a game changer. Please don't make integration tests with in-memory dbs if you are not using one

jpcairesf

Nice vid. I need to know your color theme tho, looks so fitting for golang (might sound strange, but i really think that)

newpersxn

Thanks for the amazing explanation. I'm currently learning Go. One question though. Isn't using a transaction for everything a bit expensive?

Cyber_Lanka

How do you setup the database in the tests? and how do you handle migrations?

eedvfkr

Awesome video but volume of sound is low. I had to put volume to max on my laptop to hear it clearly.

anonymouse

Why do you prefer using raw SQL as opposed to using an ORM like GORM? People have various opinions about this, just want to hear you on this one…

YvanFlorian

For the integration tests what I'm doing is to spin up a new test schema that is a clone of the public schema and execute my migration files.

Then while testing I temporarily set the search_path of the database to the test schema.

Finally, if the test passed I remove the test schema, this has the added benefit that if a test fails I can keep the test schema and inspect it manually to see on which table structure or data the test failed on.

geoblk

Raw SQL Queries in Go LIKE a 10x Engineer! - Repository Pattern Example

Raw SQL Queries in Go LIKE a 10x Engineer! - Repository Pattern Example

Go SQL Comparison (squirrel, raw queries, sqlc and sqlx)

Golang gofiber raw sql queries

Raw SQL, SQL Query Builder, or ORM?

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Create a Query builder in Golang

Django ORM - Performing raw SQL queries

Why You SHOULDN'T Be Writing Raw SQL In 2023

Data Engineering Basics on Cloud (AWS & Azure) || K21Academy

Laravel: Raw SQL Queries with DB::select()

ORM's vs raw SQL queries and when to use what?

Django bypass ORM! - Performing raw SQL queries without the ORM

Raw SQL queries & stored procedures in Entity Framework Core

DONT USE AN ORM | Prime Reacts

Intro to SQLBoiler by Aaron Lefkowitz - Utah Go User Group

EF 8 new feature: Raw SQL queries for unmapped types

From Novice to Expert: Harnessing the Power of Raw SQL Queries in Entity Framework with C#

SQL vs ORM - Which One To Choose For Database Interaction

How to Get Raw SQL Query From Eloquent & Query Builder in Laravel

[Backend #4] Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx & sqlc

Translating RAW SQL query using Query Builder

Multi-Join Raw SQL Query To Laravel Query Builder Conversion

Go Fiber + SQLx

How to use GORM to interact with your SQL databases in Golang