From MariaDB to MYSQL DB

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

From MariaDB to MYSQL DB

Postby artimann » 17. December 2016 12:37

Hello,

2 weeks ago I updated my XAMPP to new version because of PHP version. Then I noticed about new DB which is MARIADB. Ok this is faster DB engine and more effective BUT there is a different between MYSQL DB and MARIA DB. Now I working on my project and I need to work with MYSQL DB because the syntax is different and results between those engines is different. So the question how I can use new version of XAMPP with MYSQL DB without MARIA?
artimann
 
Posts: 4
Joined: 17. December 2016 12:27
XAMPP version: 3.2.2
Operating System: Windows 10

Re: From MariaDB to MYSQL DB

Postby Altrea » 17. December 2016 13:39

artimann wrote:I need to work with MYSQL DB because the syntax is different and results between those engines is different.

Which syntax differents do you mean exactly? Can you give examples?

artimann wrote:So the question how I can use new version of XAMPP with MYSQL DB without MARIA?

Install MySQL as single application. MySQL is loosly coupled. But you cannot start/stop this MySQL with the XAMPP control panel.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: From MariaDB to MYSQL DB

Postby Nobbie » 17. December 2016 13:52

artimann wrote:Ok this is faster DB engine and more effective BUT there is a different between MYSQL DB and MARIA DB. Now I working on my project and I need to work with MYSQL DB because the syntax is different and results between those engines is different.


I did not know that, i have a Xampp / MariaDB Installation and installed some well known CMS (like WordPress) and Forumscripts (SMF for example) and all these are running flawlessly in the MySQL flavour. I wouldnt recognize that there is MARIADB instead of MYSQL, if did not know it.

So what is your concern, why does your script recognize differences between MariaDB and MySQL, whereas such complex things like WordPress are running out of the box?
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: From MariaDB to MYSQL DB

Postby artimann » 17. December 2016 14:47

Nobbie wrote:
artimann wrote:Ok this is faster DB engine and more effective BUT there is a different between MYSQL DB and MARIA DB. Now I working on my project and I need to work with MYSQL DB because the syntax is different and results between those engines is different.


I did not know that, i have a Xampp / MariaDB Installation and installed some well known CMS (like WordPress) and Forumscripts (SMF for example) and all these are running flawlessly in the MySQL flavour. I wouldnt recognize that there is MARIADB instead of MYSQL, if did not know it.

So what is your concern, why does your script recognize differences between MariaDB and MySQL, whereas such complex things like WordPress are running out of the box?


Try to build your own system or install some serous cmd like Magento or Dolphin and then you will understand what I'm talking about.

Altrea wrote:
artimann wrote:I need to work with MYSQL DB because the syntax is different and results between those engines is different.

Which syntax differents do you mean exactly? Can you give examples?

artimann wrote:So the question how I can use new version of XAMPP with MYSQL DB without MARIA?

Install MySQL as single application. MySQL is loosly coupled. But you cannot start/stop this MySQL with the XAMPP control panel.


Ok tnx I'll try to do so.
If you want example, try to JOIN 4 tables then ORDER your rows only from 1 table, then GROUP and then choose only unique rows when the LAST ROW is first in ONE query. Then you will understand that you will never get this result only because this is MARIA DB.
artimann
 
Posts: 4
Joined: 17. December 2016 12:27
XAMPP version: 3.2.2
Operating System: Windows 10

Re: From MariaDB to MYSQL DB

Postby Nobbie » 17. December 2016 18:15

artimann wrote:Try to build your own system or install some serous cmd like Magento or Dolphin and then you will understand what I'm talking about.


Ok, i just downloaded and installed Magento-CE-2_1_3_zip-2016-12-16-06-04-03.zip (i think its the latest) and already succeeded to install it including a sample data. I now can see a "dashboard" (after i logged in with my Administrator account what i have been asked to create), but unfortunately i dont know anything about Magento.

But it installs and runs flawlessly, as WordPress and Joomla and SMF as well. So sorry, i still dont understand what you are talking about?! I am running Xampp 7.0.9 including MariaDB 10.1.16 and PHP 7.0.9 in a 64bit environment under Linux Mint 18. Runs like a charme.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: From MariaDB to MYSQL DB

Postby Altrea » 17. December 2016 20:15

artimann wrote:If you want example, try to JOIN 4 tables then ORDER your rows only from 1 table, then GROUP and then choose only unique rows when the LAST ROW is first in ONE query. Then you will understand that you will never get this result only because this is MARIA DB.

I see. These kind of problems are often caused by exotic SQL constructs, especially these ones which are not SQL Standard compliant. So it can be true that MySQL acts a little bit different in such cases compaired with other SQL Database Management Systems.
But that is not a MariaDB problem per se. It can also happen that future MySQL versions changes its behavior in for such statements.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: From MariaDB to MYSQL DB

Postby Nobbie » 17. December 2016 22:20

artimann wrote:If you want example, try to JOIN 4 tables then ORDER your rows only from 1 table, then GROUP and then choose only unique rows when the LAST ROW is first in ONE query. Then you will understand that you will never get this result only because this is MARIA DB.


Could you give a SELECT for that (its easier and i am not sure, if i got it right)? But it sounds, as it results in an invalid SQL Select statement and of course it is a known problem, that different SQL Engines behave different on invalid syntax. But if it is invalid (non-ANSI) SQL, the problem is not the SQL Engine, the problem is the invalid Select.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: From MariaDB to MYSQL DB

Postby artimann » 17. December 2016 22:46

Nobbie wrote:
artimann wrote:If you want example, try to JOIN 4 tables then ORDER your rows only from 1 table, then GROUP and then choose only unique rows when the LAST ROW is first in ONE query. Then you will understand that you will never get this result only because this is MARIA DB.


Could you give a SELECT for that (its easier and i am not sure, if i got it right)? But it sounds, as it results in an invalid SQL Select statement and of course it is a known problem, that different SQL Engines behave different on invalid syntax. But if it is invalid (non-ANSI) SQL, the problem is not the SQL Engine, the problem is the invalid Select.


I don't really think that you try to understand, its feels like you trying to prove something. In maria db you cannot use MAX function in select section because you will get syntax error. Also you cannot use ORDER before GROUP section - again you will get syntax error. You can try to ORDER inside FROM section (which is work perfect in MYSQL) but you will get wrong row from your db because MARIADB just ignore your sub-query and the result you will get wrong row if you need get last row as first. This is just a piece of things that you cannot do in maria db which is work perfect in MYSQL with INNODB.
artimann
 
Posts: 4
Joined: 17. December 2016 12:27
XAMPP version: 3.2.2
Operating System: Windows 10

Re: From MariaDB to MYSQL DB

Postby Altrea » 17. December 2016 23:06

I don't really think that you try to understand, its feels like you trying to prove something.

I start to believe the only thing you want is that i agree with your very own opinion. I don't want to prove anything, i want to open your mind for alternative ways solving your problem. At the end it is your own problem and you decide which way to go. But i will always tell my own opinion. And in my opinion your way of solving this problem would not be mine.

artimann wrote:In maria db you cannot use MAX function in select section because you will get syntax error.

really? https://mariadb.com/kb/en/mariadb/max/

artimann wrote:Also you cannot use ORDER before GROUP section - again you will get syntax error. You can try to ORDER inside FROM section (which is work perfect in MYSQL) but you will get wrong row from your db because MARIADB just ignore your sub-query and the result you will get wrong row if you need get last row as first. This is just a piece of things that you cannot do in maria db which is work perfect in MYSQL with INNODB.

Exactly what i said. https://mariadb.com/kb/en/mariadb/why-i ... y-ignored/
Just because MySQL get the expected result does not mean it is clean from SQL standard point of view.

You should never take a look into PostgreSQL, because it is far more SQL standard compliant than MySQL and MariaDB :lol:
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: From MariaDB to MYSQL DB

Postby artimann » 17. December 2016 23:41

Altrea wrote:
I don't really think that you try to understand, its feels like you trying to prove something.

I start to believe the only thing you want is that i agree with your very own opinion. I don't want to prove anything, i want to open your mind for alternative ways solving your problem. At the end it is your own problem and you decide which way to go. But i will always tell my own opinion. And in my opinion your way of solving this problem would not be mine.

artimann wrote:In maria db you cannot use MAX function in select section because you will get syntax error.

really? https://mariadb.com/kb/en/mariadb/max/

artimann wrote:Also you cannot use ORDER before GROUP section - again you will get syntax error. You can try to ORDER inside FROM section (which is work perfect in MYSQL) but you will get wrong row from your db because MARIADB just ignore your sub-query and the result you will get wrong row if you need get last row as first. This is just a piece of things that you cannot do in maria db which is work perfect in MYSQL with INNODB.

Exactly what i said. https://mariadb.com/kb/en/mariadb/why-is-order-by-in-a-from-subquery-ignored/
Just because MySQL get the expected result does not mean it is clean from SQL standard point of view.

You should never take a look into PostgreSQL, because it is far more SQL standard compliant than MySQL and MariaDB :lol:


Absolutely not. I don't need your agree with my opinion. I just ask how I can use mysql instead maria db that it. And yes - REALLY it isn't work. I spend 2 days to build query which is work perfect in mysql, TONS of solutions from many people from stack overflow - and when I start to believe that I do something wrong only one person told me check my DB engine, and when I run same query in MYSQL everything work PERFECT!!! I spend 2 days to solve problem which is not exists in my SQL query, only because I used this stupid maria db which based on MYSQL. I spend 2 days of work for nothing. If I understand correct I with 100 other people from stack overflow isn't understand SQL... Well thank you but I'll use a normal MYSQL without any useless extensions like maria..
artimann
 
Posts: 4
Joined: 17. December 2016 12:27
XAMPP version: 3.2.2
Operating System: Windows 10

Re: From MariaDB to MYSQL DB

Postby Nobbie » 17. December 2016 23:57

artimann wrote:I don't really think that you try to understand,


No, already got it. You dont have much knowledge about SQL and replace missing skill by trolling around. I am not interested any more in helping you, i got everything working and you may continue to troll around. Have a nice christmas anyway, bye!
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: From MariaDB to MYSQL DB

Postby Altrea » 18. December 2016 00:45

artimann wrote:If I understand correct I with 100 other people from stack overflow isn't understand SQL...

That is the real problem, you are not able to understand very good instead you voice assumptions. I cannot tell anything about any intention on stackoverflow replies or topics, because you don't told us where we can find this stackoverflow topics of you (which by the way is a very bad way to use free community driven community boards).
But if i would guess into the blue (relating on the way you write your replies here) your problem description and way of using helpful replies is misleading.
And this was for sure the last reply you get from me too.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: From MariaDB to MYSQL DB

Postby Programit » 21. October 2017 00:01

MariaDB DOESN'T work with Workbench, a major tool used for more complex database development.
MariaDB has many incompatibilities and issues and limited tooling for developers.
I have yet to see any commercial servers and VPS providers offer MariaDB as standard, there fore apps break when uploaded.
Xampp has always been a great tool for web dev on the go, and now, due to politics, is shooting itself in the foot.
Why not offer a version with the TRUE MySQL server, not a half baked rehash.
Programit
 
Posts: 6
Joined: 18. October 2017 06:55
XAMPP version: 7.1
Operating System: Windows 10


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 13 guests