1

Topic: DB and server side for strategy

I write strategic game a-lja
http://www.tribalwars.net/, only more dynamical. The client svg+js, and here with the server was not defined yet. In game there will be many cities (some thousand) between which the set of armies (ten thousand armies) will be moved. . there will be rather intensive update of a DB. The German toy, as far as I know, on the server uses php + MySql. I think, whether to try node js instead of php. From MySql, probably not to leave, as relational basis is better approaches in this case. I am afraid of brakes node.js or complexity with its programming) With gratitude I will accept any councils and .

2

Re: DB and server side for strategy

Hello, RMobile, you wrote:

RM> I Write strategic game a-lja
http://www.tribalwars.net/, only more dynamical. The client svg+js, and here with the server was not defined yet.
RM> The German toy, as far as I know, on the server uses php + MySql. I think, whether to try node js instead of php.


There are many fine languages. Nobody forces to walk smack in .

RM> In game there will be many cities (some thousand) between which the set of armies (ten thousand armies) will be moved. . there will be rather intensive update of a DB.


It not an intensity index.

Army relocation is a process. It has beginning and duration. For obtaining of position of army it is enough to count position at time present situation. For best accuracy it is possible to save a route.

RM> From MySql, probably not to leave,


postgres?

RM> as relational basis is better approaches in this case.


Why suddenly? nosql too here approaches. But I will not tell that it is pleasant to me.

RM> I Am afraid of brakes node.js or complexity with its programming)


Be afraid that game you will not add.

3

Re: DB and server side for strategy

F> there are many fine languages. Nobody forces to walk smack in .

Began with the client and so it was pleasant to write on JS that would not be desirable to stop)

F> it not an intensity index.
F> army relocation is a process. It has beginning and duration. For obtaining of position of army it is enough to count position at time present situation. For best accuracy it is possible to save a route.

Truly, if  a specification is the orders, everyone is fulfilled certain time. . the DB task quickly to add/delete orders and to do their samplings.

F> postgres?
F> why suddenly? nosql too here approaches. But I will not tell that it is pleasant to me.

Not strongly I understand a question if nosql bases quickly delete and add records it is possible and on them.

F> be afraid that game you will not add.

It is exact. One more not complete project
big_smile