Lua Scripting+Content Databasing system

[KLS]

I think it's somewhat impractical is all.

Also a few of the developers do have plans to somewhere down the road change up the quest system and the database system but we're not close enough to be ready to talk about it yet.

[Zaela_S]

I like Lua for content databasing for a few reasons:

1) Content data is essentially static -- it only changes when new stuff is put in there, and doesn't really change at runtime. The only thing you really get out of having it be SQL is searchability and the ability to invalidate a whole table in a single brainfart. (Oh, and making sweeping changes, which I guess is nice for this project; I hope to make at least items and spells convertible back and forth from SQL, which would still allow that.)

2) For some things (like the spawnpoint and path grid stuff I put up) open-ended scriptability is a lot simpler than having to add new fields (sometimes new tables) and new code for every little new abstract functionality or feature you want to add.

3) Having everything organized into the folder of the zone it belongs to is nice. Not that e.g. the NPC database could not be changed to include zone and reduce the need for global NPCID numbers, but that's probably one of those "too late to consider changing" things.

Definitely would not want to force anyone to switch. But there are reasons both for and against.

[Davood]

ok so like ive been mia for a while.. this isnt really a thread necro since last post was a month ago.

question:
I noticed in the changelog the following disturbing note:
Now generally the perl system is now considered deprecated (in favor of lua in the long term) I felt this was too big a change to pass up adding when I got it working.

is this official then? Do i need to learn lua? I liked perl+mysql because I could have offline tools to interact with the db server, and I don't wanna learn new tricks.

[KLS]

Deprecated doesn't mean you can't use it if that's what works for you. It's not being removed it's just not going to get the same kind of attention Lua does.

[demonstar55]

This is an unrelated lua project. MySQL is still used, and will be for sometime (I just think it would be cool if we had support for multiple DBs, but I don't think anyone is working on that for now)

[Karayrem]

Since Oracles takeover of Sun, they now owns MySQL which probably will end up being proprietary to some degree. Some of sun developers had left and branch out MySQL into MariaDB.

Perhaps we can take a look at including MariaDB as another database to use with EQEmu.

https://mariadb.org/

[demonstar55]

MariaDB should theoretically just work. There is a lot of reorganization and cleaning up that would be needed to be done to make multiple DBs work nicely.