B4J Question Data Collection Solution and DB

[luke2012]

Hi all,
I'm trying Data Collection Solution by @Erel Tutorial and I see that the solution use a SQLLite db as primary database and it has very good performances.

Thinking about to use a different database, which of the following db is the best in term of performance and support (documentation & community) ?

1) MySQL
2) MongoDB
3) Others ?

for example, think about a client / server solution that should support many concurrent connections and much traffic.

Thanks in advance for your reply

 

[LucaMs]

MS Sql Server
MySQL

 

[EnriqueGonzalez]

Both lucas mentioned and i would add MariaDB

The thurth is almost any is going to give you what you want.

 

[LucaMs]

MS Sql Server tools are powerful; maybe it works only with IIS (?).

 

[EnriqueGonzalez]

MS Sql Server tools are powerful; maybe it works only with IIS (?).

No, it will work without issue with java but integrated security is difficut, it is better to use it with normal sql users

 

[luke2012]

Both lucas mentioned and i would add MariaDB

The thurth is almost any is going to give you what you want.

I see that it was created by the same developer that developed MySQL Interesting ... I have to try it!

 

[luke2012]

Both lucas mentioned and i would add MariaDB

The thurth is almost any is going to give you what you want.

Which are the main difference between MySQL and MariaDB ?

 

[Harris]

difference between MySQL and MariaDB

https://softwareengineering.stackex...hats-the-difference-between-mariadb-and-mysql

 

[LucaMs]

MySQL and MariaDB? I would opt without doubts for the first one.

 

[Harris]

MySQL and MariaDB? I would opt without doubts for the first one.

That's what I use (MySQL) and it is quite stable... No issues in Windows or Linux.

 

[EnriqueGonzalez]

I always use mariaDB for my new projects.

both were created by the same guy but mariaDB is the "in case Oracle goes mad" version.

mariaDB is in some cases faster, has some additional features and its development is also faster than mySQl, their stable branch updates quite quickly compared to MySQL

For example, CREATE TABLE IF NOT EXISTS is a sentence i use a lot, but it arrived first to MariaDB and later much later to MySQL

Another example of MariaDB vs MySQL is Galera...

it is a master to master server replication, it means you can have 2 servers each with an instance of mariaDB both being redundant and having the same information. and you can do this with... like 5 steps.

 

[luke2012]

I always use mariaDB for my new projects.

both were created by the same guy but mariaDB is the "in case Oracle goes mad" version.

mariaDB is in some cases faster, has some additional features and its development is also faster than mySQl, their stable branch updates quite quickly compared to MySQL

For example, CREATE TABLE IF NOT EXISTS is a sentence i use a lot, but it arrived first to MariaDB and later much later to MySQL

Another example of MariaDB vs MySQL is Galera...

it is a master to master server replication, it means you can have 2 servers each with an instance of mariaDB both being redundant and having the same information. and you can do this with... like 5 steps.

WOW! Very Interesting! I think I first try the MariaDB.

@LucaMs I'm curious about your comment. Why I told that you prefer MySQL (without doubt) instead MariaDb?

 

[LucaMs]

@LucaMs I'm curious about your comment. Why I told that you prefer MySQL (without doubt) instead MariaDb?

I don't know MariaDB but I think it is an open source version of MySQL, on which many people will get their hands on. I fear future incompatibilities.

Furthermore, usually the original is better.

 

[Harris]

I don't know MariaDB

Follow the link in post 8. It explains the diff...

 

[luke2012]

I don't know MariaDB but I think it is an open source version of MySQL, on which many people will get their hands on. I fear future incompatibilities.

Furthermore, usually the original is better.

https://softwareengineering.stackex...hats-the-difference-between-mariadb-and-mysql

From that link I can read... "To my understanding MariaDB is maintained and enhanced by the original MySQL developers, and MySQL is maintained and enhanced by Oracle. It depends on who you want to do that job".

It seem that the parallel project "MariaDB" is maintained directly from the original dev team not by Oracle.
From my point of view this should be benefit (maintained and enhanced by the original MySQL developer)

 

[DonManfred]

Additionally you need to know that MySQL used in a business need a License.

 

[LucaMs]

It seem that the parallel project "MariaDB" is maintained directly from the original dev team not by Oracle.
From my point of view this should be benefit (maintained and enhanced by the original MySQL developer)

My point of view is exactly the opposite; I think people trust more in a big house than in some former employee.

Additionally you need to know that MySQL used in a business need a License.

Professional things are expensive, they are not free.