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

In this video, you'll learn the pros and cons of 4 different ways to interact with an SQL database in Go, by comparing squirrel vs raw queries vs sqlc vs sqlx.

[@jorgeandresnumamendoza258]

sqlc is my favorite, because has the highest performance (my benchmarks). I use it with a million users in mysql and postgres. You also have more control over your queries since you write them by hand. Good video!!! Thank you.

[@arilson.santos]

Does it work well with N+1 queries? (for two or more structs)

[@webdevfuel]

Thank you for sharing your experience! I've actually been using sqlx or the std library more, since I've found I had to modify the sqlc code for some edge cases. But if it works for you, that's what's important!! 😊

[@daviddarfdas]

Awesome explanation and amazing seeing examples for each library. Thank you.

[@webdevfuel]

Thank you, I appreciate you watching. Glad it was helpful to you! 🙏

[@Ohhimark100]

Thanks! That was very insightful.

[@webdevfuel]

Thank you very much! I'm really glad it was insightful to you! 🙏

[@JohnathanHendrix]

Great video.

[@webdevfuel]

Glad you enjoyed it!

[@lokeshahuja1885]

Very nice explanation, Can you please provide all the code snippets examples you have used.

[@webdevfuel]

I don't think I have the code snippets publicly available, but I'll try to find them and update the description with the link to the repo! Thank you for watching! 🙏

[@diehenne]

thanks!

[@webdevfuel]

I'm glad it was helpful! Thanks for watching!

[@theofulis]

What application is that, that you using for the notes?

[@TheAcademik]

Google excalidraw 👌🏿

[@webdevfuel]

It's excalidraw.

[@neilmedina997]

sqlx it is. sql proficiency , control and gigachad points.

[@webdevfuel]

I agree, sqlx is probably my favorite choice too!

[@terrencemoore8739]

You've already said "go ahead" like 8 times in the first 2 minutes 😂

[@terrencemoore8739]

Try just saying the thing instead of prefacing it with go ahead, going ahead, etc

[@BarakaAndrew]

sql injections using sqlx? lol not true

[@webdevfuel]

If you build the query manually, yes. I said in the video that it's a possibility, but not if you build the query in the correct way (e.g. with question marks and the values as arguments).

[@Christo6020]

The language is called Go, not Golang.

[@webdevfuel]

Sure, but it's referred to as Golang all the time so it's fine either way.

[@OghamTheBold]

Sometimes saying _Golang_ can help in Search

[@webdevfuel]

That's true too, the language name itself is kinda bad for search engines, which is ironic since Google created it 😄 everything else is amazing about the language

[@dev-qq2vy]

I refuse use Go, I only use golang beacause I dont want search about "go go go, come on".😂

[@Tay74514]

Thank you for sharing this. I can only imagine the analysis that went into sorting the pros and cons. Thank you again for speeding out thinking cycle up 🫡

[@webdevfuel]

Glad it was helpful!