Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

pgAdmin III is only for PgSQL. I plan on a multidb one. Thats my idea
from the beginning. Atleast, support Mysql and PgSQL and and then
support other DB as time progresses.

On 11/29/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:

On Wed, 2006-11-29 at 13:00 -0600, Tony Caduto wrote:
> Ritesh Nadhani wrote:
> > Thanks to all for their suggestions and ideas. I believe that there is
> > indeed a scope for such a tool.
> >
> > My semester ends on 15th December and I get a one month break between
> > next semester. I will write a simple app in wxWidgets (that is what I
> > am comfortable with right now) to show what I am trying to do. From
> > there on, we can take this forward. If the prototype seems
> > interesting, we can take it forward and I am even willing to change
> > the toolkit/language if I find a much better viable alternative.
> >
> I can't remember if you intended for this to be open source, but why
> don't you just work with pgAdmin III
> i.e. enhance it .  It already uses WXwidgets and you wouldn't have to
> start from scratch.
>
> If you are thinking commercial, it's a tough racket with at least 6
> competitors in the market.

At least? Your forgetting many of them :).

Joshua D. Drake


>
> Later,
>
--

  === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
 http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate






---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Thanks to all for their suggestions and ideas. I believe that there is
indeed a scope for such a tool.

My semester ends on 15th December and I get a one month break between
next semester. I will write a simple app in wxWidgets (that is what I
am comfortable with right now) to show what I am trying to do. From
there on, we can take this forward. If the prototype seems
interesting, we can take it forward and I am even willing to change
the toolkit/language if I find a much better viable alternative.

On 11/29/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:

On Wed, 2006-11-29 at 08:42 -0800, Richard Troy wrote:
> On Wed, 29 Nov 2006, Ritesh Nadhani wrote:
> >
> > Hello
> >
> > I have been working with wxWidgets and I didnt face a problem. What
> > specific thing were broken in wxWidgets for Windows?
> >
> > Ritesh
>
> PLEASE take this offline - it's not even close to Postgres related.

You are absolutely correct, that is why this is a PostgreSQL mailing
list. ;)

The discussion of development toolkits for Open Source databases *is*
PostgreSQL (there is no Postgres here) related.

Sincerely,

Joshua D. Drake


--

  === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
 http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate






---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Hello

I have been working with wxWidgets and I didnt face a problem. What
specific thing were broken in wxWidgets for Windows?

Ritesh

On 11/29/06, John McCawley <[EMAIL PROTECTED]> wrote:

I have been struggling with this problem for a few years.  I have
written a basic relational database design tool:

http://www.hardgeus.com/pgdesigner/

I have completely rewritten this program 3 times.  I initially
implemented it in Fltk, but ran into a bunch of limitations in the API.
I rewrote it in WxGTK and was pretty happy with the results -- until I
ported to Windows.  My program was so abysmally broken in Windows that I
threw the code away and vowed never again to use WxWidgets.  I recently
ported the entire codebase over to QT4 and have been VERY happy with it.

Unfortunately, my love for QT4 has put my project into a bit of a
limbo...Most versions of Linux don't "play nice" with multiple versions
of the same API on the machine, and most Linux distros use QT3 since
that's the underlying API of KDE.I already get a ton of mail from
people trying to compile the old versions of PGDesigner, I'd hate to
think what would happen if I tried to release my QT4 version now...My
build setup is pretty nuts, to say the least:

http://www.hardgeus.com/index.php?ndailyupdateid=685

It sucks, because I use pgDesigner almost every day to visualize my
Postgres databases, but QT4 just isn't "there" enough for me to support it.

Anyway, you didn't ask for a novel...I would recommend QT3 for your
project.  I am not entirely certain how much I am using is QT4 specific,
but I have been very happy with the signal/slot architecture, clean
database handling, and very robust variant-like variable handling (i.e.
I don't have to have giant bloated type-checking when copying data out
of my database into a local variable).


Ritesh Nadhani wrote:

> Hey
>
> Sorry for the critical mistake. Pressed the SEND button too early. In
> the first para I meant:
>
> The reason I *want* to develop the project in wxWindows or a C/C++
> based toolkit is that in the end I would be able to compile a binary
> which will have least dependency and can be bundled for downloaded in
> a single binary. With my experience while developing and selling
> SQLyog, I came across many customers who were working on a slow dial
> up connection for whom downloaded a 10MB package was also a pain. I
> have had customers who just had plain vanilla Win98 machines and
> SQLyog used to run great on it.
>
> instead of:
>
> The reason I *don't want* to develop the project in wxWindows or a C/C++
> based toolkit is that in the end I would be able to compile a binary
> which will have least dependency and can be bundled for downloaded in
> a single binary. With my experience while developing and selling
> SQLyog, I came across many customers who were working on a slow dial
> up connection for whom downloaded a 10MB package was also a pain. I
> have had customers who just had plain vanilla Win98 machines and
> SQLyog used to run great on it.
>
> Ritesh
>
> On 11/28/06, Ritesh Nadhani <[EMAIL PROTECTED]> wrote:
>
>> Hello All
>>
>> Sorry for the late reply. Been a little busy with my assignments.
>>
>> I will try to answer all the queries in this mail.
>>
>> The reason I don't want to develop the project in wxWindows or a C/C++
>> based toolkit is that in the end I would be able to compile a binary
>> which will have least dependency and can be bundled for downloaded in
>> a single binary. With my experience while developing and selling
>> SQLyog, I came across many customers who were working on a slow dial
>> up connection for whom downloaded a 10MB package was also a pain. I
>> have had customers who just had plain vanilla Win98 machines and
>> SQLyog used to run great on it.
>>
>> Another reason why suggested wxWidgets is because I have worked with
>> it before and I am comfortable with the system. As somebody suggested,
>> even wxPython looks good as Python greatly increases the speed of
>> implementation.
>>
>> Also, IDEs like Delphi etc. are out of question as I cant afford to
>> buy the licenses.
>>
>> I have no experience with XUL but it looks good. I am not sure, how
>> easy is to design GUI with lots of forms etc, with XUL. Writing an
>> initial prototype in XUL will make things more clear.
>>
>> Even though I am not related to Webyog (developer of SQLyog) anymore,
>> I had started a project up there called SQLyog Max (which didn't work
>> due to time constraints rather then technological constraints) and we
>> even released one BETA release that had support for both MySQL and
>> PostgreSQL.
>>
>> I believe d

Re: [GENERAL] Only MONO/WinForms is a way to go

[Ritesh Nadhani]

Hello John

I see that pgEdit is for both Windows and Mac. Which toolkit did you
use to develop it and what are your primary development environment?

Ritesh

On 11/28/06, John DeSoi <[EMAIL PROTECTED]> wrote:


On Nov 28, 2006, at 2:05 PM, Tony Caduto wrote:

> They are serious applications, but they don't exactly have a lot of
> forms and look how long Mozilla was in development.

I think the various interfaces in something like Thunderbird shows it
can do all the standard GUI stuff pretty well.

> The reason there is no highly productive IDE for Linux/Mac with a
> nice forms designer and robust data binding is because in the grand
> scheme of things there are not a lot of
> desktop users for anything other than win32.  Sure there are lots
> of geeks that use Linux for their desktop, but not everyday users.
> Everyday users are the ones companies etc want to make software for
> and Linux etc just does not have those kind of users yet.
> The mac does, but they are small  in number
> CodeGear(Borland devtools group) will make a IDE for Mac or Linux
> when they can make a viable return on investment.  They
> experimented with Kylix, but it failed because they initially
> priced it to high and many open source users will not pay even a
> reasonable amount for a IDE.
>

There are highly productive IDEs for the Mac with all the goodies you
mention. But few are cross-platform.

Your statement about Windows desktop market share is correct, but it
is not the relevant point. Many people are interested in cross-
platform tools because they want to serve the Windows desktop market,
but not have to give up Linux or OS X to do it.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match



---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Hey

Sorry for the critical mistake. Pressed the SEND button too early. In
the first para I meant:

The reason I *want* to develop the project in wxWindows or a C/C++
based toolkit is that in the end I would be able to compile a binary
which will have least dependency and can be bundled for downloaded in
a single binary. With my experience while developing and selling
SQLyog, I came across many customers who were working on a slow dial
up connection for whom downloaded a 10MB package was also a pain. I
have had customers who just had plain vanilla Win98 machines and
SQLyog used to run great on it.

instead of:

The reason I *don't want* to develop the project in wxWindows or a C/C++
based toolkit is that in the end I would be able to compile a binary
which will have least dependency and can be bundled for downloaded in
a single binary. With my experience while developing and selling
SQLyog, I came across many customers who were working on a slow dial
up connection for whom downloaded a 10MB package was also a pain. I
have had customers who just had plain vanilla Win98 machines and
SQLyog used to run great on it.

Ritesh

On 11/28/06, Ritesh Nadhani <[EMAIL PROTECTED]> wrote:

Hello All

Sorry for the late reply. Been a little busy with my assignments.

I will try to answer all the queries in this mail.

The reason I don't want to develop the project in wxWindows or a C/C++
based toolkit is that in the end I would be able to compile a binary
which will have least dependency and can be bundled for downloaded in
a single binary. With my experience while developing and selling
SQLyog, I came across many customers who were working on a slow dial
up connection for whom downloaded a 10MB package was also a pain. I
have had customers who just had plain vanilla Win98 machines and
SQLyog used to run great on it.

Another reason why suggested wxWidgets is because I have worked with
it before and I am comfortable with the system. As somebody suggested,
even wxPython looks good as Python greatly increases the speed of
implementation.

Also, IDEs like Delphi etc. are out of question as I cant afford to
buy the licenses.

I have no experience with XUL but it looks good. I am not sure, how
easy is to design GUI with lots of forms etc, with XUL. Writing an
initial prototype in XUL will make things more clear.

Even though I am not related to Webyog (developer of SQLyog) anymore,
I had started a project up there called SQLyog Max (which didn't work
due to time constraints rather then technological constraints) and we
even released one BETA release that had support for both MySQL and
PostgreSQL.

I believe developing an actual prototype would help our cause more
then just deciding upon which tool kit to use. My semester gets over
on 15th December. I plan to sit with it after that. Right now I am
thinking of an architecture which can support something like this.

If you have any idea how something like should be designed or
architectured, please provide me with your invaluable suggestions.

In other related question, my primary desktop of usage is Mac OS X but
I will be buying a Ubuntu box soon so expect decent development
parallely in Mac and Linux. I am not sure about Windows but if we
write correct wxWidgets/wxPython code, it should be a 0 issue to get
it compiled in Windows.

Ritesh

On 11/28/06, Rich Shepard <[EMAIL PROTECTED]> wrote:
> On Tue, 28 Nov 2006, Merlin Moncure wrote:
>
> > For a general purpose language, lately I've been taking a really good look
> > at 'D', which looks to be an amazing language.  Has anybody tried to hook
> > up postgresql to D?
>
>No, I haven't. But, if you want a cross-platform language and GUI toolkit,
> consider Python and wxPython.
>
> --
> Richard B. Shepard, Ph.D.   |The Environmental Permitting
> Applied Ecosystem Services, Inc.(TM)|Accelerator
> <http://www.appl-ecosys.com> Voice: 503-667-4517  Fax: 503-667-8863
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>



---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Hello All

Sorry for the late reply. Been a little busy with my assignments.

I will try to answer all the queries in this mail.

The reason I don't want to develop the project in wxWindows or a C/C++
based toolkit is that in the end I would be able to compile a binary
which will have least dependency and can be bundled for downloaded in
a single binary. With my experience while developing and selling
SQLyog, I came across many customers who were working on a slow dial
up connection for whom downloaded a 10MB package was also a pain. I
have had customers who just had plain vanilla Win98 machines and
SQLyog used to run great on it.

Another reason why suggested wxWidgets is because I have worked with
it before and I am comfortable with the system. As somebody suggested,
even wxPython looks good as Python greatly increases the speed of
implementation.

Also, IDEs like Delphi etc. are out of question as I cant afford to
buy the licenses.

I have no experience with XUL but it looks good. I am not sure, how
easy is to design GUI with lots of forms etc, with XUL. Writing an
initial prototype in XUL will make things more clear.

Even though I am not related to Webyog (developer of SQLyog) anymore,
I had started a project up there called SQLyog Max (which didn't work
due to time constraints rather then technological constraints) and we
even released one BETA release that had support for both MySQL and
PostgreSQL.

I believe developing an actual prototype would help our cause more
then just deciding upon which tool kit to use. My semester gets over
on 15th December. I plan to sit with it after that. Right now I am
thinking of an architecture which can support something like this.

If you have any idea how something like should be designed or
architectured, please provide me with your invaluable suggestions.

In other related question, my primary desktop of usage is Mac OS X but
I will be buying a Ubuntu box soon so expect decent development
parallely in Mac and Linux. I am not sure about Windows but if we
write correct wxWidgets/wxPython code, it should be a 0 issue to get
it compiled in Windows.

Ritesh

On 11/28/06, Rich Shepard <[EMAIL PROTECTED]> wrote:

On Tue, 28 Nov 2006, Merlin Moncure wrote:

> For a general purpose language, lately I've been taking a really good look
> at 'D', which looks to be an amazing language.  Has anybody tried to hook
> up postgresql to D?

   No, I haven't. But, if you want a cross-platform language and GUI toolkit,
consider Python and wxPython.

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|Accelerator
 Voice: 503-667-4517  Fax: 503-667-8863

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Hello Herald

Somebody mailed me earlier also regarding dabodev but its not what I
am talking about.

I took a look at dabo and it definitely serves one part of application
that I have in mind but more specifically I was thinking of starting
with a admin/developer tool like TOAD, MS Query Analyzer, MySQL GUI
tools rather then those form building but yes, in the long run - it
will be part of the tool or in form of another specific tool. Maybe we
can just integrate it with our tool line up later on.

All others, I will reply to you in could of days. I have two
assignments due in next 2 days so things are little crazy. Will reply
to each and every point.

On 11/27/06, Harald Armin Massa <[EMAIL PROTECTED]> wrote:

Ritesh,

what you are trying to do sound very similiar to dabo:

http://dabodev.com/

Maybe have a look at it first?

best wishes

Harald



--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Hello

On 11/26/06, Thomas Kellerer <[EMAIL PROTECTED]> wrote:

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



Thanks. If I ever start a project like I am thinking, your application
would be definitely of lot of help.  I have added the website in my
bookmark.


> 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.



Even I thought so but a newbie who works on couple of earlier project
do execute such queries and in the end it becomes a good marketing
paradigm also where you can show off that it can handle X million row
result also without any problem. Agreed, such people would be less
then 5% of the total userbase but it does gives us good
differentiating option then other GUIs.


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?



That is a very legitimate question. The project will start off as a
data entry app where a user can see all the DB objects like tables,
columns, indexes etc. Exceute queries, create db objects like table,
columns, etc. As the project becomes more mature, we add more features
for a DBA like backup, restore db, user management, log management
etc. And finally a good and state of the art query builder & designer
and if technology permits, a two-way query builder is what I intend to
target.


 > 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.



Yes. That is exactly what I am thinking of. It definitely looks
daunting but with community support, I think it i possible. The first
and foremost thing that needs to be done is coming up with a very
flexible and pluggable architecture where I define a common set of
interface for all DBs and then what remains is to just fill in the gap
for individual databases.

This would be best done if inidividual DB expert takes up an interface
to code for their respective DB. This way we would be able to extract
the maximum juice from each DB.


> 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)


Fair enough. Maybe, there is a way where we could integrate wxWidgets
and JAVA Swing but I am not sure if its possible. Maybe, somebody can
put more pointer on this one.



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



Ritesh





---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Thanks for the info. I will take a look at it soon.

On 11/25/06, John DeSoi <[EMAIL PROTECTED]> wrote:

> New Project: wxWidgets based cross-platform GUI for Open Source
> databases


You might also want to investigate XUL (http://en.wikipedia.org/wiki/
XUL). In addition to having low level C/C++, you can provide the
ability to create interfaces with XML and JavaScript. Applications
can run stand alone (XUL Runner) and perhaps interesting XUL browser
plugins would be possible.





John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL




---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Hello

On 11/25/06, Richard Troy <[EMAIL PROTECTED]> wrote:


Hi Ritesh,

I'm in support of Tomi's comments (especially those about consulting), and
have a few more thoughts to add. To wit:

First, as an aside, as I didn't know anything about SQLyog, I read your
post first, then went to the URL cited. Throughout your post, it wasn't
clear what the subject was exactly as it seemed you were talking in some
places about a database management interface and in other places some kind
of development environment for people to create cross-platform GUIs in. As
you expand your search for volunteers, you might consider making this more
clear - I'm sure I'm not the only one who doesn't/didn't know what SQLyog
is...



Well, sorry if my words were confusing. I was thinking of an MS SQL
Query Analyzer, SQLyog, PGAdmin kind of tool to start with which will
provide a basic admin tool initially. And based upon that
layer/architecture we will provide more advanced tools like query
builder etc.

I think I jumped the boat far too quickly, I also meant a development
environment to be provided by this tool later on but come to think of
it, it is already provided by OpenOffice so we wont probably need to
think on that line.

So I guess, the tool that I have in mind is a database management
interface - something like Toad for Oracle (which probably everybody
knows).


On Sat, 25 Nov 2006, Ritesh Nadhani wrote:
>
>  Hello all
>
> Let me introduce myself first. I am the ex-lead developer of SQLyog
> (one  of the most popular GUI for MySQL which is Windows only and runs
> on  Linux through WINE, more info at http://www.webyog.com).
>
> ===
> New Project: wxWidgets based cross-platform GUI for Open Source databases
> ===
>
> ===
> Motivation
> ===
>
> I have recently shifted to US to study for MS (and hopefully PhD in Univ
> of Iowa). I have also shifted to Mac OS X as my primary usage machine
> (after lifetime of Windows devotion).
>
> As part of my coursework, I work with MySQL and PostgreSQL
> extensively. I searched but couldnt find any GUI which has similar
> power like SQLyog by any means. I have tried (and have tried before
> also) various GUIs for respective databases but somehow the features
> in them are restrictive and are not powerful enough for developers
> like me who writes lots of SQL queries and needs to get things done
> fast.
>
> We can say that we already have enough GUIs for all open source
> databases (open source as well as commercial) available in the market
> but are they powerful enough to suffice the needs of an experienced
> SQL developer as well as newbies. The top three problems with existing
> GUI managers are:
>
> - Most of the usable/powerful GUIs are not open source which is one of
> the most powerful motivation for us to look for an alternate solutions.
>
> - 90% of such GUIs are DB specific. It becomes very hard for developers
> who work with multiple DBs as part of their work. It forces them to
> learn different user interface/softwares to work with the respective
> databases.

A few thoughts here; each db engine has its own;

- sql dialect, dispite the best efforts of SQL92 et al.

- sql query plan output mechanism and format

- naming restrictions (some know from context what table/attribute names
are while others absolutely demand reserved-words remain reserved, even
when they'll never be found in a particular context) - presuming you want
to provide, "works here but not there" advice.

- system catalogs

- index structures

- transaction log semantics

- lock management - presuming you wish to include a "which transaction has
the lock" functionality

- activity/error/security log systems - presuming you wish to provide
error resolution assistance

- maintenance tools suite, like Postgres' vacuum

- backup and recovery suite



Yes I know that. So we can make our architecture to be modular where
each db interface use its own most efficient way rather then a generic
way which would make things slow. And if a feature is not provided by
a DB, that option would be just turned off for that DB.

My motivation for the idea comes from the plauggable engine support
that MySQL provides.


>
> - Of the few multiple-db GUIs, 99% (or probably 100%) use JDBC/ODBC
> layer to connect and work with the databases and JAVA or some other kind
> of high level toolkit/language to develop the GUI. This results in
> applications being bulky and slow and never able to provide the speed
> that a low level C/C++ client API provide and are supported by all of
> the standard databases.

The reason - a reason - JDBC (and I presume ODBC) is so popular for these
purposes is that it helps resolve a handful - a large handful - of the
challenges of writing cross-database-platform.



As I replied in my previou

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Hello

On 11/25/06, Thomas Kellerer <[EMAIL PROTECTED]> wrote:

> - Of the few multiple-db GUIs, 99% (or probably 100%) use JDBC/ODBC
> layer to connect and work with the databases and JAVA or some other kind
> of high level toolkit/language to develop the GUI. This results in
> applications being bulky and slow and never able to provide the speed
> that a low level C/C++ client API provide and are supported by all of
> the standard databases.

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.


Just an example: with the enhanced batching in Oracle's current JDBC driver
(yes, I know this is an Oracle list) I can even achieve the same import speed as
SQL*Loader when importing flat files.



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).  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.

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.

But somebody in one of his replies suggested XUL. I will read about it tomorrow.


Btw: coming from a Java world, I do consider HSQLDB and Derby belonging to the
list of "standard databases"



I am sure there would be ways to provide for support for them too but
I am not sure as of now.


Thomas



Ritesh



---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

[GENERAL] Development of cross-platform GUI for Open Source DBs

[Ritesh Nadhani]

Hello all

Let me introduce myself first. I am the ex-lead developer of SQLyog
(one  of the most popular GUI for MySQL which is Windows only and runs
on  Linux through WINE, more info at http://www.webyog.com).

===
New Project: wxWidgets based cross-platform GUI for Open Source databases
===

===
Motivation
===

I have recently shifted to US to study for MS (and hopefully PhD in Univ
of Iowa). I have also shifted to Mac OS X as my primary usage machine
(after lifetime of Windows devotion).

As part of my coursework, I work with MySQL and PostgreSQL
extensively. I searched but couldnt find any GUI which has similar
power like SQLyog by any means. I have tried (and have tried before
also) various GUIs for respective databases but somehow the features
in them are restrictive and are not powerful enough for developers
like me who writes lots of SQL queries and needs to get things done
fast.

We can say that we already have enough GUIs for all open source
databases (open source as well as commercial) available in the market
but are they powerful enough to suffice the needs of an experienced
SQL developer as well as newbies. The top three problems with existing
GUI managers are:

- Most of the usable/powerful GUIs are not open source which is one of
the most powerful motivation for us to look for an alternate solutions.

- 90% of such GUIs are DB specific. It becomes very hard for developers
who work with multiple DBs as part of their work. It forces them to
learn different user interface/softwares to work with the respective
databases.

- Of the few multiple-db GUIs, 99% (or probably 100%) use JDBC/ODBC
layer to connect and work with the databases and JAVA or some other kind
of high level toolkit/language to develop the GUI. This results in
applications being bulky and slow and never able to provide the speed
that a low level C/C++ client API provide and are supported by all of
the standard databases.

A simple to use GUI for all databases
===

The basic idea behind such a GUI is to develop a small footprint,
extremely fast, multilingual, cross platform administrator/development
tool for databases. One of the basic requirements thats this GUI will
fulfill is to allow a developer to efficiently execute/plan queries and
allow an administrator to quickly do jobs like backups/restores etc.
with fewest mouse clicks and across different databases.

Once the basic architecture has been set, I plan to extend it to support
advanced features like MS Access like form development, query builder,
scheduled backups, data synchronization, configuration management,
replication manager, user manager etc.

wxWidgets
===

Since last couple of years, wxWidgets (formerly wxWindows) has
transformed itself into a highly powerful cross-platform GUI library
which when compiled gives the native look and feel of the host operating
system. This is something which other libraries like Qt, JAVA lack.

More info about wxwidgets can be found at: http://www.wxwidgets.org.


Yet unnamed DB management environment
===

I dont have the time nor the resources to do everything by myself. As I
see, there are too many things which are best distributed among
people/developers who are good at those specific things. E.g. I will
require good graphics designer to develop the icons for the tool, web
developer to keep the website updated, db specific veterans to best code
individual db management code etc.

Also, it would be a great way to learn some programming and show it as
part of your undergraduate/graduate project development requirement  :)

Is it viable?
===

I am not too big a fan of reinventing the wheel or work on a project
which will go bust in couple of years? So what I want is from you people
a little initial idea and discussion about such a tool. Is it viable? Is
it OK to develop such a tool? Will people use it?

I am cross posting this to various db mailing lists as well as relevant
newsgroups to get maximum idea about it. You can also contact me
directly at [EMAIL PROTECTED] if you would be interested.

Waiting for your comments.

-- Ritesh

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [GENERAL] Compiling/Installing as a non-admin user

[Ritesh Nadhani]

Thanks to all of you.

I have get it up and running according to my needs. Help by everybody is 
appreciated!


Richard Huxton wrote:

Gurjeet Singh wrote:
You are talking about /usr/local/data; so I assume that you are trying 
this

on Linux or some other Nixen.

You just need to use the --prefix option to configure... Here's what I
typically do:

Download/'CVS checkout' the sources. Enter the source directory, and 
invoke

configure like this:

./configure --enable-debug --prefix `pwd`/db CFLAGS=-O0

And the run 'make' and 'make install'. This will install the data in your
/db/data.


And then of course you'll need to remember to set your port to something 
other than 5432, and tweak your PATH, PGPORT etc or define some 
aliases/wrappers so you don't end up running against the default 
installation. Oh, and you'll need to tweak the startup scripts and 
logging configuration so you get logs somewhere useful.


I think Tom Lane has a script that lets him switch between different 
installations (versions in his case). I only tend to have two versions 
active at any one time, so I just define an alias for psql.

  alias psql82='/usr/local/pgsql82/bin/psql -p 5434'
On the rare occasion when I run an 8.2 createdb I need to remember to 
put the port number in manually of course.


HTH


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Updated: Compiling/Installing as a non-admin user

[Ritesh Nadhani]

Hello All

Thanks for all the suggestions. I was able to configire and compile it. 
I set the data directory to one of my directories, use 'initdb' 
successfully. I am also able to start the pgsql and can see that it is 
running on port  as I had configured.


Now the problem is when I try to create a db using createdb, I get the 
error:


createdb: could not connect to database postgres: FATAL:  role "ritesh" 
does not exist


I am not sure what is that?

Doing a google gave me: 
http://pgfoundry.org/pipermail/pgcluster-general/2006-May/000699.html


> You must be postgres user to run this. Another option might be 
passing > a user switch .


I cannot run with postgres as I dont have access and I am not sure how 
to use the user switch? Any help?


I guess once I am through with this, I am successful!

Ritesh

Richard Huxton wrote:

Gurjeet Singh wrote:
You are talking about /usr/local/data; so I assume that you are trying 
this

on Linux or some other Nixen.

You just need to use the --prefix option to configure... Here's what I
typically do:

Download/'CVS checkout' the sources. Enter the source directory, and 
invoke

configure like this:

./configure --enable-debug --prefix `pwd`/db CFLAGS=-O0

And the run 'make' and 'make install'. This will install the data in your
/db/data.


And then of course you'll need to remember to set your port to something 
other than 5432, and tweak your PATH, PGPORT etc or define some 
aliases/wrappers so you don't end up running against the default 
installation. Oh, and you'll need to tweak the startup scripts and 
logging configuration so you get logs somewhere useful.


I think Tom Lane has a script that lets him switch between different 
installations (versions in his case). I only tend to have two versions 
active at any one time, so I just define an alias for psql.

  alias psql82='/usr/local/pgsql82/bin/psql -p 5434'
On the rare occasion when I run an 8.2 createdb I need to remember to 
put the port number in manually of course.


HTH


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[GENERAL] Compiling/Installing as a non-admin user

[Ritesh Nadhani]

Hello All

Me and my professor are planning to work upon machine learning in 
postgresql over tsearch2. So I have some questions:


We have a server where Postgresql is running without any problem with 
postgres username and admin rights. I have a user account in that 
server. I plan to compile and run another postgresql for our testing so 
I was thinking of how to do that? My prior knowledge of using postgresql 
has always been as admin where I have full rights.


As I see, using the default MAKE for postgresql will set the data 
directory etc. in /usr/local/data etc which I dont have access to as a user.


So I would like to compile and run postgresql as a normal user with 
every thing like data kept in my usr directory. I should be able to run 
the instance over separate port and can start and stop it.


Basically, I want to run the server as in user mode

How should I configure the MAKE and INSTALL in this circumstances? What 
are your suggestions


Ritesh

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

[GENERAL] Question with tsearch2 (or it might be a general one too)

[Ritesh Nadhani]

Hello

A newbie to PostgreSQL from MySQL and just trying to learn tsearch2. In 
one of the examples at:


http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html

the query given is:

SELECT intindex, strTopic FROM tblmessages
WHERE idxfti @@ to_tsquery('default', 'gettysburg & 
address')

AND strMessage ~* '.*men are created equal.*';

What does the '@@' in the query means?

I did a search at:

http://search.postgresql.org/www.search?ul=http%3A%2F%2Fwww.postgresql.org%2Fdocs%2F8.1%2Finteractive%2F%25&fm=on&cs=utf-8&q=%40%40

an it dosnt return any result.

Is this specific to tsearch2? What does that mean?

Ritesh

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/

Re: [GENERAL] Some newbie question

[Ritesh Nadhani]

Thanks.

So the implicit value means that PG gave it a name?

Jeff Davis wrote:

On Thu, 2006-10-19 at 18:32 -0500, Ritesh Nadhani wrote:

Hello

Just trying to play around with PostgreSQL. Some commands and their 
result are:


test=# create table ncbi ( id serial, title varchar(50), abstract text, 
primary key(id));
NOTICE:  CREATE TABLE will create implicit sequence "ncbi_id_seq" for 
serial column "ncbi.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"ncbi_pkey" for table "ncbi"

CREATE TABLE
test=# drop table ncbi;
DROP TABLE
test=# create table ncbi ( id serial, title varchar(50), abstract text); 

NOTICE:  CREATE TABLE will create implicit sequence "ncbi_id_seq" for 
serial column "ncbi.id"

CREATE TABLE

==

q1) Does 'implicit index' means that they have given a default name to 
the PK which I defined in the first query since I didnt give a name or 
does it mean one another index is created apart from the PRIMARY KEY?




It only creates one index, the primary key index.

Regards,
Jeff Davis





---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

[GENERAL] Some newbie question

[Ritesh Nadhani]

Hello

Just trying to play around with PostgreSQL. Some commands and their 
result are:


test=# create table ncbi ( id serial, title varchar(50), abstract text, 
primary key(id));
NOTICE:  CREATE TABLE will create implicit sequence "ncbi_id_seq" for 
serial column "ncbi.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"ncbi_pkey" for table "ncbi"

CREATE TABLE
test=# drop table ncbi;
DROP TABLE
test=# create table ncbi ( id serial, title varchar(50), abstract text); 

NOTICE:  CREATE TABLE will create implicit sequence "ncbi_id_seq" for 
serial column "ncbi.id"

CREATE TABLE

==

q1) Does 'implicit index' means that they have given a default name to 
the PK which I defined in the first query since I didnt give a name or 
does it mean one another index is created apart from the PRIMARY KEY?


Ritesh

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[GENERAL] Text retrieval & data mining features in PostgreSQL

[Ritesh Nadhani]

Hello all,

As part of my research work, I was looking at the text-retrieval 
capability of PostgreSQL.


As I see there are three resources:

-- http://techdocs.postgresql.org/techdocs/fulltextindexing.php
-- tsearch2
-- OpenFTS (which looks like a frontend for tsearch2).

I couldnt understand the difference between: 
http://techdocs.postgresql.org/techdocs/fulltextindexing.php and tsearch2.


Are there any other resources that I should look?

Ritesh

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings