MySQL Workbench Alternatives
Hey guys. This is probably a long shot, but does anyone know of a MySQL Workbench alternative that isn't laggy as heck with large datasets? Preferably with a more modern GUI as well but not essential. The lag is what's mostly irritating me.
7 Replies
have you tried heidi sql?
it has some quirks, but it works decently enough
Nope I haven't heard of it until now. I'll check it out. 👍
Could you elaborate a little on what quirks it has?
mostly usage quirks:
- instead of requesting a list of data, there's a tab called "data" that you use to list data
- ctrl+enter doesn't work
- double-click just adds the table name on the query editor
- letting the data tab sit for a long time (a few hours) will cause it to lose all data and just show "node" for all values
- there is no quick way to set a limit on the fetched data for the data tab
- having 2+ connections at the same time is a huge mess
- if you export data, it saves the file name of the last file you exported, which can be really weird
there are more quirks that i can't remember now
the only bugs i found:
- scripts with a mix of latin1 or utf8 or utf8mb3 or utf8mb4 can cause the script to crash - this works fine almost always in mysql workbench
- when doing database->database importing, if there's a value that's bigger than the max packet size, it causes exceptions and the program becomes unusable. this doesn't happen if you export to an sql file
- sometimes, heidisql can create sql files that cause the first bug
Thank you so much for that. 👍
you're welcome
by the way, you can try phpmyadmin
if you use xampp, you just have to go to /phpmyadmin
You could also try DBeaver, there is a free version you can try.
I've been using for a while now and it's great.
try admier