Latest version

Version: 3.2.3
Published: 2014-02-20

Articles

Data Widgets introduction
Data Browser tutorial
Press Release 2013-10-22

Links

DbShell
OpenSource Engine, which is used for low level database operations
Discussion
Discussion about DbShell and DbMouse and on CodePlex server
DatAdmin
Software, from which DbMouse was developed

Last changes

2014-01-19 Released version 3.0.0. Better suport of multiple connections. Improved usability.
2014-01-06 Major release version. Introduces data widgets technology (PRO). Adds ability to filtering and sorting of query resuls (FREE).
2013-12-29 Introduced Data Widgets technology, in BETA version 2.3.4
2013-12-12 Version 2.2.0, released DbMouse FREE
2013-12-09 Version 2.0.0, table designer, modify database model
2013-11-18 Version 1.4.0, Caching database structure, local storage for table data
2013-10-21 Version 1.2.0, Diagram tool, favorites, improved workspaces
2013-08-27 Version 1.0.11, Picture preview, XML editor, OpenStreetMap preview
2013-08-12 Master/detail support
2013-07-20 Released versin 1.0.4
2013-06-20 Launched DbMouse Web

Awards

Free download software

Data Widgets introduction

Data widgets is new functionality available in PRO edition, released in versions 2.3.4 (BETA) and 2.4.0 (RELEASE). Data widgets are set of widgets (user interface elements displaying data). Each widget is displaying result of query. Query can depend on parameters and on underlying object primary key.

Columns widget

The simplest widget is widget showing all values of all column in current row. This widget is supported by default, it is available in "Object lookup" tool, as in following screenshot.

Custom widgets

You can create custom widget, which shows some details from table row. It is available in table context menu.

Widget designer is started. In this designer, you can write your SQL command, which is executed, when widget data are required. SQL command is dependend on variable @value, which is filled with value of primary key column.

By default, the predefined query returns the some result as "Columns" widget. In fact, columns widget is implemented with this query.

SELECT * FROM [dbo].[Customer] where [CustomerId]=@value

We have a little bit modified this query. We have displayed only some colums, there are grouped by category (ID, Names). The result you can see in "Preview" pane.

select 'ID' as SetGroup
SELECT CustomerId FROM [dbo].[Customer] where [CustomerId]=@value
select 'Names' as SetGroup
SELECT FirstName, LastName FROM [dbo].[Customer] where [CustomerId]=@value

Widget types

DbMouse supports 3 types of widgets:

Datawidget can be also parametrized with following types of parameters:

Object browser

The most complex feature of data widgets is object browser. It composes together widgets showing data from the some source.

This screen shows composition of threee widgets (Columns, Map, Grid). Theere is available navigation between records (sequentially, or directly by writing primary key value).