[Question] Conquer Project + MongoDB

09/06/2021 21:37 12tails#1
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!
09/07/2021 20:40 turk55#2
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.


[Only registered and activated users can see links. Click Here To Register...]
09/08/2021 01:24 Yupmoh#3
Quote:
Originally Posted by turk55 View Post
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.


[Only registered and activated users can see links. Click Here To Register...]
This is exactly what I do for Primal Conquer. and by far it's the most solid approach.
09/08/2021 13:10 12tails#4
Quote:
Originally Posted by turk55 View Post
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.


[Only registered and activated users can see links. Click Here To Register...]
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.
09/10/2021 19:41 thisismyaccountokay#5
Cpt Sky's enhanced Copsv6 version on gitlabs utilizes MongoDB for tracking items (and their position)

[Only registered and activated users can see links. Click Here To Register...]


Hope it helps!
09/16/2021 23:55 Deathmist#6
Why would you want NoSQL for a conquer server?
09/17/2021 23:53 CptSky#7
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.
09/29/2021 01:33 tehpwnerer69#8
Quote:
Originally Posted by CptSky View Post
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?