Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » Eclipse Plug-in Development - T-SQL Editor(new to plug-in development looking for advice)
Eclipse Plug-in Development - T-SQL Editor [message #694082] Thu, 07 July 2011 19:02 Go to next message
beo.xtc is currently offline beo.xtc
Messages: 2
Registered: July 2011
Junior Member
Hello eclipse community,

I'm new here, but not necessarily new to java. I like programming and want to contribute to the eclipse community.

I need a T-SQL Editor but there is no good OpenSource or free-to-use out there. So I want to create one by myself (and help of good people).

My Vision:

* Formatter
I was looking pretty much for a good SQL Formatter program on the internet and google, but I couldn't find any good Open Source Plug-in/Program.
Most of the plug-ins had limited formatting options and I couldn't change it the way I need them, with any editor.

Eclipse has no explicit formatter for .sql files.

* IntelliSense (code completion)
Our DB-Servers are cross used (we don't connect to server:port/database but server:port only) So we need Intellisense to chose from the database names, intellisense for choosing tables and intellisense for choosing fields of the tables.

So I want to make this plug-in for Sybase and MS SQL Server (both use T-SQL) connections - I want to use JDBC to connect to servers.

* Keywords
I want to highlight (or however you call it) keywords (select, update, delete, from, where, exec, begin, rollback,...). It should be configurable like formatter, with import and export funktions.

* (T-)SQL Templates
when using intellisense, the user should be able to add templates which are choose able.

* Results
We use the Data Source Explorer and SQL Scratchbook (SQL File) to connect to db and execute statements. The problem is the Result, it is displayed as a "table" but we can select the whole row only. We want to select every field separate as we need, when possible multiple fields with shift+click.

this is my plan. I want to realize it as an plug-in for eclipse. I'm new to plugin development so I don't know if I should create Views or just properties or whatever. I need to spend more time with it.

This plug-in should be used by my company, but I do it in my free time. I want everybody who needs it to be able to use it.

My Project should be:
- Open to public
- Developed by user of my choice and me
- Bug tracking
- Forum?/other communications within this project (I have no experience with mailing-lists or Newsgroups)

My Questions:
1.) How can I set-up such a project?
2.) What should I take care of when setting up the project (licenses, using code of others)?
3.) Where can I find information and support to plugin development?
4.) Where can I find information and support to Intellisense development?

My Benefits:
> I hope to gain pretty much experience of such a project
> I spend my time more useful
> I contribute to your community
> My collegues can use my Plug-In and help me develop/test it

I hope there are not to many questions already answered in other topics. I started to read the documentations on Eclipse Projects, but there is sooo much information about it, I can't filter the necessary information.

I'm happy about every serious answer and wish you a nice evening.

Cheers, beo
Re: Eclipse Plug-in Development - T-SQL Editor [message #694099 is a reply to message #694082] Thu, 07 July 2011 19:24 Go to previous messageGo to next message
Russell Bateman is currently offline Russell Bateman
Messages: 3189
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

To get started, check out the RCP/plug-in tutorial(s) at
http://www.vogella.de.


On 07-Jul-11 13:02, forums-noreply@eclipse.org wrote:
> Hello eclipse community,
>
> I'm new here, but not necessarily new to java. I like programming and
> want to contribute to the eclipse community.
>
> I need a T-SQL Editor but there is no good OpenSource or free-to-use out
> there. So I want to create one by myself (and help of good people).
>
> My Vision:
>
> * Formatter
> I was looking pretty much for a good SQL Formatter program on the
> internet and google, but I couldn't find any good Open Source
> Plug-in/Program.
> Most of the plug-ins had limited formatting options and I couldn't
> change it the way I need them, with any editor.
>
> Eclipse has no explicit formatter for .sql files.
>
> * IntelliSense (code completion)
> Our DB-Servers are cross used (we don't connect to server:port/database
> but server:port only) So we need Intellisense to chose from the database
> names, intellisense for choosing tables and intellisense for choosing
> fields of the tables.
>
> So I want to make this plug-in for Sybase and MS SQL Server (both use
> T-SQL) connections - I want to use JDBC to connect to servers.
>
> * Keywords
> I want to highlight (or however you call it) keywords (select, update,
> delete, from, where, exec, begin, rollback,...). It should be
> configurable like formatter, with import and export funktions.
>
> * (T-)SQL Templates
> when using intellisense, the user should be able to add templates which
> are choose able.
>
> * Results
> We use the Data Source Explorer and SQL Scratchbook (SQL File) to
> connect to db and execute statements. The problem is the Result, it is
> displayed as a "table" but we can select the whole row only. We want to
> select every field separate as we need, when possible multiple fields
> with shift+click.
>
> this is my plan. I want to realize it as an plug-in for eclipse. I'm new
> to plugin development so I don't know if I should create Views or just
> properties or whatever. I need to spend more time with it.
>
> This plug-in should be used by my company, but I do it in my free time.
> I want everybody who needs it to be able to use it.
>
> My Project should be:
> - Open to public
> - Developed by user of my choice and me
> - Bug tracking
> - Forum?/other communications within this project (I have no experience
> with mailing-lists or Newsgroups)
>
> My Questions:
> 1.) How can I set-up such a project?
> 2.) What should I take care of when setting up the project (licenses,
> using code of others)?
> 3.) Where can I find information and support to plugin development?
> 4.) Where can I find information and support to Intellisense development?
>
> My Benefits:
>> I hope to gain pretty much experience of such a project
>> I spend my time more useful
>> I contribute to your community
>> My collegues can use my Plug-In and help me develop/test it
>
> I hope there are not to many questions already answered in other topics.
> I started to read the documentations on Eclipse Projects, but there is
> sooo much information about it, I can't filter the necessary information.
>
> I'm happy about every serious answer and wish you a nice evening.
>
> Cheers, beo
Re: Eclipse Plug-in Development - T-SQL Editor [message #694942 is a reply to message #694099] Sun, 10 July 2011 10:08 Go to previous messageGo to next message
beo.xtc is currently offline beo.xtc
Messages: 2
Registered: July 2011
Junior Member
thank you for your link, russell.
I started reading and it's a very nice tutorial.
Re: Eclipse Plug-in Development - T-SQL Editor [message #696347 is a reply to message #694082] Wed, 13 July 2011 17:32 Go to previous message
Eric Rizzo is currently offline Eric Rizzo
Messages: 2245
Registered: July 2009
Senior Member
You can host your project at Eclipse Labs. See here:
http://eclipse.org/org/foundation/eclipselabs/faq.php


On 7/7/11 3:02 PM, forums-noreply@eclipse.org wrote:
> Hello eclipse community,
>
> I'm new here, but not necessarily new to java. I like programming and
> want to contribute to the eclipse community.
>
> I need a T-SQL Editor but there is no good OpenSource or free-to-use out
> there. So I want to create one by myself (and help of good people).
>
> My Vision:
>
> * Formatter
> I was looking pretty much for a good SQL Formatter program on the
> internet and google, but I couldn't find any good Open Source
> Plug-in/Program.
> Most of the plug-ins had limited formatting options and I couldn't
> change it the way I need them, with any editor.
>
> Eclipse has no explicit formatter for .sql files.
>
> * IntelliSense (code completion)
> Our DB-Servers are cross used (we don't connect to server:port/database
> but server:port only) So we need Intellisense to chose from the database
> names, intellisense for choosing tables and intellisense for choosing
> fields of the tables.
>
> So I want to make this plug-in for Sybase and MS SQL Server (both use
> T-SQL) connections - I want to use JDBC to connect to servers.
>
> * Keywords
> I want to highlight (or however you call it) keywords (select, update,
> delete, from, where, exec, begin, rollback,...). It should be
> configurable like formatter, with import and export funktions.
>
> * (T-)SQL Templates
> when using intellisense, the user should be able to add templates which
> are choose able.
>
> * Results
> We use the Data Source Explorer and SQL Scratchbook (SQL File) to
> connect to db and execute statements. The problem is the Result, it is
> displayed as a "table" but we can select the whole row only. We want to
> select every field separate as we need, when possible multiple fields
> with shift+click.
>
> this is my plan. I want to realize it as an plug-in for eclipse. I'm new
> to plugin development so I don't know if I should create Views or just
> properties or whatever. I need to spend more time with it.
>
> This plug-in should be used by my company, but I do it in my free time.
> I want everybody who needs it to be able to use it.
>
> My Project should be:
> - Open to public
> - Developed by user of my choice and me
> - Bug tracking
> - Forum?/other communications within this project (I have no experience
> with mailing-lists or Newsgroups)
>
> My Questions:
> 1.) How can I set-up such a project?
> 2.) What should I take care of when setting up the project (licenses,
> using code of others)?
> 3.) Where can I find information and support to plugin development?
> 4.) Where can I find information and support to Intellisense development?
>
> My Benefits:
>> I hope to gain pretty much experience of such a project
>> I spend my time more useful
>> I contribute to your community
>> My collegues can use my Plug-In and help me develop/test it
>
> I hope there are not to many questions already answered in other topics.
> I started to read the documentations on Eclipse Projects, but there is
> sooo much information about it, I can't filter the necessary information.
>
> I'm happy about every serious answer and wish you a nice evening.
>
> Cheers, beo
Previous Topic:Windows server 2008 - Eclipse not opening
Next Topic:addActionListeners method undefined que from a newb
Goto Forum:
  


Current Time: Tue Sep 16 05:11:22 GMT 2014

Powered by FUDForum. Page generated in 0.02248 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software