Database application on-the-fly type

We are looking for a simple yet powerful database application.  Something an almost non-tech person can use to create fast applications where it creates the screen, fields and database in an On-the-Fly manner.  Long time ago we worked with Clarion and Dataflex (both DOS version, 4GL) which has a similar design.  These applications you would draw out the main screen, place the supposedly fields, click a button and it would create the source code, database, etc.

We are not sure if there is anything similar out there and if free possible, but thought of trying EE experts on their experience on this matter.

Thank you in advance
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike EghtebasDatabase and Application DeveloperCommented:
Is this for hobby or some professional work? If professional work searching for something like that you will loose lots of time and effort and then will be returning to square one to start it all over again in a right manner.

Identify your platform, Access, SQL Server, etc.
Have a description of your business.
List your fields.
Make table structure (this is what database is).
Create forms and reports.

rayluvsAuthor Commented:
Not really for work.  We just want to know if there is an apps out there similar to what we describe in our question.
HuaMin ChenProblem resolverCommented:
I think you can try
Oracle Application express

and here is the download
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

rayluvsAuthor Commented:
Thanx for the info!

Read the link, trying to get info if it's in the area of what we are looking for.  Found that besides the apps to download, we need some sort of "Application Express" ("); besides other things.  

That being said, it looks like it may be out of scope (we think).  Nevertheless, trying to pinpoint for EE what we are looking for:
- an apps that creates data entry applications on the fly using the Windows form created by user.
- in the apps we are looking for, you would first design the data entry form, for example a customer form with names, address, telephones, etc., similar as when you create a Windows form in Vb.
- afterwards, the apps would create the actual data-entry screen and databases with fields based on the Windows Form created by the user (obviously the apps ask the field name and field type, etc.).
- the database not necessary sql, access, etc.; could be proprietary.
- with this type of app, user doesn't have to create the Windows form, then enter the code for each field and doesn't have to create the database separately.

Hope we gave additional info on the type of apps we are looking for.
HuaMin ChenProblem resolverCommented:
I think the point is that is not good to have everything done automatic, as that would be hard to code/develop elegant products!

Oracle Application Express is good and you can spend some time on that.
rayluvsAuthor Commented:
Understood.  Nevertheless we are trying to find one.

Thanx for your advice.
HuaMin ChenProblem resolverCommented:
PHPRunner can also be your choice

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rayluvsAuthor Commented:
Just were briefly thru the link and yes, something like that!

How do you call that type of solution? Do you know?
HuaMin ChenProblem resolverCommented:
You can download it and further go to its forum.
rayluvsAuthor Commented:
We are also looking for other type; but can't seem to identify an actual type of solution so we can search further
HuaMin ChenProblem resolverCommented:
The current tool I suggested, is quite high level and automatic, to develop interfaces, and you can practise on that, before going to others.
rayluvsAuthor Commented:
Yes thanx!  Long time ago we had a Windows apps that was this type where user would design the Windows data entry screen and the apps would then would create the database, Windows data entry screen.  

We try to find our old software to see the developer but couldn't find it so we thought maybe EE can help.

We would like to know if there other noises PHPRunner.
HuaMin ChenProblem resolverCommented:
To PHPRunner, we have to purchase, before we're able to use their Forum.

So it's better to try Oracle App Express instead.
rayluvsAuthor Commented:
Yes, but there is additional software to install (see In ID 41021531).

We going to wait for a while if another EE has any comments.

Julian HansenCommented:
If this is for a non online application you can look at MS Access. If you come from a Clarion background then this is probably the closest you are going to get.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you're looking for something that a single developer can design, and then others can simply "run" it, then note that the Access Runtime is free, so the users who do not need design methods can install the Runtime, and you can distribute your Access application to those users. Then you'd only need a single retail copy of Access to actually create the application.

There's also OpenOffice, which includes Base. Base is supposed to be analogous to Access, and you can create Forms, Reports, etc in the environment. I have never used it, so cannot comment on whether it's a good fit for your needs. It is free.

With all that said, your "work flow" mentioned earlier is a bit backwards. In most cases, you'd create the database and THEN create the forms and such that would be UI - you would not create the Forms, and then have the program create the tables to hold the information from those forms.
rayluvsAuthor Commented:
It does sound a bit backwards but the apps that we had years ago was actually like that, but only in the user-interface stage.  That is,

one would draw the data entry form on the screen first, when finish would click to process and the apps would start by creating the database according the fields on the screen asking for fields name, sorting, etc., finally finishing with the screen data entry design form.

... And bang!! You have your data entry apps in one single, on the fly process.

We know MS ACCESS and it's super easy but that's not what we are looking for; nevertheless, between all that has been said in this thread, it may might as well be the only thing as close.

Never heard of OpenOffice "base", but since it's derived from ms office, then we assume it ms access equivalent.

Ok, we'll look into both since we haven't used access for years.

We'll wait for a while but longer before closing the question.

Thanx for your help.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Never heard of OpenOffice "base", but since it's derived from ms office, then we assume it ms access equivalent.
It's not "derived" from Microsoft Office, but I'm sure it shares similar traits. Open Office is not associated with Microsoft Office in any way, at least as far as I know.

I think you're asking for the equivalent of a Bigfoot sighting :)
rayluvsAuthor Commented:

Ok thanx!
rayluvsAuthor Commented:
Sorry for the delay, been super sick for some time , but back at EE!

We will proceed to close this question.

Thanx All!
rayluvsAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.