Get / SetPersistentObject via SQL?

Scripted ALFA systems & related tech discussions (ACR)

Moderators: ALFA Administrators, Staff - Technical

Locked
User avatar
AcadiusLost
Chosen of Forumamus, God of Forums
Posts: 5061
Joined: Tue Oct 19, 2004 8:38 am
Location: Montara, CA [GMT -8]
Contact:

Get / SetPersistentObject via SQL?

Post by AcadiusLost »

Amidst my hectic 2 weeks of travel, I missed this: Virusman of NWNx.org has released an update to the xp_mysql plugin we use to tie persistency into the central SQL database, that supposedly has support for storing and retrieving objects to/from the SQL database. This has many potential ACR uses, including making p-storage centralized, even potentially allowing use of SQL for the character vault eventually, depending.

There are important questions that need to be investigated, such as whether the retrieval/storage routines perform well enough to work in realtime (OnOpen / OnClose on a fully stocked p-chest, for example) without causing lag- but this is a big boost to our ACR infrastructure.

the link for the post with the new plugin is here:
http://www.nwnx.org/phpbbforum/viewtopic.php?t=1021

some follow-up discussion is here:
http://www.nwnx.org/phpbbforum/viewtopic.php?t=1031

Cipher, is this one you want to tackle? I'm into crunch-time on my thesis and manuscript, so I can't commit to any serious coding projects until I get that sorted out.
User avatar
ç i p h é r
Retired
Posts: 2904
Joined: Fri Oct 21, 2005 4:12 pm
Location: US Central (GMT - 6)

Post by ç i p h é r »

Nice discovery AL. I'll check it out.
Locked