Thank you for jumping in Martin! I thought you would. :-)

Martijn Tonies wrote:

> > We've been using FlameRobin (latest version) but it has a few very
> > annoying glitches:
> >
> > 1. Cant cancel a long-running query without opening a separate instance
> > of FlameRobin and deleting the statement from the new monitoring tables.
>
> If the Firebird developers make this available via the API, like InterBase
> did, it would be much easier than running a query on the monitoring tables.

The client tool can expose this as a GUI command and handle the
delete.... from monitor... behind the scenes. No need for FB to expose
anything in its api for that.

> > 2. Can only execute one query at a time - no concurrency/multithreading.
>
> Database Workbench has that.

That's nice! Great!

> > 3. No support for multiple result grids (need to open separate query
> > windows for each query).
>
> None of the Firebird tools have that.

:-( I need this a lot, because I need to view one or a few records from
each of five-or-so tables to make decisions about update/delete/other on
some specific records. UNION is not an option because the column sets
are too different, and multiple query windows just isn't useful for this
(too much work to get the data). MS Query Analyser does this very
nicely, but I want to move off MSSQL.

> > 4. Fails to handle UTF8 identifiers correctly in various places
> > (messages, table/column tree, ...).
>
> I can say that Database Workbench has some limitations in handling
> unicode data as well, partly caused by IBObjects.

:-(

> Hopefully, with Delphi 2009, this can be solved in a next major release
> instead of having to jump through hoops with all sorts of 3rd party
> components and so on.

Any hints about release date? Progress? Status?

> > So, what alternatives would you recommend?
> >
> > Commercial tools are fine - we'll compare prices as well as
> > features/functionality, stability etc.
> >
> > My colleague has had a quick look at Database Workbench but he wasn't
> > very impressed. I'm interested to hear other's opinions on this tool,
> > and also interested in comparisons between your recommended tool and
> > FlameRobin as well as DB Workbench.
>
> Sorry to hear that, I do wonder what you expect then.

What he said was this (my translation):

The tool is often slow and has a tendency to freeze (at least on my
computer). Very frustrating. Apart from that, it's full of features and
neatly done. A lot more complete than FlameRobin.

Feel free to comment - I haven't had time to test it myself yet, but I will

> > If the same tool can also support SQL Server 2008, it would be a plus,
> > but not required.
>
> Database Workbench does that ;-)

I know. :-)

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64