Forums » Community Projects

LUA & Database

Jul 20, 2007 csgno1 link
Anyone have a suggestion for the easiest path to database access via LUA? I'd prefer to use a database like mysql, but I'm easy. A google search only gave me stuff with vague explanations (too vague for me anyway). Not a 'local only' database, access via TCP/IP preferred so the database(s) could be shared by a guild or be public maybe. I'd like to not lose a lot of time bumping into walls so if someone can point me in the right direction I would be grateful.

Thanks for any advice
Jul 20, 2007 Scuba Steve 9.0 link
Inside VO, you can't get database access. I sort have a stigma against external programs modifying VO(There's a whole rape and puppetry analogy there) so am sort of useless if you're looking for lua stuff outside of VO.
Jul 20, 2007 csgno1 link
No, wanted to make a VO addon that reads an external database.
Jul 21, 2007 Scuba Steve 9.0 link
Can't do right now. Maybe when the devs let us use luasockets.
Jul 21, 2007 moldyman link
When they do, relay bots here we come...
Jul 21, 2007 slime73 link
Jul 21 02:35:03 <vo> Server will restart in 15 minutes: Lightning Mine SF Fix, Station Limit Test, and Lots of other bug fixes
Jul 21 02:35:48 <vo> [100] <Nautargos> so theres lua socket support in here?
Jul 21 02:36:00 <vo> [100] <momerath42> yep
Jul 21, 2007 csgno1 link
So I could make a little middleware app in something like PERL to talk to the database and lua and PERL can talk via sockets, or am I overcomplicating it?
Jul 22, 2007 Demonen link
That's what I would have done. Not that I do... Even if I did, I'd have to keep it a Guild Secret...
Jul 23, 2007 a1k0n link
Hell, that's what we do, sort of.

I need to release details about this I guess.
Jul 23, 2007 csgno1 link
Or something equiv to LWP in perl maybe
Jul 24, 2007 Syylk link
VOKB is an external database, and the VOKB Lua script talks with the DB since ages.

Ask firsm.
Jul 24, 2007 MSKanaka link
VOKB uses an external helper app, Kat. Also, it was written in python, not Lua. It's in the middle of being rewritten.
Jul 24, 2007 csgno1 link
I want to scrap my PERL stuff and rebuild in lua