MySQL or SQLight on Linux Server?

[Gerrath]

I'm in the process of setting up a persistent world and need to incorporate a database. The database will be used quite a bit as I plan to have the PCs actions on a regular basis effect their future.

I also have planned to, with PHP, access the dbase and display real-time data on a webpage/forum for the players to see.

Is this too big of a project for SQLight? should I use MySQL instead? I'm familiar with MySQL but I'm concerned since it is not as fast as SQLight. Is the speed difference very noticeable in game? Obviously the last question is depended on how much the dbase is used but assume it is used but I'm just trying to get a feel of the speed differences in real-time play.
Regards,
Gerrath

[Acrodania]

If you use SQLite you will have to add support for version 3 (which NWNX uses) to PHP yourself. PHP 5 only has support for version 2.

Personally I prefer MySQL for the simple reason is you can connect to it via remote utilities, use webservers that aren't housed on the same server, etc. SQLite cannot be accessed remotely. I find it much easier to administrate.

Hopefully someone will write a server process some day that allows SQLite to be accessed from another location but until then its use is limited.

There is a difference in speed but as long as you aren't being silly about things it shouldn't be noticeable

[Parsec]

Not being very familiar with SQLite, I would still suggest using MySql also for similar reasons.

The world I host is currently done this way with nwn and apache being on different servers and the player database is updated every 60 seconds for web activities.

I see little problem with using MySQL. I think you will find most of the slowdown will occur within nwn itself executing all your scripts rather then the minimal difference in time it takes to return a query via either MySQL or SQLite.

[Papillon]

I did not know there was a SQLite version of the ODBC plugin for Linux ? AFAIK, Linux only supports MySQL.
_________________
Papillon

[Tenkawa]

[katowulf]

Obviously nwnx is fairly pointless for persistent worlds without a db.

Is anyone using NWNX with SQLite or MySQL on linux?

I saw posts that claim to have "ported" this or that sql into linux. Can someone explain how they ported these things, since there is no linux ODBC?

[Acrodania]