Mysql connectivity
by Umbra · in Technical Issues · 12/15/2006 (3:48 am) · 4 replies
Ive search the forum and only find realy old stuff. Is there ant new stuff about it. Beside dreamrpg ?
#2
The example I give uses MySQL++ 4.x, so it should suit you fine, but in reality any database can be used.
The resource doesn't show you how to expose the database access directly to scripts because this is for high-performance use, such as for zone servers for MMO type games where it's best to do the bulk of the coding in C++ and not scripting.
The event-driven approach allows your relatively high latency database calls to be executed in a seperate thread without slowing down your main game engine loop.
Hope it helps...
12/15/2006 (9:54 am)
A few days ago the Event Driven Database resource was released.The example I give uses MySQL++ 4.x, so it should suit you fine, but in reality any database can be used.
The resource doesn't show you how to expose the database access directly to scripts because this is for high-performance use, such as for zone servers for MMO type games where it's best to do the bulk of the coding in C++ and not scripting.
The event-driven approach allows your relatively high latency database calls to be executed in a seperate thread without slowing down your main game engine loop.
Hope it helps...
#3
12/15/2006 (2:29 pm)
@Tony - A merged resource that gives you both options, ODBC support for script-level and high-performance stuff for the backend stuff would be very beneficial IMHO. Interested?
#4
12/15/2006 (5:43 pm)
@Jonathon - Sounds great... wanna collaborate on this? I'm generally on irc.fractureduniverse.com #fractureduniverse or e-mail me (e-mail in profile). I'm kinda knee deep in this MMO Contest right now (neck deep is probably more accurate), but I can put a little bit of time into it. Dreamer was needing something like this anyways. We should get them involved as well because they were wanting to do this too. irc.mydreamgames.com #mydreamrpg. 
Torque 3D Owner James Spellman