Amazing Tool For Handling Database Migrations In Golang

► Join my Discord community for free education 👉 / discord
► Exclusive Videos, Mini courses, Resume reviews, and coaching 👉 thetotalcoder.com
► 33% OFF on my Go + HTMX + Templ Course 👉bit.ly/3UFruxO
► Enjoy a 60% Black Friday Discount on My Golang Course 👉 fulltimegodev.com
► Follow me on Twitter 👉 / anthdm
► Follow me on GitHub 👉 github.com/anthdm
SUBSCRIBE OR NO MARGARITAS
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝

[@anthonygg_]

► 33% OFF on my Go + HTMX + Templ Course PRESALE bit.ly/3UFruxO ► Exclusive Videos, Mini courses, Resume reviews, and coaching thetotalcoder.com ► Join my Discord community for free education discord.com/invite/Ac7CWREe58 ► 60% OFF on my Golang course fulltimegodev.com Goose GitHub: github.com/pressly/goose Thanks for watching

[@demmidemmi]

From the video I'm not sure in what way goose is different from go migrate? Other than it being more 'batteries included' it seems.

[@dandogamer]

Personally I use 'atlas' for my migrations

[@dejangegic]

what's the advantage?

[@micahshellhamer3794]

I literally just used it for the first time before seeing this! It's pretty easy to use.

[@kennedymbogo542]

This is nice. Wanted to try dbmate next after go migrate but I think I might go with goose now.

[@prmshzkarmacharya2069]

I have been using goose for last few go projects😊

[@mohammedaabida1865]

Really nice video . Can you make a video an optimal solution on how to implement a background download process. When user request multiple download(restrict the duplicate requests). the requests will be sent to the server it can be add it in the queue and process in the background job. User can view the progress of the download in the frontend and the status of the download. Appreciate your work 👏

[@kwe4117]

What’s wrong with GORM auto migration ?

[@devoverlord]

@anthonygg this is great and all, but how do you apply them in production? Do you use Github Actions, or some sort of serverless function in whatever cloud provider, or do you just execute migration on init of your service? If on init of the service, how do you handle that init when you scale the service?

[@anthonygg_]

Migrations are done manually.

[@Noudapi]

I use liquibase, pretty nice

[@sipatha]

You missed adding the goose URL in the description as promised

[@zoop2174]

I have used goose before, and it's great. But when I switched to Bun for my db queries (I had issues with sqlx and the basic go sql is a pita) I just also switched to their migration system. Just to keep it lean. One has to make sure to always write "CREATE TABLE IF NOT EXISTS" when you switch db migration tools.

[@KiraleosAkis]

hey anthony, what theme do you use for vs code? looks nice

[@anthonygg_]

Gruvbox

[@stefantolksdorf2576]

atlas ftw

[@cristianortiznavia7595]

What do You think about sqlc, to manage db operations in go?

[@massy-3961]

It’s good for making focused functions, but if you try to make general dynamic repositories it’s really hard to set up. But it’s pretty solid overall.

[@thoriqadillah7780]

Personally i never found using sql fun for migration. If i want to create a migration, I'll make sure its just simple. So my go to migration solution is actually laravel zero (laravel CLI only). So far laravel has the most complete yet easy when it comes to database related The minus is we need to keep up yet another repo for our migration. But for my personal experience, it was never an issue

[@burionyt]

how is go migrate in comparison to this ?

[@anthonygg_]

Its a bit harder to setup. Goose just makes sense

[@dandogamer]

Last time I tried go-migrate it was pretty bad. Because of the order it uses to apply migrations but also it frequently put my migrations into a "dirty" state where I was unable to then apply more migrations or rollback

[@joelv4495]

@@dandogamer I also don't like that gomigrate only maintains the current schema version id. Could be an issue when multiple people are generating migrations and the migrations hit "out of sequence".

[@dirty-kebab]

I wasn't using migration tools, but am working on a big refactor and will eventually need to migrate. This is totally useful. Maybe run us through an example? Pls not a 1 hour video tho, even when Prime does it, bro I need to feed my kids 😂

[@thoriqadillah7780]

Try to use laravel zero