local SQL

Can someone provide me with some decent sql documentation for writting to the servers local database

I don’t think any of the functions there are depreciated so it should be fine.

Thanks c:

Do you know what to most amount of data you are allowed to store in a database is , Or is there not one?

I may not be correct in saying this but i do not believe there is a limit, the only limit i could think of is your PC’s HDD.

You’ll likely reach a performance ceiling ( returning 10s to 100s of thousands of rows ) before a disk space ceiling unless you are doing something terrible like storing encoded data as a string.

I do have a few… I’d recommend setting up Local SRCDS to do testing: https://dl.dropboxusercontent.com/u/26074909/tutoring/server_srcds_steamcmd/setting_up_a_server_with_steamcmd.lua.html

I don’t have any install instructions but here are some basic ways to connect with or without fallbacks ( TMySQL / MySQLOO / etc… but the best would be to have a wrapper that functions the same )…




Basic queries: https://dl.dropboxusercontent.com/u/26074909/tutoring/database/basic_queries_and_query_formats_used_to_check_for_existing_row.lua.html

Example to convert sv.db to MySQL inserts: https://dl.dropboxusercontent.com/u/26074909/tutoring/database/converting_sv_db_to_mysql.lua.html

Converting Pointshop 1 sv.db to MySQL ( using the example above except to isolate only the specific pointshop data and output into the proper format which comes with PS1 ): https://dl.dropboxusercontent.com/u/26074909/tutoring/database/converting_sv_db_pointshop_to_mysql.lua.html

If you want something to write the queries for you then there are statement generators out there ( such as mine in my dev_base soon to be in addon format ) which may or may not be easier for you that typing out the queries ( new system supports table layout and it’ll generate everything necessary )…

Do you have like a giant book/table of contents/directory of all your tutorials? I feel like they could come in handy if someone ever needs them.
Or maybe putting that whole tutoring folder in a zip or something.