Question about storage

[frxq]

Hi,

Im currently working on a project in my free time which is a custom gangs core, I had a question relating to player storage, gangs and players are stored in sql, however i dont know what the best way would be to get all of the gang members? my thought was obviously to run an async query through the members and return everyone with the requested gang id, but im unsure if this is the best way to go about this? any advice would be lovely

 

[Casey.]

Depends how you store the data. Can you provide us with an example of your data model.

 

[GabyTM]

you can have a table for gangs with an integer primary key, and one for players, with a foreign key that points to the id of a gang (if they are in one). Then the query would be

SELECT * FROM players WHERE gang_id = id-here;

 

[frxq]

Depends how you store the data. Can you provide us with an example of your data model.

you can have a table for gangs with an integer primary key, and one for players, with a foreign key that points to the id of a gang (if they are in one). Then the query would be

SELECT * FROM players WHERE gang_id = id-here;

Sorry if i was unclear i kinda meant is there a better solution than querying every player in the db every time the gang info command is ran?

My storage looks like this
Gangs:

Players:

 

[Casey.]

Honestly, I'm not 100% but is there anyway to get some form of array functionality within SQL. I'm sure there is one way or another to do it. Then you'd simply store all of the players in an "Array" in the gang table.

 

[kacperm]

Well, I prefer you to switch to Mongo, However not sure if it is in MySQL however what i do in mongo is I just store their UUIDS in the Gang collection it self

private String leader;
private String name;
private List<String> members;
private int kills;
private int deaths;
private boolean pvp;


example from my Clan class

 

[GabyTM]

Sorry if i was unclear i kinda meant is there a better solution than querying every player in the db every time the gang info command is ran?

My storage looks like this
Gangs:
View attachment 616316
Players:
View attachment 616317

Cache the data in memory