Dbclient
DBClient is a new Open Source Tool for connecting to JDBC-compliant relational databases. It is almost written in Java which makes it platform independent and it stores it configuration info using an embedded version of Apache Derby. DBClient is massively based on Plugin architecture and supports Apache Derby, Oracle, MS SQL Server, MySQL, PostgreSQL. HSQL.
Features
Features |
|---|
Developer oriented product |
Plugin Architecture |
Database Objects Tree Explorer |
Multiple SQL Command windows |
Multiple Result Tables |
SQL Syntax coloring |
Autocomplete SQL words |
Script handling |
Debugging tools (for scripts) |
Embedded Java Code Support (a la JSP) |
SQL generation |
SQL formatting |
Code Generation Tools (Java, J2EE, C#.Net using Neormf Framework) |
User Friendly Front end |
I18N including English, Arabic, French, Dutch and German |
Plugins
DBClient supports three types of plugins:
(1) messagesets:
Messagesets are language pack archive files for localizing DBClient messages.
To install a new messageset, simply download it to the $DBCLIENT$/messageset folder.
(2) iconsets:
Iconsets are icon pack archive files for customizing all icons.
To install a new iconset, simply download it to the $DBCLIENT$/iconsets folder.
(3) plugins:
Plugins are general purpose plugins. they are grouped in different groups for organization.
+ The dbsupport includes sql-centric plugins and all specific rdbms handling.
Thus, we could find a dbsupport plugin for Oracle, another for mysql and so on.
+ The presentation includes presentation-centric plugins which makes it possible to customize dbclient look and layout.
+ The tool includes general tools for dbclient.
To install a new Plugin, simply download it to the $DBCLIENT$/plugins folder.
Plugin |
Description |
|---|---|
derby-support |
Auto Identity support, View DDL |
postgresql-support |
Actually this is only a holder project for future PostgreSQL support |
mysql-support |
Actually this is only a holder project for future MYSQL support |
oracle-support |
View DDL supported Actually this is only a holder project for future Oracle support |
mssqlserver-support |
Auto Identity support, View DDL |
infonode |
Docking Support, More Plafs |
swinglabs |
Table sorting support, Session folding in Session Chooser, Better Error Handler |
recordeditor |
Plugin for simplifying Record Edition with generating dynamically a formula for inserting and updating table records. Provides also mechanisms to configure Fields Editors (checkboxes, comboboxes, etc...) |
searchengine |
This plugin enables searching into all of database data and schema information. |
neormf |
neormf (New Enterprise Object Relational Mapping Framework) is a Bottom-Up Code Generation Framework for a number of languages/platforms (Java/J2EE,C#/DotNet,...) and architectures, following main design patterns and frameworks. This plugin enables code generation from within DBClient. |
External links
cs:Java Database Connectivity da:JDBC de:Java Database Connectivity es:JDBC fr:Java database connectivity it:JDBC nl:Java DataBase Connectivity ja:JDBC no:JDBC pl:JDBC pt:JDBC ru:Java Database Connectivity sv:JDBC zh:Java数据库连接