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 
 
ODBC 2 - SQLite 3.2+ Support?

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



Joined: 07 Oct 2008
Posts: 13

PostPosted: Mon May 04, 2009 13:27    Post subject: ODBC 2 - SQLite 3.2+ Support? Reply with quote

First of all, hello Smile

I've got a question about the odbc2 plugin in nwnx. I noticed that the databases don't support commands like "alter" which are available in the newer versions of SQLite (Also supported by the SQLite Manager Addon in Firefox).

Here is a quote from the official SQLite Homepage: (Click)
Quote:
After ADD COLUMN has been run on a database, that database will not be readable by SQLite version 3.1.3 and earlier.


Is there any possiblity to implement a newer version of sqlite into the odbc plugin?

Thanks in advance,
doxic
Back to top
View user's profile Send private message
Fireboar



Joined: 17 Feb 2008
Posts: 323

PostPosted: Mon May 04, 2009 17:19    Post subject: Reply with quote

Why don't you just use MySQL instead, if you really need that functionality? Upgrading SQLite is probably too much effort for not enough gain, and having incompatibilities between different versions of the NWNX plugins can lead to some big problems when systems are migrated from one server setup to another.
Back to top
View user's profile Send private message
doxic



Joined: 07 Oct 2008
Posts: 13

PostPosted: Sat May 16, 2009 16:25    Post subject: Reply with quote

Well, its not that important to me.
Just wanted to know, if it was possible to do, but I dont really need it Wink
but thanks anyway;)
Back to top
View user's profile Send private message
Gryphyn



Joined: 20 Jan 2005
Posts: 431

PostPosted: Sun May 17, 2009 2:02    Post subject: Reply with quote

doxic wrote:
Well, its not that important to me.
Just wanted to know, if it was possible to do, but I dont really need it Wink
but thanks anyway;)

Yes it is...but you'll have to do it yourself...
The only catch is that Papillon added an extra 'enum' to the 'post-read' conditions. (the comments in the original source will point the way)
Easiest option is to download the multi-file option (NOT the amalgamated version) from the SQLite website.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows 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