NWNX2 or SQL or both?

[archer4217]

Hi all,

Our mod has been having issues with date and time so I decided we need a better database than the default nwn one.

My question is, will NWNX2 be sufficient or is SQL needed as well?

Thank in advance.

[MaxRock]

You can't really have one without the other:
NwNX2 (more specifically one of its plug ins) provides scripting functionality to access a database other than the default bioware one; e.g: MySQL, SQLite or MSSQL.
So you'll have to get the nwnx base which comes with database (odbc) functionality for MySQL and SQLite. Then you will have to set up the database itself

[Zebranky]

The "better database" you're looking for *is* SQL (more properly, a DB using SQL, such as MySQL or SQLite). NWNX just allows you to access that database from NWN (and it can do many other things, but that's another story).
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?

[archer4217]

Thank you both, and hi there Zebranky, long time-no see. You might not remember me, but you and others used to help me a lot in Mirc. I ended up scrapping the old mod and starting a new one, then had to wipe my drive, then got a new computer and couldn't remember how to find you guys again.

So, I'll go ahead and download sqlite.

Thanks again. I'm sure I'll come begging for more help.

[archer4217]

Ok, so I downloaded sqlite from here http://www.sqlite.org/download.html
got the recommended amalgamation and opened up the zip and found these 3 files: sqlite 3.c, sqlite 2.h, sqlite3ext.h

Where should I put them?

[Gryphyn]

[Fireboar]

Yes, basically if you want to use SQLite, you don't need anything except NWNX2 and the nwnx_odbc plugin.

[Asparius]

Hmmm if I recall, SQLite embedded in NWNX was outdated - is it fixed at this moment?

[Fireboar]

Not that I know of - SQLite is not a great solution in any case - if you just want SQL functionality for variable or object storage then SQLite is fine. If you want to run a proper server on it, then installing MySQL is a better option.