[Question] Conquer Project + MongoDB

[12tails]

Hey guys!

I know the forum is a bit dead, but, there are some incredible coders here yet.

I was checking the possibility to use MongoDB with the Conquer project, has someone already done it? I've made some tests and the results seems pretty nice...

If someone has a feedback (Good or not) i would like to hear.

Thanks,
Hope you all are safe and fine!

[turk55]

Hi

I have done it and it certainly is possible.
However, MongoDB is more meant for high throughput of structured data documents.
Things like continuously logging data is more what it is meant for.

I suggest you stick to a relation database for the main data and use MongoDB in case of logging.

[Yupmoh]

Originally Posted by turk55

Hi

I have done it and it certainly is possible.
However, MongoDB is more meant for high throughput of structured data documents.
Things like continuously logging data is more what it is meant for.

I suggest you stick to a relation database for the main data and use MongoDB in case of logging.

This is exactly what I do for Primal Conquer. and by far it's the most solid approach.

[12tails]

Originally Posted by turk55

Hi

I have done it and it certainly is possible.
However, MongoDB is more meant for high throughput of structured data documents.
Things like continuously logging data is more what it is meant for.

I suggest you stick to a relation database for the main data and use MongoDB in case of logging.

Nice, that was the idea!

The database of the version i'm working on is big, so i was thinking exactly about it.

Maybe i'll do the same for the npc/monster/item action scripts, not sure yet.

[thisismyaccountokay]

Cpt Sky's enhanced Copsv6 version on gitlabs utilizes MongoDB for tracking items (and their position)




Hope it helps!

[Deathmist]

Why would you want NoSQL for a conquer server?

[CptSky]

From my experience, there isn't much gains in using NoSQL for a Conquer server. Might have one or two use cases, but most data is best stored in a traditional SQL database.

[tehpwnerer69]

Originally Posted by CptSky

From my experience, there isn't much gains in using NoSQL for a Conquer server. Might have one or two use cases, but most data is best stored in a traditional SQL database.

I personally would say that SQLite reigns supreme due to the transaction speed

Has anyone actually implemented an sqlite3 solution for co2 servers?