Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Lightweight SQL editor for Eclipse [closed]

People also ask

How do I open SQL editor in Eclipse?

go to Preferences->Database Development->SQL Editor->SQL Files/Scrapbooks.

How do I download SQL editor for Eclipse?

To install the standalone client, download Eclipse SQL Explorer RCP. Extract the zipfile and launch sqlexplorer.exe to start the application. Download the Eclipse SQL Explorer plugin and extract the zip file in your eclipse directory (requires Eclipse 3.3 or better).

Can we run SQL in Eclipse?

You can execute a SQL file from the SQL File Editor or from WorkSpace Navigator. Make sure the database server is running and you are connected to it through a connection profile.


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

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


This Eclipse SQL Editor seems 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.


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.

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.


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

alt text


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

DTP Editor


QuantumDB is also a lightweight option that I really liked.

http://quantum.sourceforge.net/


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

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