[Maria-discuss] MySQL Workbench Fork?
I convinced my boss to use MariaDB for a new project but it appears that the workbench is incompatible with new features of MariaDB. I've looked at the alternatives listed on the website, but they are all either proprietary or Windows only. I just can't sell my boss on switching to MariaDB without workbench. Free software isn't free, but I think Workbench is a big driver of commercial and enterprise use. It's easy to kvetch from the outside, but I feel as though MariaDB has just lost some ground. Has management considered forking Workbench? Thank you, -Zach Lym
Totally agree. It's an necessary part for us. So many features missing. Tired of their warning too about mariadb. Steve Fatula On Apr 20, 2017, 2:13 PM -0500, Zach Lym <zachlym@indolering.com>, wrote:
I convinced my boss to use MariaDB for a new project but it appears that the workbench is incompatible with new features of MariaDB. I've looked at the alternatives listed on the website, but they are all either proprietary or Windows only. I just can't sell my boss on switching to MariaDB without workbench.
Free software isn't free, but I think Workbench is a big driver of commercial and enterprise use. It's easy to kvetch from the outside, but I feel as though MariaDB has just lost some ground.
Has management considered forking Workbench?
Thank you, -Zach Lym
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 20.04.2017 um 21:51 schrieb info@smallbusinessconsultingexperts.com:
Totally agree. It's an necessary part for us. So many features missing. Tired of their warning too about mariadb.
what are you need "MySQL Workbench" for? i remember to had it instaleld nearly a decade ago and while maintain dozens of MariaDB instances if have no idea what it ever provided so essential
On Apr 20, 2017, 2:13 PM -0500, Zach Lym <zachlym@indolering.com>, wrote:
I convinced my boss to use MariaDB for a new project but it appears that the workbench is incompatible with new features of MariaDB. I've looked at the alternatives listed on the website, but they are all either proprietary or Windows only. I just can't sell my boss on switching to MariaDB without workbench.
Free software isn't free, but I think Workbench is a big driver of commercial and enterprise use. It's easy to kvetch from the outside, but I feel as though MariaDB has just lost some ground.
Has management considered forking Workbench?
On Apr 20, 2017, at 3:00 PM, Reindl Harald <h.reindl@thelounge.net> wrote:
what are you need "MySQL Workbench" for?
i remember to had it instaleld nearly a decade ago and while maintain dozens of MariaDB instances if have no idea what it ever provided so essential
Need? I suppose that’s not really absolutely true. A GUI is a tool to allow things to be done quicker. It can be used to avoid learning things, but, that’s not the concern necessarily. Keeps a nice history, pre-defined and friendly queries, nice monitoring on multiple systems, I could go on. I see it as similar to saying who needs Windows (which I don’t use but same idea) as opposed to dos. Not entirely of course, but, the idea is to make one more productive. Command line vs GUI. I like how it categorizes system status, variables, tracks client connections, connects to numerous machines using ssh tunnels, etc. I can do most of that without workbench, just slower. It allows me to use my clients machines GUi for organization and filing and archiving of scripts in a faster manner. I connect to so many machines I just find it’s organization useful. But YMMV.
Am 20.04.2017 um 23:05 schrieb Sales:
On Apr 20, 2017, at 3:00 PM, Reindl Harald <h.reindl@thelounge.net> wrote:
what are you need "MySQL Workbench" for?
i remember to had it instaleld nearly a decade ago and while maintain dozens of MariaDB instances if have no idea what it ever provided so essential
Need? I suppose that’s not really absolutely true. A GUI is a tool to allow things to be done quicker. It can be used to avoid learning things, but, that’s not the concern necessarily. Keeps a nice history, pre-defined and friendly queries, nice monitoring on multiple systems, I could go on. I see it as similar to saying who needs Windows (which I don’t use but same idea) as opposed to dos. Not entirely of course, but, the idea is to make one more productive. Command line vs GUI. I like how it categorizes system status, variables, tracks client connections, connects to numerous machines using ssh tunnels, etc. I can do most of that without workbench, just slower. It allows me to use my clients machines GUi for organization and filing and archiving of scripts in a faster manner. I connect to so many machines I just find it’s organization useful. But YMMV.
there don't exist much where you are really faster with a GUI except you don't know how to handle things - what worries me more is a database server which is even open over TCP to the network
Le 21 avr. 2017 à 12:14, Reindl Harald <h.reindl@thelounge.net> a écrit :
Am 20.04.2017 um 23:05 schrieb Sales:
On Apr 20, 2017, at 3:00 PM, Reindl Harald <h.reindl@thelounge.net> wrote:
what are you need "MySQL Workbench" for?
i remember to had it instaleld nearly a decade ago and while maintain dozens of MariaDB instances if have no idea what it ever provided so essential
Need? I suppose that’s not really absolutely true. A GUI is a tool to allow things to be done quicker. It can be used to avoid learning things, but, that’s not the concern necessarily. Keeps a nice history, pre-defined and friendly queries, nice monitoring on multiple systems, I could go on. I see it as similar to saying who needs Windows (which I don’t use but same idea) as opposed to dos. Not entirely of course, but, the idea is to make one more productive. Command line vs GUI. I like how it categorizes system status, variables, tracks client connections, connects to numerous machines using ssh tunnels, etc. I can do most of that without workbench, just slower. It allows me to use my clients machines GUi for organization and filing and archiving of scripts in a faster manner. I connect to so many machines I just find it’s organization useful. But YMMV.
there don't exist much where you are really faster with a GUI except you don't know how to handle things - what worries me more is a database server which is even open over TCP to the network
Agree on those answers but it does not tell us what is broken in compatibility . There is a parameter to fake MySQL handshake may the author of the mail can test this . MariaDB enable sql error plugin to capture are SQL and protocol errors. would be constructive to see what is broken here . /svar Stéphane Varoqui, Senior Consultant Phone: +33 695-926-401, skype: svaroqui http://www.mariadb.com
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I am a part time administrator of a couple of php/sql based web sites. I only have to directly access the database a few times a year when something goes wrong, during server upgrades, or when I occasionally do a bit of development and need to test some queries. I prefer using a GUI because it is usually more intuitive, and I make less mistakes than with the command line interfaces. I use MySQL workbench because I tried a couple of others and didn't like them. I had not noticed any significant incompatibility with Mariadb 10.x, so I would also like to know what those limitations are.
- what worries me more is a database server which is even open over TCP to the network
That does not need to be the case, I connect to my remote servers through an ssh tunnel, so there is no external database port open. it would be nice if this project had its own fork or similar GUI tool, but I imagine that it would be a difficult business case to take on the extra support and testing. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
On Apr 21, 2017, at 5:14 AM, Reindl Harald <h.reindl@thelounge.net> wrote:
there don't exist much where you are really faster with a GUI except you don't know how to handle things - what worries me more is a database server which is even open over TCP to the network
The expected answer, heard the same thing over and over in the past on endless products. Yes, DOS really was great. :-) Of course, the database is no more open than your command line technique since it’s using an ssh tunnel (and thus only access is localhost) and likely you use ssh also for command line access. Unless you are local and the servers are not in a datacenter, which has it’s own set of troubles. Just keep in mind not everyone works in a huge company (I have). There are numerous customers out there running small businesses on open source and they are not up to the level of most people here to say the least. For them, a free admin product is a good thing. Control panel type “admin” systems are awful for the most part. Regarding the heidisql suggestion, it supports very few modern features, it is way too limited. Workbench supports many things heidisql does not. Regarding navicat, I use that on IOS and it seems to work ok. Have not used it on a desktop. But yes, there are paid options. Might try the free trial to see what it does and does not do. Still, as a full mysql replacement, I do agree with the op, workbench should be part of the replacement in an ideal world, it just looks good marketing wise. However, I get that the product takes an entirely different skill set and being multiplatform makes it a bit more difficult. That’s a better reason to make your case. Certainly products like Columnstore are more important. Was not aware of some of the paid options, so, it’s good there is some choice there.
Am 21.04.2017 um 16:13 schrieb Sales:
On Apr 21, 2017, at 5:14 AM, Reindl Harald <h.reindl@thelounge.net> wrote:
there don't exist much where you are really faster with a GUI except you don't know how to handle things - what worries me more is a database server which is even open over TCP to the network
The expected answer, heard the same thing over and over in the past on endless products. Yes, DOS really was great. :-) Of course, the database is no more open than your command line technique since it’s using an ssh tunnel (and thus only access is localhost) and likely you use ssh also for command line access. Unless you are local and the servers are not in a datacenter, which has it’s own set of troubles. Just keep in mind not everyone works in a huge company (I have). There are numerous customers out there running small businesses on open source and they are not up to the level of most people here to say the least. For them, a free admin product is a good thing. Control panel type “admin” systems are awful for the most part
i don't buy that just because i don't work in a huge company, come from windows, started just as php developer and over the years took over the whole administration, ported the whole company from OSX to Linux and guess what the previous OSX "sysadmin" was: a clickmonkey from 2003 to 2008 i learned all the needed things autodidact to took over the whole technical from database, web, mail, network, virtualization, nameservers and what not what i never missed was a desktop GUI for a mysql server....
On Apr 21, 2017, at 10:19 AM, Reindl Harald <h.reindl@thelounge.net> wrote:
i don't buy that just because i don't work in a huge company, come from windows, started just as php developer and over the years took over the whole administration, ported the whole company from OSX to Linux and guess what the previous OSX "sysadmin" was: a clickmonkey
from 2003 to 2008 i learned all the needed things autodidact to took over the whole technical from database, web, mail, network, virtualization, nameservers and what not
what i never missed was a desktop GUI for a mysql server….
I get that, and that’s great for you. I could say the same as well, but nevertheless, still use GUIs. They may not be for you, and that’s fine. Just as you tend to lump GUI users into some bucket, I tend to lump non GUI users into a set of stereotypes. Just realize you are not the typical case. You really think the hundreds of thousands of Zen Cart, OSCommerce, Magento, etc. users can do that, your typical person? Now that mariadb is the default on many distributions? I’ve helped many of them over the years gain some access to their database so they can explore, poke around, generate some reports, run queries I generate for them, get back into their system when locked out, etc. Workbench as you may or may not know, has some failsafes. Naturally, GUI or not, they can also destroy their system though it’s a little harder with the GUI. So, caution and rules / configuration are always stated. My intent is certainly not to try and convince any experienced admin who does not use any sort of GUI tool to do so, of course not! Use whatever makes you feel good. It’s only to agree with the OP that such tools are useful for many people, one of them not being you. However, as a programmer, I do realize that it would be challenging due to the skill set involved to maintain the product.
If you really need a GUI to manage MariaDB, why not get real and purchase a license for Navicat, DBForge or SQLyog, just to quote a few of those that support MariaDB. I'm sure your boss has $100 to spend on a lifetime license for one of those products. Le ven. 21 avr. 2017 à 03:13, Zach Lym <zachlym@indolering.com> a écrit :
I convinced my boss to use MariaDB for a new project but it appears that the workbench is incompatible with new features of MariaDB. I've looked at the alternatives listed on the website, but they are all either proprietary or Windows only. I just can't sell my boss on switching to MariaDB without workbench.
Free software isn't free, but I think Workbench is a big driver of commercial and enterprise use. It's easy to kvetch from the outside, but I feel as though MariaDB has just lost some ground.
Has management considered forking Workbench?
Thank you, -Zach Lym
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Did you try HeidiSQL? https://www.heidisql.com/ -----Ursprüngliche Nachricht----- Von: Maria-discuss [mailto:maria-discuss-bounces+sebastian.hempel=leutek.de@lists.launchpad.net] Im Auftrag von Zach Lym Gesendet: Donnerstag, 20. April 2017 21:12 An: maria-discuss@lists.launchpad.net Betreff: [Maria-discuss] MySQL Workbench Fork? I convinced my boss to use MariaDB for a new project but it appears that the workbench is incompatible with new features of MariaDB. I've looked at the alternatives listed on the website, but they are all either proprietary or Windows only. I just can't sell my boss on switching to MariaDB without workbench. Free software isn't free, but I think Workbench is a big driver of commercial and enterprise use. It's easy to kvetch from the outside, but I feel as though MariaDB has just lost some ground. Has management considered forking Workbench? Thank you, -Zach Lym _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Did you try "PhpMyAdmin"? On Thu, Apr 20, 2017 at 3:12 PM, Zach Lym <zachlym@indolering.com> wrote:
I convinced my boss to use MariaDB for a new project but it appears that the workbench is incompatible with new features of MariaDB. I've looked at the alternatives listed on the website, but they are all either proprietary or Windows only. I just can't sell my boss on switching to MariaDB without workbench.
Free software isn't free, but I think Workbench is a big driver of commercial and enterprise use. It's easy to kvetch from the outside, but I feel as though MariaDB has just lost some ground.
Has management considered forking Workbench?
Thank you, -Zach Lym
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (9)
-
Guillaume Lefranc -
Hempel, Sebastian -
info＠smallbusinessconsultingexperts.com -
l vic -
Mike Morrin -
Reindl Harald -
Sales
-
Stephane Varoqui -
Zach Lym