Complete Backend API in Golang (JWT, MySQL & Tests)

► Checkout the channel community with exclusive courses: selfmadeengineer.com
In this course we're going to be building a production-ready E-commerce REST API in Go using JWT authentication, we'll be testing our services and connecting our server to a MySQL. We'll build everything from scratch so that I teach you just enough for you to be able to go on your own and not having to watch another video on how to build APIs in Go.
►Resources:
Source code: github.com/sikozonpc/ecom
Improvement Exercises: github.com/sikozonpc/ecom/blo...
👉 Join the private community to level up as software engineer: selfmadeengineer.com
📢 We're building a Discord community, come and join
/ discord
🙋🏼‍♂️ Socials:
X: x.com/TiagoFe01662401
Github: github.com/sikozonpc
Hope you liked and thanks for watching!
Time Stamps 👇
00:00:00 Intro
00:02:40 HTTP Server setup
00:07:00 User service
00:11:00 Database Connection & Envs
00:18:45 Registering users
00:36:07 Testing the user registration
00:47:48 Database migrations
00:56:20 User login
01:00:20 JWT Authentication
01:06:54 Products service
01:11:25 Checkout endpoint
01:27:00 Checking logged-in users
#golang #backend #api #jwtapi
Video titles ideas (for the algo):
REST API in Golang Beginner Tutorial
Building a JSON API in Golang
How to build a REST API in Golang

[@TiagoTaquelim]

I've added the improvement exercises in the description. If you have any questions feel free to leave them in discord as well! Thanks for watching

[@gokulakrishnanr8414]

Something went wrong. Please try again or refresh the commment.

[@Andika-hk6rd]

I'm new to programming languages and I chose Go as my first language. I follow many KZbin channels, but yours is just underrated.

[@TiagoTaquelim]

Your too kind, ty! Feel free to join the Discord community if you ever have any question!

[@WildLifeBackyardCamera]

been through so many tutorials that were not giving correct folder structure and finally, finally someone that do it right, thanks a lot

[@mcdaddy1334]

I found your channel a couple of days ago and you are covering everything I wanted to see from a Go tutorial. Thank you !

[@coffeeintocode]

Great! Really enjoyed the testing approach

[@cesarpeixoto7026]

really good quality and balance of explanation/time! keep up

[@dabbabielkamel3434]

Thank you tiago❤

[@mateuszzajac9127]

great tutorial, big thanks!

[@heesoolee1850]

Amaizing video~~ thank you so much

[@programmertelo]

insighful . thanks Tiago

[@langqin]

very helpful!

[@klaudiuszbiegacz3519]

Even before watching I'm sure it's gonna be some quality content, and just when I've been looking for something like this, thanks man again!!:)

[@TiagoTaquelim]

Thank you so much 💪

[@sachinbasnet8258]

thanks tiago

[@rostyslav5334]

GOAT, thank you That what I was looking for some solid foundations

[@TiagoTaquelim]

💪

[@sajin.notfound]

Great content...

[@loudcoringa5935]

Thank so much for the video bro! I'm migrating from TypeScript and i found your video!

[@prakashupadhyay9824]

this is everything a developer can ask for, I can't thank you enough man. Great content!

[@TiagoTaquelim]

Im glad you liked it! Thank you so much

[@cristophermoreno2290]

🔥 THIS IS AMAZING !! THANK YOU SO MUCH SIR

[@TiagoTaquelim]

You're amazing 🔥

[@iamfrancisco]

This is such an underrated channel! Obrigado Tiago for creating these videos with such care and high quality

[@TiagoTaquelim]

Thank you so much!

[@prashlovessamosa]

Thanks Tiago

[@TiagoTaquelim]

💪

[@fathan1247]

this is what i am looking for, thankyou Tiago for making this tutorial, edited: i am glad if u can make grpc golang tutorial for the next upcoming video

[@TiagoTaquelim]

Thanks a good idea! Thank you!

[@verygood5788]

Cool tutorial thanks man, i went from js and py 60-70% of inforamtion the same but new concepts to hard for understand,you helped me, from me like subscription and comment ✌✌✌✌

[@lazaromanuelcunga6195]

First of all, I really liked your channel. How about bringing a video about the complete Graphql API?

[@bijayaprasadkuikel5162]

I enjoyed your video. Please keep up the good work and continue making more videos.

[@TiagoTaquelim]

I will! Next one is scheduled for next week!

[@go_lang_thang]

nice course bro ơiiiiiiiiiiiiiiii

[@arturfil]

Amazing video, really great content and great project setup!

[@TiagoTaquelim]

Thank you!

[@arturfil]

@@TiagoTaquelim By the way, I've been looking into books to have more knowledge about production go project setup. Do you have any recommendations?

[@TiagoTaquelim]

@@arturfil It's hard to say because there is no "one project setup". But check the O'Relly books on Go, they have a bunch

[@arturfil]

@@TiagoTaquelim Will definitely have a look thank you for the suggestion

[@abdullahzahid749]

finally i find some good resources in go lang

[@GreyWinds]

Great video! In another video, could you also show the connection to the docker container running the mysql server.

[@youranonymousyoutuber4051]

I sub

[@pedrolemos3030]

Hi, amazing video, Tiago! Really! I've learned a lot. If I could suggest an idea for a upcoming video: building a rest api using only the standard lib. I am not sure if this is a good idea, but since the 1.22 version added better routing, I would be really interested in seeing how you would make it. Thanks for the great content!

[@TiagoTaquelim]

Thank you! I'm glad you learnt a lot! Nice idea, I'll think about it! But definitely a 1.22 routing video is coming.

[@norbertocammayo2334]

Can you also please teach us how to integrate this with swagger ui? Thank you for sharing your knowledge.

[@CodeWithRivandra]

Great video dude. Anyway i want to ask one thing. Is ther other way to map sql columns to a struct in a way that more humane. It's kinda suck to do it based on order alone

[@edupsousa]

Great video! I would suggest avoiding editing code at the bottom of the screen as it can be hard to read with subtitles on or when the video controls are active. You can easily address this by setting the 'editor.cursorSurroundingLines' to a higher number in the VSCode configuration.

[@TiagoTaquelim]

Thank you so much! I'll check it out! Thanks for the advice!

[@mrduongtien]

Great video, thanks man. I wanted to ask what extensions you are using for suggesting the libraries you import.

[@TiagoTaquelim]

Thank you! If you mean the auto completed text it's github copilot. If you mean the dialog that shows and I import it then right click on the name, it's not an extension.

[@sval4020]

Hi, Tiago, great video! Keep up rocking man! Love your content! A question I have, what is the best way to secure Go + HTMX + Echo + templ application? Are JWTs preferable or is there a different approach we should take?

[@TiagoTaquelim]

Thanks! JWTs are a good way to store the users session in the browsers independently of your tech stack, so yes.

[@runners4tme]

Create order should have a transaction for checking products

[@aunjaffery31]

How to map nested one-to-many join into struct? Awesome video. But please cover this part.

[@98832230]

try gorm , it is pretty easy for most of db operations.

[@hectorcast943]

How would you deal with transaction between multiple store in repository pattern?

[@de-is]

Thanks for the great tutorial! Which framework/language or some core "tutorial" inspired you to use such Directory Structure for this application, directory per service? From one side it seemed like an overkill for me, but obviously, on the other side, it is a good strict organizational pattern. I as a Go beginner, saw bigger tutorials which still use simpler structure, and I in general tend to use simpler organization - but I really would like to know more about your "Application Structure Organization Pattern"

[@TiagoTaquelim]

Thank you so much! Ye, I have another video where I use a very simple structure without folder even. I still think this one is simple tho. Now, I don't follow any specific pattern, other than I split the code into "domains" where each domain is a small service. I feel this is more natural to do in Go because of the packages and the nature of the project (a REST API) however I've seen a lot of OSS using something like this.

[@de-is]

Why constructors NewAPIServer, NewStore, NewHandler, return pointers and not values. In the most cases, we are not changing these control structs fields values after they are setup, right?

[@nickshilov9929]

Hey Tiago, thanks for the video! I wonder why you've decided to put all env vars to configs and not to call'em through os package? Thanks in advance for your reply!

[@TiagoTaquelim]

Hey thanks! I did consume the env vars through the os package but I've organize them into a configuration file for ease of use.

[@abimanyudamarjati1936]

great video! btw, what vscode theme did you use?

[@TiagoTaquelim]

Thanks! It's called Gruvbox.

[@mrfli24]

Thank God. He used standard database/sql interface, not ORM. Which vsc theme he used in the video ?

[@TiagoTaquelim]

It's called Gruvbox.

[@OnceUponKid]

i still don't know how to apply JWT for every routes as a middleware?

[@sebastianletelier7947]

Would love it using net/http 1.22 handlers😅

[@weiSane]

Tiago this is good stuff. Thanks for this in-depth tutorial man. However, those are way too many dependencies wtf. Why not have fewer files it’s easier to maintain and easier to follow and read the code.

[@TiagoTaquelim]

Thanks! I've make a previous full length video like this before where I did not even create a folder to solely focus on teaching. However folk wanted a better starting point for bigger applications and that is why I've divided into folders here. so it can grow. Also, the project has 5 external dependencies, some of which are for security and loading the env vars, none of them is extraneous.

[@weiSane]

@@TiagoTaquelimI understand given the context you have provided.

[@yakomisar]

Tiago, what is gruvbox plugin do you use?

[@TiagoTaquelim]

Gruvbox hard theme for vs code.

[@yakomisar]

By Tom Philbin ? There are more than one gruvbox theme plugin.

[@aleksandrpetrov3938]

Why do you use gorilla/mux? What do you think of the router golang 1.22 has inside already?

[@TiagoTaquelim]

I'm still using gorilla on the videos because most people are still not using Go 1.12. Otherwise I would not use it unless necessary.

[@aleksandrpetrov3938]

@@TiagoTaquelim what would you use then? Chi or just built-in router? How can we implement middleware with built-in router? is it going to be function wrapper on a handler which I put around handler in every route description? Or we can do smth more elegant same with chi.Use ?

[@TiagoTaquelim]

​@@aleksandrpetrov3938Hmm I would start without any dependencies, and if I needed them for example for that use-case you described then I would consider adding.

[@juanjofre4807]

Hello Tiago, hope you're doing well. I was following along this amazing tutorial and couldn't wrap my head around why in the dependency injection part, right around 31:50, its ok to pass a user.Store to a types.UserStore. one is a type and the other is an interface. why does this works? also, why you said that it didn't need to be a pointer? Thank you very much this is a super helpful video.

[@TiagoTaquelim]

Hey! Because that struct implements that interface, any other struct that would implement it would work there, that's why it's useful to interchange dependencies & that's how interfaces work in Go. I would recommend you to checkout more about them.

[@juanjofre4807]

@@TiagoTaquelim Amazing! thanks for the explanation. Also in the "WithJWT" utils that parses the auth token, what is the reason for passing the user store as a value and not as a pointer? given that the store is modeled as a singleton why you pass a copy of it to access its methods and not a pointer? Thanks!

[@TiagoTaquelim]

​@@juanjofre4807 If the user store is not an interface (i dont recall) it was probably a mistake from part.

[@SushantShekhar-my7eu]

16:40 how do you handle your envs if not by .env files?

[@TiagoTaquelim]

Loading them using a CLI tool called Direnv

[@kavindugunasekara448]

is this microservice project?

[@shaikwaris4131]

your vscode extensions please

[@dwskme]

In testing user registration I don't understand, are we checking if user payload is valid or invalid? Kinda confused me. little explanation anyone.

[@TiagoTaquelim]

We're checking if it's invalid. I did make the test fail in purpose to show you how changing the code affected the result of the test.

[@muhammadyafialhakim1813]

which version of golang do you use in this tutorial? try to match with you so i didn't get any unnecessary errors

[@TiagoTaquelim]

Hey! The source code is in the description. You can get the exact version and code there.

[@muhammadyafialhakim1813]

@@TiagoTaquelim thank you!

[@codedusting]

What to do if I want to replace the mux router with the new 1.22 http router? How to create subrouter and other stuffs?

[@TiagoTaquelim]

I have a video on my channel about it.

[@codedusting]

@@TiagoTaquelim before this video or afterwards?

[@codedusting]

@@TiagoTaquelim found it

[@codedusting]

@@TiagoTaquelim thanks

[@kevinmathew8372]

04:10 Would it better not to include ' db' in the APIServer struct?

[@doooom911]

why?

[@afolayanademola461]

hi thiago, pls how did you get sql downloaded on your mac. is it free?

[@TiagoTaquelim]

Yes it's free. There are 2 ways: you can download the MySQL Community server. Or you can use it with docker, which is how I'm doing. If you're not familiar with docker, use the first option.

[@afolayanademola461]

@@TiagoTaquelim I am using postgres. I hope I am still inline too.

[@PPPsg116]

Is this rest api

[@BeheadedKamikaze]

1:43 You mentioned you would set up a database and Dockerise the application but the video does not contain these steps

[@TiagoTaquelim]

The database we do. I just ran a mysql docker image on my end, its pretty simple. However I have left a docker-compose on the github repo.

[@user-mz3kg4ge8u]

Are you portuguese or brasilian bro?

[@TiagoTaquelim]

Portuguese

[@liezner]

You still use gorilla mux even though its depreciated 👎🏾? Whats the point of naming your video gin gorm then

*If someone is getting the following errors on Ubuntu: ### Error when running _make test_ # runtime/cgo _cgo_export.c:3:10: fatal error: stdlib.h: No such file or directory #include compilation terminated. SOLUTION: Just run _apt-get update && apt-get install build-essential_ ### Error when running _make migration add-user-table_ Below is the correct script to write on Makefile (remember to install the MySQL CLI on your machine) SOLUTION: @migrate create -ext sql -dir cmd/migrate/migrations $(filter-out $@,$(MAKECMDGOALS))