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 Browser tutorial

This article shows some advanced features of data browser. Assume following database model:

If we open a table Album, default view looks like following:

Filtering

As you can see, apart from columns of "Album" table, lookups to column Artist.Name is shown.
The next image shows filtering capabilities. We are filte5ring all rows, which Title begins with "Black".

To set filters, you can use prepared dialogs. or you can write complex filter expression on your own.

Adding referenced columns

Often there is need to display column of referenced table. DbMouse shows lookups, but there is not possibility to use these lookups in quick filters, also only one column from table is used as lookup column. You could add any referenced column to display, as shown in following dialog:

We have added column Name froim table Artist, after confirming dialog table view looks like following:

We have create our custom column layout. Next time, I will show how to use more complicated column layouts and master/detail views.