opensource software
SQL Query Plugin
Products:
IntelliJ IDEA,
Android Studio
Vendor:
KiwiSoft
Email:
Website:
http://java.sstiller.de/sql/index.html
SourceCode: SQL_Query_Plugin_228.zip
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: 146302
Rating:
Participated in rating: 24
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:
I am beginning to use the plugin. I am new to database design also. I need the conection string to look like:
jdbc:oracle:thin:@HOST:1521/SID
but the plugin here I see produces:
jdbc:oracle:thin:@HOST:1521:SID
Where should I change a setting or what might be the problem?
Aside I think it should score high. An early user I am.
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...