I'll just pitch in - I just finished threading some MySQL code in a private metamod we run on our servers, so it's definitely possible. Because MySQL calls are stateful, you'll need to use a mutex to control the mysql calls (see man pthread_mutex_create for linux or CreateMutex on the MSDN for Windows) and you'll need to implement seperate threading methods for linux and windows (CreateThread for Windows and most likely pthread_create for Linux). And to anyone thinking of telling me I shouldn't use MySQL in my metamod, it's not distributed and thus I don't need to open source it, according to the GPL.
However, as to the licensing debate, this quote from MySQL's licensing policy page (http://www.mysql.com/company/legal/licensing/) pretty much sums it up: "If you distribute a proprietary application in any way, and you are not licensing and distributing your source code under GPL, you need to purchase a commercial license of MySQL". As to the question of whether software that uses a database needs a license for the database: You're right. It doesn't. Provided you know all the details of MySQL's protocol, you can use MySQL without obtaining a license (open source or otherwise) from MySQL, with two caveats - you must not have gained any of the knowledge you need for this from the GPLed MySQL - if you do, then your software is indeed a derivative work, and you must abide by the terms of the DMCA or equivalent... And that's just the code itself, who knows what patent issues there might be. On 8/2/05, Damien <[EMAIL PROTECTED]> wrote: > But due to query time, I need to thread it. Who can help me doing this, if > it's even possible ? > > Damien > > ----- Original Message ----- > From: "Alfred Reynolds" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Monday, August 01, 2005 8:08 PM > Subject: RE: [hlcoders] Keeping track of information inside the game > > > > You can use MySQL with your mod, just make sure you follow their > > licensing terms. > > > > I am not sure where you got that text Adam, my email history shows this > > as my complete reply: > >> VPMI is our distributed compiling environment. It hasn't been released > > > >> yet, you should not try to use it. > > Can you please update the text on that webpage to represent what I > > really said. > > > > The MySQL integration in VMPI has nothing to do with us not releasing it > > (it needs some love before it is ready for public consumption). > > > > - Alfred > > > > > > ----Original Message---- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Adam > > "amckern" Mckern Sent: Monday, August 01, 2005 2:38 AM To: > > [email protected] Subject: Re: [hlcoders] Keeping track > > of information inside the game > > > >> the licence issues will fall in if u use mysql (thats the reason why > >> vmpi is not working - www.ammahls.com/cst/vmpi.htm > >> > >> --- Damien <[EMAIL PROTECTED]> wrote: > >> > >> > > It will almost be a database. I'm creating an RPG mod. So I need > >> > > to store the inventory with Item IDs to reference from the Master > >> > > Item List, keep track of Active, Complete, and Abandoned Quests, > >> > > etc, keep track of the user's stats and stuff like that. > >> > > >> > Do you have ever thought about using a db like mysql ? > >> > > >> > Damien > >> > > >> > > >> > _______________________________________________ > >> > To unsubscribe, edit your list preferences, or view the list > >> > archives, please visit: > >> > > >> http://list.valvesoftware.com/mailman/listinfo/hlcoders > >> > > >> > > >> > >> > >> My Website http://ammahls.com > >> Lead Programer NightFall > >> > >> This email has been sent from Adam McKern, and is not one of the many > >> spam bots that use my email address. > >> If you receive an email that has not got this signature line, please > >> delate the email, and not respond in any way to it. > >> > >> > >> > >> ____________________________________________________ > >> Start your day with Yahoo! - make it your home page > >> http://www.yahoo.com/r/hs > >> > >> > >> _______________________________________________ > >> To unsubscribe, edit your list preferences, or view the list > >> archives, please visit: > >> http://list.valvesoftware.com/mailman/listinfo/hlcoders > > > > _______________________________________________ > > To unsubscribe, edit your list preferences, or view the list archives, > > please visit: > > http://list.valvesoftware.com/mailman/listinfo/hlcoders > > > > > > > > > > _______________________________________________ > To unsubscribe, edit your list preferences, or view the list archives, please > visit: > http://list.valvesoftware.com/mailman/listinfo/hlcoders > > _______________________________________________ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlcoders
