[STORING DATA] Text or SQL?

[RazMouze]

I know this topic already had a thead, but i need to know for this specific use.

So if I have an addon, and I have to store maybe points per player. Then if I store the points in an SQL, they will have to setup their own SQL right? And if I set up my SQL for them (My own database), they can get access through the code. But with the text file, I can't see many negatives. The only one I can spy, is that if you have 1000 different players, that file will file a bit.

[Netheous]

SQL - and you are wrong.
You simply load data from YOUR SERVERSIDE database and send it to players.

[RazMouze]

[QUOTE=Netheous;50658102]SQL - and you are wrong.
You simply load data from YOUR SERVERSIDE database and send it to players.[/QUOTE]

thanks... But are there any tutorials about that serverside, you talk about?

[Nookyava]

I don't necessarily know if you should do anything with data, or at least databases until you actually know what you're doing.

[andreblue]

[QUOTE=RazMouze;50658165]thanks... But are there any tutorials about that serverside, you talk about?[/QUOTE]

[url]http://wiki.garrysmod.com/page/Category:sql[/url]

[Zigi]

You wouldn't have to create a new database for each player. You'd have one table and a row for each player (that is what facepunch does to store users.)

EDIT: Also you'd network the required things to the player NEVER allow the player direct access to the SQL. (Also never trust the client :pudge:)

[RazMouze]

[QUOTE=Nookyava;50658209]I don't necessarily know if you should do anything with data, or at least databases until you actually know what you're doing.[/QUOTE]

Sorry, i never ever tried SQL. But i think i need to learn about it. :v:

[editline]6th July 2016[/editline]

[QUOTE=Zigi;50658228]You wouldn't have to create a new database for each player. You'd have one table and a row for each player (that is what facepunch does to store users.)[/QUOTE]

Yes, but do i have to make my own database. It's just because i tried to do something like this with UserData for PHP... It maybe went wrong. :nope:

[editline]6th July 2016[/editline]

[QUOTE=andreblue;50658215][url]http://wiki.garrysmod.com/page/Category:sql[/url][/QUOTE]

Thanks, but i thought more like video based. :pudge:

[Zigi]

[QUOTE=RazMouze;50658234]-snip-[/QUOTE]

If you use the inbuilt SQL system you only have to create a table.

I suggest you learn about SQL before jumping into it.

EDIT: This might help [url]http://www.w3schools.com/SQL/sql_intro.asp[/url]

[RazMouze]

[QUOTE=Zigi;50658255]If you use the inbuilt SQL system you only have to create a table.

I suggest you learn about SQL before jumping into it.[/QUOTE]

Thanks, i will give it a try :)

Ps any arguments for not using text?

[Zigi]

[QUOTE=RazMouze;50658266]Thanks, i will give it a try :)

Ps any arguments for not using text?[/QUOTE]

Sorry, I don't know what your meaning by your question ? Mind elaborating?

[RazMouze]

[QUOTE=Zigi;50658278]Sorry, I don't know what your meaning by your question ? Mind elaborating?[/QUOTE]

Yeah, i meant not using text file. ( I see why you got confused )

[Zigi]

[QUOTE=RazMouze;50658285]Yeah, i meant not using text file. ( I see why you got confused )[/QUOTE]

For 1 you'd be creating a new file for each player but with a SQL Database it is one file. A lot easier to find something and less clutter.

[RazMouze]

[QUOTE=Zigi;50658294]For 1 you'd be creating a new file for each player but with a SQL Database it is one file. A lot easier to find something and less clutter.[/QUOTE]

Thanks! Thanks to all of you! :)