什么是好的MySQL数据库模式工具?

时间:2021-01-28 12:59:00

I'm starting a new project soon and I'd like to try to use some better tools this time around. The last project, I wrote all my Database creation SQL by hand for MySQL. I'm hoping there are some good tools out there for creating, maintaining and modifying database schema in MySQL. My budget is out-of-my-own-pocket, so free (as in beer) would probably be best. :)

我马上就要开始一个新项目了,这次我想试着用一些更好的工具。上一个项目,我为MySQL手工编写了所有的数据库创建SQL。我希望有一些好的工具可以在MySQL中创建、维护和修改数据库模式。我的预算是自己付的,所以免费(比如啤酒)可能是最好的。:)

7 个解决方案

#1


27  

MySQL Workbench : http://dev.mysql.com/workbench/

MySQL工作台:http://dev.mysql.com/workbench/

It is free and very easy to use. I usually create schema diagrams and export it as a .sql file to use with phpMyAdmin

它是免费的,很容易使用。我通常创建模式图并将其作为.sql文件导出,以便与phpMyAdmin一起使用

#2


4  

http://dev.mysql.com/downloads/gui-tools/5.0.html offers a list of GUI tools to use.

http://dev.sqmyl.com/downloads/gui-tools/5.0.html提供了一个要使用的GUI工具列表。

#3


3  

Mac options, try Querious or Sequel Pro - here's a comparison:

Mac选项,尝试Querious或Sequel Pro -这是一个比较:

http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/

http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/

#4


2  

A complete list of data modeling tools can be found at databaseanwers

可以在databaseanwers中找到完整的数据建模工具列表

#5


1  

MySQL Workbench 5.1 (Beta 1) should be out March 6,2009. It will be available on MacOS, Fedora, Ubuntu, Windows. These are native C++ implementations on each platform. WB 5.1 is focused on Data Modeling (replacing Mike Zinner’s popular DBDesigner product).

MySQL Workbench 5.1 (Beta 1)应该在2009年3月6日发布。它将在MacOS, Fedora, Ubuntu, Windows上提供。这些是每个平台上的本机c++实现。WB 5.1关注的是数据建模(替代了Mike Zinner的流行的DBDesigner产品)。

MySQL Workbench 5.2 (Alpha 1) should be out mid April 2009 (around the MySQL Users Conference 2009). This will include a ground up rewrite of the MySQL Query Browser.

MySQL Workbench 5.2 (Alpha 1)应该在2009年4月中旬发布(在2009年MySQL用户大会前后)。这将包括对MySQL查询浏览器的重写。

http://forums.mysql.com/index.php?151

http://forums.mysql.com/index.php?151

#6


1  

I know this is an old thread but this is too good to miss out on. I've only just found out about this recently...
HeidiSQL

我知道这是一条旧线,但这条线太好了,不能错过。我最近才发现……HeidiSQL

It supports connecting through SSH tunnels. It uses PuTTY (plink.exe) to do this but avoids having to manually fiddle with your PuTTY settings. It's even easier if you're using this nice portable version of PuTTY... http://jakub.kotrla.net/putty/

它支持通过SSH隧道连接。它使用腻子(plink.exe)来实现这一点,但避免了手工修改腻子设置。如果你用的是这个漂亮的便携版的腻子……http://jakub.kotrla.net/putty/

Plus it's open source. I strongly urge you to donate though as it's a great tool.

再加上它是开源的。我强烈建议你捐献,因为这是一个很好的工具。

Another one that looks good is DBeaver

另一个看起来不错的是海狸

I used to really like MySQL Administrator but the new Workbench is way too bloated. I just want a quick way to browse the schema without having to SHOW TABLE STATUS

我以前很喜欢MySQL管理员,但是新的工作台太臃肿了。我只想快速浏览模式,而不需要显示表状态。

#7


0  

Use DB Schema editor but it is not freeware. But you can trial it for 15 days for free by downloading here

使用DB模式编辑器,但它不是免费软件。但是你可以在这里下载免费试用15天

#1


27  

MySQL Workbench : http://dev.mysql.com/workbench/

MySQL工作台:http://dev.mysql.com/workbench/

It is free and very easy to use. I usually create schema diagrams and export it as a .sql file to use with phpMyAdmin

它是免费的,很容易使用。我通常创建模式图并将其作为.sql文件导出,以便与phpMyAdmin一起使用

#2


4  

http://dev.mysql.com/downloads/gui-tools/5.0.html offers a list of GUI tools to use.

http://dev.sqmyl.com/downloads/gui-tools/5.0.html提供了一个要使用的GUI工具列表。

#3


3  

Mac options, try Querious or Sequel Pro - here's a comparison:

Mac选项,尝试Querious或Sequel Pro -这是一个比较:

http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/

http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/

#4


2  

A complete list of data modeling tools can be found at databaseanwers

可以在databaseanwers中找到完整的数据建模工具列表

#5


1  

MySQL Workbench 5.1 (Beta 1) should be out March 6,2009. It will be available on MacOS, Fedora, Ubuntu, Windows. These are native C++ implementations on each platform. WB 5.1 is focused on Data Modeling (replacing Mike Zinner’s popular DBDesigner product).

MySQL Workbench 5.1 (Beta 1)应该在2009年3月6日发布。它将在MacOS, Fedora, Ubuntu, Windows上提供。这些是每个平台上的本机c++实现。WB 5.1关注的是数据建模(替代了Mike Zinner的流行的DBDesigner产品)。

MySQL Workbench 5.2 (Alpha 1) should be out mid April 2009 (around the MySQL Users Conference 2009). This will include a ground up rewrite of the MySQL Query Browser.

MySQL Workbench 5.2 (Alpha 1)应该在2009年4月中旬发布(在2009年MySQL用户大会前后)。这将包括对MySQL查询浏览器的重写。

http://forums.mysql.com/index.php?151

http://forums.mysql.com/index.php?151

#6


1  

I know this is an old thread but this is too good to miss out on. I've only just found out about this recently...
HeidiSQL

我知道这是一条旧线,但这条线太好了,不能错过。我最近才发现……HeidiSQL

It supports connecting through SSH tunnels. It uses PuTTY (plink.exe) to do this but avoids having to manually fiddle with your PuTTY settings. It's even easier if you're using this nice portable version of PuTTY... http://jakub.kotrla.net/putty/

它支持通过SSH隧道连接。它使用腻子(plink.exe)来实现这一点,但避免了手工修改腻子设置。如果你用的是这个漂亮的便携版的腻子……http://jakub.kotrla.net/putty/

Plus it's open source. I strongly urge you to donate though as it's a great tool.

再加上它是开源的。我强烈建议你捐献,因为这是一个很好的工具。

Another one that looks good is DBeaver

另一个看起来不错的是海狸

I used to really like MySQL Administrator but the new Workbench is way too bloated. I just want a quick way to browse the schema without having to SHOW TABLE STATUS

我以前很喜欢MySQL管理员,但是新的工作台太臃肿了。我只想快速浏览模式,而不需要显示表状态。

#7


0  

Use DB Schema editor but it is not freeware. But you can trial it for 15 days for free by downloading here

使用DB模式编辑器,但它不是免费软件。但是你可以在这里下载免费试用15天