Storing Lists

polly-gone

I am making a browser-based medieval strategy game, and one feature will be route plotting. When you send out an attack, you will be able to choose it's specific route. The route will be laid out using AJAX, but I want to know the best way to store it. Each main town is going to have it's center set at a (#,#) integer coordinate, but paths might deviate from towns as much as (#.1,#.1). I need a way to store my route in a Database. Would using Longtext and just having the route in as a list ([0.0,0.0],[0.5,0.5]) be an effective method? Any other ways of storing it?

Thanks,

-Nick Smile

LukeakaDanish

I recommend storing it as JSON...that way it will be easily accessible when you need to read it with AJAX again...

polly-gone

I'm sorry.... JSON? I'm not familiar.

-Nick Smile

Star Wars Fanatic

sonam

If you are using Ajax then you can use any type of DB. I am prefer MySql and PHP but I don't know is it faster or better then JSON.

Sonam

LukeakaDanish

sonam