Adventures in Quest for GUI RAD

From: typing80wpm(at)aol(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Adventures in Quest for GUI RAD
Date: 2005-05-05 21:17:06
Message-ID: 8C71FCEECA5CD37-3A0-10A2F@FWM-R37.sysops.aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

http://www.microolap.com/products/database/mydbacentral/

I was hoping to find a GUI Rapid Application development for Postgresql similar to the above. The above is the only thing I could find, but it seems to support only MySQL and not PostgreSQL. I am so anxious to find such a tool, if it would be well documented and easy to use, that I decided to download MySQL to give it a try. I am shocked to see how much more difficult it is to get MySQL going than it was to get PostgreSQL for Windows up and running. I though I would share this bit of information. I downloaded the Windows MySQL install from their official site, and it installed but did not leave me with any clear cut tool for Admin, to create tables. I tried to attach to it from a different workstation (which I WAS successful in doing with Postgresql) using MySQL ODBC, BUT I got a message that the server would not allow my host name to connect.

Google search yielded a solution
GRANT ALL PRIVILEGES on [dbname].* to '[user]'@'hostname]' identified by '[password]'
BUT
even though I could find their sql command line utility, I could not succeed in issuing the above command.

I was also shocked to see that they dont have a handy uninstall option. Google reveals that others have been puzzled by the absense of an uninstall, and one is simply advised to use Program ADD/Remove...

I did do a WAMP install on a Windows 98 machine, and the MySQL worked fine and dandy on that machine, with an ADM utility to create tables.


I just wanted to share with you how very difficult MySQL is , for me at least, than PostgreSQL was.

I am certain that if I go back to the bookstore and pick out one of those books with a CD in the back, that it will have the sort of install that I would need, and would give intelligible instructions as to how to get the thing off the ground.

I tried Rekall with Postgresql, and the tutorial/documention is so scanty, that I would be faced with hundreds of hours of struggle to make it do something.

I was pleased with the progress I could make with Visual Basic and Postgresql, as well as what I could do through MS Access. But it would be so nice to have something that paints screens quickly and allows one to develop things fast. Powerbuilder was nice when I tried it some years ago. I suppose if I do go to all the trouble to get MySQL working, then I may find out that the above mentioned Russian RAD IDE is vapor ware, or not something that will work smoothly. I am so surprised by the absense of such tools in general.

I realize that Tony Caduto may possibly encourage me to buy Delphi. I really am totally convinced by his arguments and examples, and I instantly ran out to google to see where I could purchase Delphi for some reasonable, affordable price, but I definitely do not want to deal with something like E-Bay, nor do I want to but the $99 student version and then apply some undocumented patchs to make it do ODBC connections. If I saw Delphi at something like Programmers Paradise, I might take an interest, but I do not. And several years ago, I had some experiences with people using Delphi, and their database server that make me not so enthusiastic to get involved... but I did want to give credit to Tony that his arguments for using Delphi are convincing, if it were readily available. And I do thank him for all his time and efforts to advise me.




Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Browning 2005-05-05 22:46:16 Anyone doing a 8.0.2-x86_64-RHEL4.rpm?
Previous Message Grant McLean 2005-05-05 21:03:43 Re: Slony v. DBMirror