SQL Editor

Add this URL to your Eclipse Installation to reach this solution's update site.

2022-06 (4.24), 2022-03 (4.23), 2021-12 (4.22), 2021-09 (4.21), 2021-06 (4.20), 2021-03 (4.19), 2020-12 (4.18), 2020-09 (4.17), 2020-06 (4.16), 2020-03 (4.15), 2019-12 (4.14), 2019-09 (4.13), 2019-06 (4.12), 2019-03 (4.11), 2018-12 (4.10), 2018-09 (4.9), Photon (4.8), Oxygen (4.7), Neon (4.6), 2022-09 (4.25), 2022-12 (4.26), 2023-03 (4.27), 2023-06 (4.28), 2023-09 (4.29), 2023-12 (4.30), 2024-03 (4.31), 2024-06 (4.32), 2024-09 (4.33), 2024-12 (4.34)

https://de-jcup.github.io/update-site-eclipse-sql-editor/update-site

Learn more...
Solution Description

This is just a SQL editor. It is NOT a full database tool but just an editor for SQL files.

Features.

  • Syntax highlighting
    (Customizable colors, defaults for dark theme, keyword styles can be customized)
  • Simple code completion
    (wellknown sql keywords and existing words)
  • Outline, Quick outline
    (can be turned off in preferences)
  • Block commenting/uncommenting
  • Bracket switching
  • Tooltips for most statements, functions etc. (>80%) containing often also examples and syntax descriptions - just hoover over a highlighted keyword
  • SQL formatter (experimental)

Additional links

Categories: Editor

Additional Details

Eclipse Versions: 2022-06 (4.24), 2022-03 (4.23), 2021-12 (4.22), 2021-09 (4.21), 2021-06 (4.20), 2021-03 (4.19), 2020-12 (4.18), 2020-09 (4.17), 2020-06 (4.16), 2020-03 (4.15), 2019-12 (4.14), 2019-09 (4.13), 2019-06 (4.12), 2019-03 (4.11), 2018-12 (4.10), 2018-09 (4.9), Photon (4.8), Oxygen (4.7), Neon (4.6), 2022-09 (4.25), 2022-12 (4.26), 2023-03 (4.27), 2023-06 (4.28), 2023-09 (4.29), 2023-12 (4.30), 2024-03 (4.31), 2024-06 (4.32), 2024-09 (4.33), 2024-12 (4.34)

Platform Support: Windows, Mac, Linux/GTK

Organization Name: Albert Tregnaghi

Development Status: Production/Stable

Date Created: Thursday, March 14, 2019 - 03:07

License: Apache 2.0

Date Updated: Friday, October 6, 2023 - 10:48

Submitted by: Albert Tregnaghi

Screenshot
Date Ranking Installs Clickthroughs
December 2024 40/611 363 8
November 2024 37/658 875 21
October 2024 42/663 876 8
September 2024 42/642 828 14
August 2024 41/641 788 15
July 2024 34/663 945 15
June 2024 26/681 1466 22
May 2024 23/682 1845 22
April 2024 24/687 1817 16
March 2024 24/694 1900 17
February 2024 25/687 1706 278
January 2024 25/691 1857 16
View Data for all Listings

Unsuccessful Installs

Unsuccessful Installs in the last 7 Days: 6

Download last 500 errors (CSV)

Marketplace Drag to Install Button

By adding the following code below to your website you will be able to add an install button for SQL Editor.

HTML Code:

Markdown Syntax:

Output:

Drag to your running Eclipse* workspace. *Requires Eclipse Marketplace Client

Reviews Add new review

Hi Albert,

I found your plugin quite useful, but there is a bunch of Oracle specific keywoards that I'd like to highlight as well as stock ones. Is it possible to exends the plugin to allow for custom keywoards?

Thank you.

"elsif", "raise", "exception" are not highlighted. Probably all Oracle specific, but it would be really nice to add user-contlolled keyword list. Thanks!

Because of bintray sundown - see https://jfrog.com/blog/into-the-sunset-bintray-jcenter-gocenter-and-chartcenter there was a need to change the update site.

The new location starting with version 1.2.0 is now https://de-jcup.github.io/update-site-eclipse-sql-editor/update-site/

When you are using eclipse marketplace for installation the new update location will be automatically applied.

Hello there,

correct me if I'm wrong, but I noticed that frequently used SQL keywords like 'into' and 'declare' aren't highlighted and I was wondering if you could add those or alternatively allow custom keywords for syntax highlighting.

Kind regards.

Can you add support for block coments (/* */)?
Currently there is no special handling for text enclosed block comments.

Default Editor Colours are more aligned for Eclipse using a light theme( e.g. Default Text colour is Black which looks horrible on a dark background). But that's not a problem. Open preferences (Menus->Windows->Preferences and select SQL Editor -> Syntax Colouring. You should see a "Restore Defaults for Dark Theme" button on the dialog. This will reset the colours consistent for the selected theme. Works great! Plugin also works great with Eclipse Colour Theme plugin with selected Editor Colour Theme.