Golang Microservices: PostgreSQL: gorm and sqlboiler

Let me share with you some tips for using PostgreSQL when building Web Services! What are the pros? What are the cons? What are the best packages to use? What are the guidelines and best practices?

= Packages used

* go-gorm/gorm
* volatiletech/sqlboiler

00:00 - Start
00:32 - Different ways to access databases
01:14 - gorm
02:45 - sqlboiler
03:58 - Comparing ORMs
05:48 - Demo
12:34 - Parting words

---

Who am I:

Hello👋🏼! I'm Mario, a Hands-on Software Architect and Lead Backend Engineer with more than 16 years of professional experience building all kinds of software including on-premise Industrial Automation Systems, Linux Accessibility Desktop and Browser Components as well as Distributed Advertising Microservices.

Every week I will share with you different topics I've learned while working for small startups and large companies including the processes I've followed over the years for successfully delivering complex enterprise systems from start to end.

Subscribe if you like Software Development, Software Architecture and Systems Design!

Keep it up. Don't give up!

#golang #microservices #postgres

--- Our affiliate links below

--- Our Vlog Channel

[adrianfgutierrez]

Me impresionas como dominas vim. Espectacular. Todo un crack. Gracias Mario 👍🏾

[norbertocammayo]

Very informative. Maybe you should do some videos also on your vim setup so we can have the same experience.

[lzap_rh]

Nice, its a shame you do not show associations where it is much more obvious why Gorm is not a good for Go. Many people pick it because it looks like ActiveRecord, but it does not actually feel like ActiveRecord at all once you start using it. Specifically with associations.

[siip]

in my case, i need to migrate old codes that use java spring heavily, and dependencies using mybatis that is like ORM that generate codes from postgress schema. would u like suggest to use, Gorm or the old school sqlc?

[budi]

Hi, does anyone know if sqlboiler works with postgres on windows ?

[ravindrakumara.]

i am beginner golang sqlbiler so sqlboiler office doc deficult to understand for update staff please any help this

[adrianfgutierrez]

According to your experience. Which would be better, any orm or PGx

[mehdimozaffari]

So what is your final opinion on this?