Graal Forums  

Go Back   Graal Forums > Development Forums > Future Improvements
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 07-19-2008, 10:28 AM
Inverness Inverness is offline
Incubator
Inverness's Avatar
Join Date: Aug 2004
Location: Houston, Texas
Posts: 3,613
Inverness is a jewel in the roughInverness is a jewel in the rough
MySQL for NPC-Server

I've always been lamenting about how I need some kind of unified database system to organize all the stuff on Valikorlia. So as I worked on the new Approvals Database for the server I had the sudden thought:

This thread is a request for a MySQL server on the same computer that hosts the Playerworld itself that can be accessed by script.

Having the MySQL server on the same computer as the NPC-Server is a requirement for obvious reasons.

Also the database file(s) should be accessible with the file browser for easy backup or modification.

If this is not feasible due to communication time between the NPC-Server and MySQL or some other reason, then perhaps adding database features to the NPC-Server itself would be a better idea.

Edit: Inverness thinks SQLite is a better idea now
__________________

Last edited by Inverness; 07-19-2008 at 12:46 PM..
Reply With Quote
  #2  
Old 07-19-2008, 10:40 AM
Elk Elk is offline
Sr Marketing Strategist
Elk's Avatar
Join Date: Nov 2005
Location: Deerland
Posts: 3,829
Elk has a brilliant futureElk has a brilliant futureElk has a brilliant futureElk has a brilliant futureElk has a brilliant futureElk has a brilliant futureElk has a brilliant future
Send a message via ICQ to Elk Send a message via AIM to Elk Send a message via MSN to Elk Send a message via Yahoo to Elk
MySQL would be perfect for monitoring/managing stuff :O I agree
__________________
iEra IGN: *Elk (Darkshire)
iCla. IGN: *Elk (Darkshire)
iZone IGN: *Elk (Darkshire)




Reply With Quote
  #3  
Old 07-19-2008, 11:04 AM
Darklux Darklux is offline
Petrification of a Newbie
Darklux's Avatar
Join Date: Dec 2002
Location: Dortmund, Germany
Posts: 1,375
Darklux is a jewel in the roughDarklux is a jewel in the rough
Send a message via ICQ to Darklux Send a message via AIM to Darklux Send a message via Yahoo to Darklux
Well you could just take a sqlite db too which could run along the gservers (doesnt take alot of processor time afaik)
Reply With Quote
  #4  
Old 07-19-2008, 11:27 AM
Inverness Inverness is offline
Incubator
Inverness's Avatar
Join Date: Aug 2004
Location: Houston, Texas
Posts: 3,613
Inverness is a jewel in the roughInverness is a jewel in the rough
Quote:
Originally Posted by Darklux View Post
Well you could just take a sqlite db too which could run along the gservers (doesnt take alot of processor time afaik)
Whatever works.

Maybe there is some opensource SQL code out there that Stefan can glue onto the NPC-Server.
__________________
Reply With Quote
  #5  
Old 07-19-2008, 11:43 AM
Admins Admins is offline
Graal Administration
Join Date: Jan 2000
Location: Admins
Posts: 11,693
Admins has much to be proud ofAdmins has much to be proud ofAdmins has much to be proud ofAdmins has much to be proud ofAdmins has much to be proud ofAdmins has much to be proud of
Graal already supports mysql, but the setup for each server would be too much work, so it would make more sense to also add sqlite support. Skyld said he could script a browser for it so that you can watch the data easily.
Reply With Quote
  #6  
Old 07-19-2008, 11:48 AM
Inverness Inverness is offline
Incubator
Inverness's Avatar
Join Date: Aug 2004
Location: Houston, Texas
Posts: 3,613
Inverness is a jewel in the roughInverness is a jewel in the rough
SQLite sounds better now that I've looked at it. So do you plan on adding it to the NPC-Server?

It looks like something you could do without having to update client so I hope its added soon.
__________________
Reply With Quote
  #7  
Old 07-19-2008, 01:55 PM
Skyld Skyld is offline
Script-fu
Skyld's Avatar
Join Date: Jan 2002
Location: United Kingdom
Posts: 3,914
Skyld has much to be proud ofSkyld has much to be proud ofSkyld has much to be proud ofSkyld has much to be proud ofSkyld has much to be proud ofSkyld has much to be proud of
Send a message via AIM to Skyld
Quote:
Originally Posted by Inverness View Post
SQLite sounds better now that I've looked at it. So do you plan on adding it to the NPC-Server?
We have discussed it and SQLite will be added in the future yes.
Reply With Quote
  #8  
Old 07-19-2008, 02:14 PM
Twinny Twinny is offline
My empire of dirt
Twinny's Avatar
Join Date: Mar 2006
Location: Australia
Posts: 2,422
Twinny is just really niceTwinny is just really nice
Send a message via AIM to Twinny
Quote:
Originally Posted by Skyld View Post
We have discussed it and SQLite will be added in the future yes.
w00t
Reply With Quote
  #9  
Old 07-19-2008, 02:15 PM
Inverness Inverness is offline
Incubator
Inverness's Avatar
Join Date: Aug 2004
Location: Houston, Texas
Posts: 3,613
Inverness is a jewel in the roughInverness is a jewel in the rough
ETA anyone?
__________________
Reply With Quote
  #10  
Old 07-19-2008, 07:42 PM
cbk1994 cbk1994 is offline
the fake one
cbk1994's Avatar
Join Date: Mar 2003
Location: San Francisco
Posts: 10,718
cbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond repute
Send a message via AIM to cbk1994
Quote:
Originally Posted by Inverness View Post
ETA anyone?
It'll be done tomorrow, but they will wait two years to release it, so we don't forget about it.

EDIT: Also, couldn't help thinking of this:

http://forums.graalonline.com/forums...ad.php?t=74504
__________________
Reply With Quote
  #11  
Old 07-19-2008, 07:49 PM
DustyPorViva DustyPorViva is offline
Will work for food. Maybe
DustyPorViva's Avatar
Join Date: Sep 2003
Location: Maryland, USA
Posts: 9,589
DustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond reputeDustyPorViva has a reputation beyond repute
Send a message via AIM to DustyPorViva Send a message via MSN to DustyPorViva
Ya, never ask for an ETA around here, it's better to just never expect it.
Reply With Quote
Reply

Tags
data, scripting, sql, valikorlia

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 07:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Copyright (C) 1998-2019 Toonslab All Rights Reserved.