View previous topic :: View next topic |
Author |
Message |
doxic
Joined: 07 Oct 2008 Posts: 13
|
Posted: Mon May 04, 2009 13:27 Post subject: ODBC 2 - SQLite 3.2+ Support? |
|
|
First of all, hello
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 |
|
|
Fireboar
Joined: 17 Feb 2008 Posts: 323
|
Posted: Mon May 04, 2009 17:19 Post subject: |
|
|
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 |
|
|
doxic
Joined: 07 Oct 2008 Posts: 13
|
Posted: Sat May 16, 2009 16:25 Post subject: |
|
|
Well, its not that important to me.
Just wanted to know, if it was possible to do, but I dont really need it
but thanks anyway;) |
|
Back to top |
|
|
Gryphyn
Joined: 20 Jan 2005 Posts: 431
|
Posted: Sun May 17, 2009 2:02 Post subject: |
|
|
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
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 |
|
|
|