logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Pure MySQL Object Storage?

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
Kato



Joined: 05 Mar 2010
Posts: 47

PostPosted: Thu Jun 23, 2011 8:41    Post subject: Pure MySQL Object Storage? Reply with quote

Anyone knows if it's possible to store and retrieve objects from a MySQL table without using StoreCampaignObject() and RetrieveCampaignObject? SetPersistentObject calls StoreCampaignObject, just like all the storage systems I have seen so far...

Thank you!

Kato
Back to top
View user's profile Send private message Send e-mail
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Thu Jun 23, 2011 11:35    Post subject: Reply with quote

What's wrong with SCO/RCO?
_________________
In Soviet Russia, NWN plays you!
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
Kato



Joined: 05 Mar 2010
Posts: 47

PostPosted: Thu Jun 23, 2011 20:21    Post subject: Reply with quote

Nothing, I guess, except that I don't trust BioWare DBs. I'm currently using a MySQL DB for all my systems(guild, gold and xp bank etc...), except the item storage one, still under an old, huge, slow BioWare DB(.dbf), and since I need to "dump" it to the MySQL one for speed, flexibility and reliability, I only wished to make sure I was using the best possible technique to avoid messing with this all over again. Calling a BioWare DB function from a MySQL query feels strange, but if there is no other way, then I suppose I have no choice...

Kato
Back to top
View user's profile Send private message Send e-mail
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Thu Jun 23, 2011 20:50    Post subject: Reply with quote

NWNX ODBC hooks SCO/RCO, bypassing the built-in DB. You call the same functions, but the query will be passed to MySQL instead of dbf if you use SetSCORCOQuery and pass "NWNX" as database name to SCO/RCO.
_________________
In Soviet Russia, NWN plays you!
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
Kato



Joined: 05 Mar 2010
Posts: 47

PostPosted: Thu Jun 23, 2011 21:14    Post subject: Reply with quote

Okay, thank you Virusman, you were quick to answer, indeed!

Kato
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group