Hi,
I am maintaining such an application and it is neither bulky nor slow.
It's all
a matter of implementation.
Can I have a link to the application or more info on that? I would be
interested to take a look into it.
Sure: http://www.sql-workbench.net
I have nothing against JDBC or JAVA (did my words sounded petulant
towards it?) but 90% of the databases do provide lowest level APIs in
C. Having an app in C helps us to use very very less memory (this I
say from my experience where I could get million record from a remote
server to my client at much faster rates then a another app).
That might be true, but then how often do you really *need* millions of records
on the client especially in a DB GUI where the primary task (at least that's how
I see it) is to run ad-hoc queries or check other results.
Which leads me to the (most important?) question: what do "we" understand under
the term "GUI for DB" is that a full featured data-entry where a normal end-user
can update data? Is that an admin tool for the DBA, which is intended to run
daily DBA taks? Or maybe even some kind of ETL tool?
> Lot of
times it has happened that the C API (atleast with MySQL and PGSQL C
API) provides some extra information which when smartly used can make
things lot efficient.
That is true, but then a tool supporting multiple DBMS will (most probably) have
to comprise now and then. Otherwise you'll wind up writing one tool for each
DBMS and simply combining them under a common GUI.
Also, why I started a thread with wxWidgets was because C/C++ is what
I have been using all my life and from my experience of developing
couple of cross platform simple GUI, I fount wxWidgets to most mature
and easy to use.
As I already mentioned, I'm a Java developer and naturally I find Swing most
mature and easy to use ;)
Actually if I look at tools that are written with wxWidgets (not that often) I
tend to find they look less like native Windows apps as a well written Swing
application using a recent JDK (1.5 or 1.6)
But that is largely a matter of taste I'd say, and everybody tends to prefer the
environment that he/she is familiar with
Thomas
