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 
 
MySQL Better Support?

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Linux development
View previous topic :: View next topic  
Author Message
GodBeastX



Joined: 09 Aug 2006
Posts: 65

PostPosted: Thu Oct 26, 2006 19:44    Post subject: MySQL Better Support? Reply with quote

I'm sure someone made a change for this scenario, but I'm basically using NWNX2 out of the box. In the MySQL world you get a result handle as a return from a SELECT operation and all your fetches you pass in the handle. In NWNX2 you call the ODBC plugin which basically seems to use the last result of a query for the fetches.

Basically nested queries jack up cuz of the above. Has anyone made any ODBC changes to allow nested queries? Or should I Start making my own MySQL plugin?
Back to top
View user's profile Send private message
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1058
Location: Germany

PostPosted: Sun Nov 26, 2006 20:35    Post subject: Reply with quote

I am not aware of a modification like this in NWNX2.

In NWNX4, it is possible to call statements like INSERT or UPDATE without overwriting the old result set, among other changes that improve performance. Maybe someone could make a backport from the current NWNX4 SQL plugins to the NWNX2 odbc plugins for Linux and Windows ?

Unfortunately, I do not have enough resources to do this on my own.
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
virusman



Joined: 30 Jan 2005
Posts: 1017
Location: Russia

PostPosted: Tue Nov 28, 2006 14:53    Post subject: Reply with quote

I could.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1058
Location: Germany

PostPosted: Tue Nov 28, 2006 15:45    Post subject: Reply with quote

You might want to get acquainted with the current NWNX4 sources first, which are still under heavy modification. If they get more stable, a backport to NWN1 would be really nice !
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
FunkySwerve



Joined: 02 Jun 2005
Posts: 377

PostPosted: Tue Nov 28, 2006 18:57    Post subject: Reply with quote

This would be VERY nice. For my player market, I had to write SELECT returns as local psuedoarrays so that I could make other calls using the SELECT data.
Funky
Back to top
View user's profile Send private message
virusman



Joined: 30 Jan 2005
Posts: 1017
Location: Russia

PostPosted: Tue Nov 28, 2006 22:37    Post subject: Reply with quote

Papillon wrote:
You might want to get acquainted with the current NWNX4 sources first, which are still under heavy modification. If they get more stable, a backport to NWN1 would be really nice !
I'll look through them, but most likely I'll just modify NWNX2-ODBC, not backport it from NWNX4.
Since I'm staying with NWN1 for the next year or so, I'll try to port NWNX4 and/or its plugins to NWN1 if they are useful and stable.
Maybe I'll make something for NWNX4 (port nwnx_chat, for example) too.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
FunkySwerve



Joined: 02 Jun 2005
Posts: 377

PostPosted: Tue Nov 28, 2006 23:56    Post subject: Reply with quote

virusman wrote:

Maybe I'll make something for NWNX4 (port nwnx_chat, for example) too.

Yes PLEASE. Very Happy I'll beg if needed. Shocked
Funky
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Linux development 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