Eclipse 的轻量级 SQL 编辑器

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/3193850/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 06:48:21  来源:igfitidea点击:

Lightweight SQL editor for Eclipse

sqleclipseeditoreclipse-plugin

提问by nimcap

Is there any simple SQL editor in Eclipse? Or do I need to find a simple SQL editor plugin for Eclipse?

Eclipse 中是否有任何简单的 SQL 编辑器?或者我需要为 Eclipse 找到一个简单的 SQL 编辑器插件吗?

By simple I mean, the editor does NOTconnect to any DB, does syntax highlighting and preferably formatting sql is a bonus.

通过简单的我的意思是,编辑器不会连接到任何数据库,做语法高亮和最好格式化SQL是一个奖金。

回答by Ben K

for reference to add sql syntax highlighting / coloring to eclipse you can install Data tools platform extender sdkfrom "install new software", under Database Development

作为参考,将 sql 语法高亮/着色添加到 eclipse 您可以Data tools platform extender sdk从“安装新软件”安装,在Database Development

or enter site location directly http://download.eclipse.org/datatools/updates

或直接输入站点位置 http://download.eclipse.org/datatools/updates

回答by sam2themax

This Eclipse SQL Editorseems very lightweight. It only does syntax highlighting and provides an outline view. As of now the author is planning to eventually add code folding and completion, but those two features are still on the todo list.

这个Eclipse SQL 编辑器看起来非常轻巧。它只做语法高亮并提供大纲视图。截至目前,作者计划最终添加代码折叠和完成功能,但这两个功能仍在待办事项列表中。

回答by sojin

Use Toad eclipse-extension(community edition), you will get almost everything you want in an SQL editor. Search for 'toad' in eclipse market place. It has very good Oracle, MySQL and PostgreSQL support.

使用Toad eclipse-extension(社区版),您将在 SQL 编辑器中获得几乎所有您想要的东西。在日食市场中搜索“蟾蜍”。它有很好的 Oracle、MySQL 和 PostgreSQL 支持。

Take a look at Installation instructions and screenshots.

查看安装说明和屏幕截图

Alternatively, there is DBeaver(very good in my experience and support almost all DB's) which is built on eclipse platform and available as standalone and eclipse plugin.

或者,还有DBeaver(在我的经验中非常好并且支持几乎所有 DB),它构建在 eclipse 平台上,可作为独立和 eclipse 插件使用。

回答by VonC

The eclipse SQLExplorerplugin seems light enough, and comes with a basic SQL editor(but no "format" option):

日食SQLExplorer视窗插件似乎光照充足,并配备了基本的SQL编辑器(但没有“格式”选项):

alt text

替代文字



The official DTP DataTool Projectis much complete, but have also its own editor:

官方的DTP DataTool 项目非常完整,但也有自己的编辑器

DTP Editor

排版编辑器

回答by Shantanu Kumar

QuantumDB is also a lightweight option that I really liked.

QuantumDB 也是我非常喜欢的一个轻量级选项。

http://quantum.sourceforge.net/

http://quantum.sourceforge.net/

回答by apocalypz

Just found DBeaver : http://dbeaver.jkiss.org/

刚刚找到 DBeaver:http://dbeaver.jkiss.org/

looks good, plenty of features, support mssql (which I need in the moment :) ... I'll give it a try ...

看起来不错,功能很多,支持 mssql(我现在需要它:)......我会尝试一下......