Hi,
I want to work with Nakama’s database from my module, for ex: delete notifications by using some conditions. How should I do with Go module.
When I search in forum, I saw an example in Lua:
nk.sql_exc
But no clue for Go.
Thanks,
@dalmatele The Go runtime framework we’ve provided which hooks into Nakama already exposes the *sql.DB type which is all you need to create SQL queries and execute them against the database. Have a look at the standard Go documentation for the database/sql package:
sql package - database/sql - pkg.go.dev
Be careful with the SQL queries you write because if they do not access an index efficiently you will affect the rest of the performance of the game server. Are you sure it wouldn’t just be simpler to have the game clients programmatically delete notifications that match the conditions you have for when you want users to not see them anymore?
Hope this helps.