opensource software
SQL Query Plugin
Vendor:
KiwiSoft
Email:
Website:
http://java.sstiller.de/sql/index.html
SourceCode:
link
License:
license url
Bugtracker page
Description:
A tool for executing SQL statements through a JDBC connection.
Features:
- Syntax highlighting
- Executing multiple statements at once
- Highlighting of primary and foreign keys
- Editing of results
- Support for easier configuration of common JDBC driver
- Support of different column formats (including custom formats)
- Browser for database structure
- Statement templates for often used statements
- Support for Java BLOB's
- Export into XML, HTML, CSV and Excel
- Data Load
Downloads: 127785
Rating:
Participated in rating: 23
| 2.2. |
40.3436. |
. |
Download
|
1730.71. |
2006-11-18 19:56:38 |
. |
| 2.1.1. |
40.3436. |
. |
Download
|
. |
2006-04-02 19:36:46 |
. |
| 2.1. |
40.3436. |
. |
Download
|
. |
2006-03-26 12:45:21 |
. |
| 2.0. |
40.3436. |
. |
Download
|
. |
2006-03-07 21:19:50 |
. |
| 1.4.6. |
40.1100. |
. |
Download
|
. |
2005-11-05 16:20:54 |
. |
| 1.4.5. |
40.1100. |
. |
Download
|
. |
2005-08-14 13:02:15 |
. |
| 1.4.4. |
40.1100. |
. |
Download
|
. |
2005-04-08 21:43:01 |
. |
| 1.4.3. |
40.1100. |
. |
Download
|
1160.52. |
2004-11-15 21:37:19 |
. |
| 1.4.2. |
40.1100. |
. |
Download
|
1095.18. |
2004-10-01 21:22:03 |
. |
| 1.4.1. |
. |
. |
Download
|
1095.23. |
2004-10-01 21:09:55 |
. |
| 1.4.0. |
40.1100. |
. |
Download
|
1014.46. |
2004-08-01 19:31:22 |
. |
| 1.3.9. |
. |
. |
Download
|
803.67. |
2004-06-30 23:02:39 |
. |
| . |
. |
Recent change notes:
Bugs
- [SQLQ-13] - Plugin not working on Mac
- [SQLQ-15] - Editing of date columns doesn't work
Cosmetics
- [SQLQ-4] - Output messages are sometimes in the wrong order
New Features
- [SQLQ-1] - Import of data files
- [SQLQ-6] - Add support for Microsoft SQLServer 2005 Driver
- [SQLQ-16] - Allow relative dates for table date editors.
- [SQLQ-17] - Add viewer for image BLOB's
Comments:
1. The Home/End buttons are going to begining/end of text instead of line (as mentioned before)
2. A long running query could hang the IDE and not only the plugin. (*)
3. Sometimes undo does not work. Don't have an exact scenario.
Squirrel is my alternative first attempt, works so far, not the cleanest usability but just ok.
SQL queries should really be an integral part of the IDE - IntelliJ team - pick this up and either write sql support from scratch or integrate Squirel or whatever is the best open source out there. Don't leave it to the mercy of a plugin developer - not good for the effectiveness of the tool nor your business. You should probably aim at making SQL queries a "5" rating for every intellij user - same as the overall IDE usually is.
(*) I do use a very heavy project with > 20k classes and lots of jsps/jars, overall installable after jsp pre-compilation + classes + jars is ~200MB; Not sure how much of the overall heaviness of the project is in play here.
Reverting to dbHelper...
It dont work. Have a messenge when I perform SQL query. A dialog show enter password. If I click No password, it dont word and notify
[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified !
"Connection couldn't be established."
I must recommend this tool, which should increase the productivity if there is any use of SQL Query in side the code.
But I cannot find how to use templates :-(
- the fonts are a little screwed up it even shows up in the screenshoot how the "m" in "from" is cutoff
- undo doesn't seem to work, I've cried several times when I've accidentally pressed a key other than ctrl-enter when I was trying to execute a line and then have it disappear with no way to get it back
- wish it would autosave into a template or something so that when restarting Idea it would keep any work in progress
-m