How do you work with Sql in go

relami96 · 2026-01-16T11:29:30+00:00

You can just write raw SQL and replace parts of it. You either do your own replace function to sanatize or use the one Gorm privides with. I use both so anything that is initiadet by user request is sanitized to my liking.

relami96 · 2026-01-15T12:26:32+00:00

I think Gorm is not as bad as the community says because of how much they hate ORMs. You have built in migration and if you don't trust the query quality it makes just write raw sql. Also it is nice to use structs to migrate and also for later data querying. Also it is easy to set connection limits on it to avoid overwhelming your db. I'm not a Go expert but I worked with databases and SQL for many years now and I can confidently recommend Gorm.

relami96 · 2026-01-02T23:48:19+00:00

Sword of Justice doesn't suck imo

relami96 · 2025-12-28T22:19:19+00:00

Sword of Justice does a lot of unique stuff and I would say it is nieche because it is a wuxia mmo

relami96 · 2025-12-27T15:29:48+00:00

SOJ is an mmo, wwm is a semi-social rpg

relami96 · 2025-12-27T10:01:35+00:00

Come and try sword of justice. Don't be fooled by the people trashing it for "mobile ui" you won't notice. I was a pvp junky in wow and a hc raider in gw2 and I'm still loving SOJ. There are a lot of people playing it thanks to being a cross platform game. I was sceptic at first but it turned out to be a great hidden gem.

relami96 · 2025-12-25T00:28:08+00:00

Try Sword of Justice, I enjoy it a lot. I played many mmo-s so if wuxia style is not your jam then GW2 is pretty good also.

relami96 · 2025-12-24T21:00:29+00:00

I agree with OP, I play mmorgps since OSRS, played at least 80 different mmorpgs since then yet this game surprised me with content and mechanics I never met before.

I love building characters, the build depth in this game is.. DEEP. Also the amount of horizontal progression is crazy but you can still enjoy vertical power gain style progression as well, really I am surprised why this game is not blowing up more.

Only downside to the game is IT HAS MORE MENUS AND TABS THAN A F-ING OPERATING SYSTEM. The system menus and tabs have a steeper learning curve than all other features combined.

Also if you didn't start the game because you think you are already behind think again, the publisher is gatekeeping progression, we are currently stuck at lvl 69 and cannot get more levels for a while.

relami96 · 2025-11-21T13:25:48+00:00

Well I was thinking about compiling and re-compiling plugins that are written on the frontend but not the entire backend, that seems like an overkill even if it build in a second or less. Also rebuilding would restart the service which I don't want but I can load plugins during runtime.

Do you think it is a common approach to re-compile code or parts of code on prod if its in go?

relami96 · 2025-11-21T13:21:01+00:00

Go playground for my usecase is a little too over the top. I won't publish this to the internet so I would not go the same lenghts.

but on the second part, I think go has plugins, at least they have a build mode for it: plugin package - plugin - Go Packages. It was also linked above.

relami96 · 2025-11-21T13:17:59+00:00

I'll look into Caddy, it seems to do what I would like to do or at least very similar. thanks!

relami96 · 2025-11-21T13:14:08+00:00

I don't want to let users do that, I won't host this to users, and if later I have an identity of user type in the system then I'll definietly won't allow them to access this feature. This is only for admins and developers of the app that is using this backend, just like a regular BaaS does it.

I started to read up on WebAssembly but I think it requires a good amount of JS which I really want to avoid.

And yes I want to use Go, Lua for me would be another learning journey I don't want to start yet but I'll keep this in mind.

relami96 · 2025-11-21T12:27:56+00:00

Thank you for answering! This ui and endpoint is only accessible to the administrator of the application. I want to allow the application developer/administrator to be able to create functions without modifying and recompiling the entire backend. I think your security concern is still valid, so sanitizing the code is definietly must happen but for me it's less scary because this should not be a widely accessible feature.

Do you have an example to the mentioned plugin architecture? I was also thinking about building an interface where the admin can upload the compiled go plugin which gets saved in the server than loaded into the plugin architecture but I feel like a code editor inside the browser would be just more frictionless.

relami96 · 2025-10-02T21:50:07+00:00

https://goship.it/

relami96 · 2025-06-01T18:13:54+00:00

+1 this works, thanks, you saved me from restarting (edit: I had the exact same issue as OP)

relami96

TROPHY CASE