DBHelper 1.2.02 Other scripts script

SPONSORED LINKS

    Specification

  • Version: 1.2.02
  • File size: 0 KB
  • File name: ?action=download&id=3644
  • Last update:
  • Platform: Windows
  • Language: Other scripts
  • Price:Freeware
  • Company: DBHelper (View more)

DBHelper 1.2.02 script description:




Publisher review:
DBHelper - A productivity tool to help you work with databases inside IDEA. A productivity tool to help you work with databases inside IDEA. This tool is targeted on the Java developers, who are also stored procedure developers.

Key features include:

1) Adding two new file types IDEA can recognize: a. SQL – The SQL script file b. DIA – The database schema diagram file

2) Basic syntax highlighting – Supporting keywords, single line comments, /** **/ style multi-line comments, strings and number. The keyword is updated dynamically based on the database you are working with.

3) Code completion: a. Supporting basic completion: Hit Ctrl Space lists all the objects in the current database and narrows down as the user typing b. Correlation name completion: When the user hits ‘.’, it will resolve the correlation name and pops up the suggestions, such as catalogs, schemas, table columns and stored procedures. It can also resolve SQL correlation name, temp tables, declared variables and parameters (works for SQL iAnywhere or ASE T-SQL format)

4) Run SQL script inside IDEA editor – At any time, the user can highlight a block SQL script or run the whole SQL script in IDEA editor and the result will show in the DBHelper output panel.

5) View Database schema as diagram – At any time, the user can select multiple tables or a type of tables and view the schema in a graphical diagram. The diagram can be saved as DIA format or copied as image.

6) Update table data – The user can view the data of any table and insert/delete/update the table data.

7) Support multiple databases via standard JDBC interface, tested databases are: a. Sybase SQL Anywhere (tested on version 9.x) b. Sybase ASE (tested on version 12.x) c. MySQL (tested on version5.x) d. SQL Server (tested on version 2000) e. Oracle (tested on 9i) Extra database meta data can be supported by adding plugin jars to DBHelper (Implementing IMetaProvider interface, see ASA user meta extension sample)

8) It is designed to be extended using Velocity templates. (Velocity is an open source apache project for generating text content based on a simple template). Uses can add templates to generate customized content based on the database meta data, such as generating XML data based on resultset, or JDBC call to retrieve the resultset from the database. There are some templates come with this release as examples.

9) SQLConsole is newly added to support users that primarily don’t write lots of stored procedures and only want to run some simple queries inside IDEA. Users can open SQLConsole in DBOutput tool window and run any SQL queries. Of course syntax highlighting and SQL code completion are also available in the SQLConsole.

10) Query Manager: Users can create new or update queries in DBOutput tool window Saved Queries tab.
DBHelper 1.2.02 is a Other scripts script for Development Tools scripts design by DBHelper. It runs on following operating system: Windows.
DBHelper - A productivity tool to help you work with databases inside IDEA.

Operating system:
Windows

Latest script and internet news

The new Firefox 37 comes with improved HTTP / 2 and superior HMTL5 compatibility with YouTube

The new Firefox 37 comes with improved HTTP / 2 and superior HMTL5 compatibility with YouTube

The popular browser Firefox reached version 37, bringing a series of news but not as significant as other versions.

Posted on: 03 Apr 2015 11:11 by A. Brown

The permanently active Push system offered by the new Google Chrome 42

The permanently active Push system offered by the new Google Chrome 42

Google Chrome version 42 comes with implementation of interesting options for software developers who want to turn their websites into complex Web applications: Push notification system which is permanently active.

Posted on: 17 Mar 2015 07:57 by A. Brown

Gamers, Microsoft presents the advantages of DirectX 12 and 11.3 platforms used by new games for Windows 10

Gamers, Microsoft presents the advantages  of DirectX 12 and 11.3 platforms used by new games for Windows 10

The Windows 10 preview event brought also to the attention of gamers a demonstration of the advantages of the new DirectX 12 API by Microsoft, which announced several technologies providing integration with Xbox One game consoles.

Posted on: 27 Jan 2015 09:15 by A. Brown

Android devices now have access to Google Chrome 40

Android devices now have access to Google Chrome 40

Finally was officially released version 40 of Chrome browser for Android devices, iOS and Windows PCs, coming up with an interesting range of bug fixes and optimizations.

Posted on: 23 Jan 2015 13:57 by A. Brown

SPREAD THE WORD

User Rating


Rating: 0.0 out of 5
Based on 0 ratings. 0 user reviews.

  • Currently 0.00 out of 5
  • 1
  • 2
  • 3
  • 4
  • 5