search

NivixX / NDatabase

💾 NDatabase is a lightweight and easy to use indexed key-value store database framework mainly aimed for minecraft bukkit/spigot servers and is multi-platform
MIT License
48 stars 2 forks source link

Question NDatabase vs ActiveJDBC #9

Closed CreaCloudz closed 1 year ago

CreaCloudz commented 1 year ago

Hello,

What are the advantages that NDatabse will bring me compared to ActiveJDBC because I have a lot of users in a single table with a lot of information in JSON that I process with JSON_TABLE to make classifications ETC

NivixX commented 1 year ago

Hello, I didn't knew the existence of ActiveJDBC before you mention it, but from what I've seen it's pretty similar to NDatabase. The way you construct your data model instance is different though, and ActiveJDBC doesn't use dao classes, some will prefer this approach some not (but it doesn't change the performances).

For now it looks like ActiveJDBC have more feature (especially to query your data with support of limit offset). However NDatabase support MongoDB which is the database I would always recommend if you adopt a NoSQL approach operating JSON document, because first, it's more performant, and second, using "JDBC/Rel database" to store a JSON is actually an anti-pattern. Also, NDatabase can run as a plugin, it mean that you can just drag a drop the .jar and use the API in every of your plugin without extra configuration for each plugin, and NDatabase will share a connection and thread pool which is quite convinient.

So I would suggest you to try both, but NDatabase doesn't have complete queries features yet.

CreaCloudz commented 1 year ago

I will therefore for the moment remain on ActiveJDBC and SQL moreover anti patern is not really true because MySQL specifies that more and more they want this turned on an alternative of SQL and NoSQL in one