views:

89

answers:

2

Thirty years ago, when I began to design and develop CRUD business applications, I envisioned that as time moved on, designing, prototyping and customizing business applications would become easier and more streamlined. In 1983, I discovered a simple, easy-to-use RDBMS called INFORMIX which enabled me to quickly define schemas, generate default, character-based CRUD forms and reports which could be quickly and easily customized to get an app up and running in a very short timeframe. When GUI front-ends and OOP langs started to make their appearance, I was under the impression that developing apps was going to be even faster and effortless, but to my disappointment, it has become more complex and time-consuming! What can be accomplished with one 4GL instruction can take several hundred lines of code with OOPL's. I have looked at several development environments and tools within the sea of products currently out there and have not been able to find a good Windows/GUI-based 4GL product which can quickly generate default screens and reports where I can then customize into a final product without it taking a long time to accomplish. I recently eval'd 4J's Genero Development Suite where I even encountered bugs/obstacles in getting the demo's to work!.. It feels like everything got more time-consuming and complicated when it was supposed to be the other way around!..

Does an easy-to-use, GUI/RDBMS-based rapid development system exist out there which can provide me a simple/fast way for developing CRUD apps?

+1  A: 

Filemaker will likely provide you with everything you've asked for here. It's easy to use, cost effective. http://www.filemaker.com and you can download a 30 day trial there as well.

There are a lot of people who will give FM grief, but the most recent version is a very solid product. Works on Windows and Mac. Good luck.

Joshua Smith
Filemaker Pro (Advanced) demo looks good so far!.. I've heard mixed reviews about this product. Is it truly capabale of delivering sophisticated business applications?
Frank Computer
Yes, it is. There are lots of applications in use written in Filemaker and it continues to be a living platform (they just released iphone and ipad versions, too). The mixed reviews are often from people who don't understand what niche it fills.
Joshua Smith
OK, well I'm going to judge the product based on my own experience when I eval it. My app is mainly single-user for small mom-n-pop pawnshops in Puerto Rico ( see video-demo at: www.frankcomputer.com ) and although it has comprehensive/sophisticated functionality, it doesnt have a high-volume of transactions or large tables. Im looking for a quick way of re-writting it mainly for providing a Win/GUI frontend while retaining existing functionality.
Frank Computer
Filemaker is perfect for that. The 'advanced' version of Filemaker has the ability to output stand alone applications and kiosk-type applications.
Joshua Smith
Ok then we shall see!.. It is my understanding that FMP's data manipulation language is not SQL-based (confirm?) however if I'm able to achieve my goals of quickly re-writing my current app with an FMP-based GUI, then so be it!
Frank Computer
You are correct: FMP is not SQL based (though it is relational).
Joshua Smith
A: 

Check out Oracle Application Express. Also works with the free Oracle Express Edition (XE) database.

ObiWanKenobi