SQL Database Designers inside
 

Years ago I worked for a company called Informix

They had a 4th generation language for application development called 4GL

basically it built your application off the underlying tables and views automatically, then you go in and tweak what was needed, add custom functionality etc.

is there a similar application that works with mysql and can generate default html/css for things like query by example, update table, add record etc based on the underlying table structure?

TIA

the cakephp framework has some functionality like that. Not for creating mysql tables, but to quickly build applications with index, add, edit, delete, create pages based on your table structure.

http://cakephp.org/
http://www.camelmedia.net/jing/SNAG_Program-0041.png

maybe google the phrase crud generator and add the language you prefer

TY I will take a look at cake....thats basically what I want to do I have the db design just want to quickly generate the basic add, update, delete front ends at the very least, QBE functionality would make it perfect.

There is some stuff like Seagreen that builds the form and the database together, and conceivably you could tweak both, but haven't seen anything like the tools the major RDBMS vendors have.

cake is bloated if all you need is simple data inputs.

this is a process called scaffolding. http://en.wikipedia.org/wiki/Scaffold_%28programming%29

there are a number of free web tools that will build out all the php files you need for you, based simple on a .sql file that you upload.

http://www.phpscaffold.com/ is an example.

I built something like that in Perl. It autogenerates search forms, add forms, etc. based on the fields in the database.

It's probably best used for admin panels and such where appearance isn't as important, so you can use the autogenerated firms without tons of customization.

is it available somewhere?

I do believe that codecharge will do that. I have not used it personally but one of the people I work with uses it all the time to slam out basic maintenance screens and so forth.

http://www.yessoftware.com/index2.php

Features

Visual IDE and Code Generator
Rapidly build web applications by generating robust, scalable programming code in ASP.NET (C#), ASP, PHP, Java Servlets, JSP, ColdFusion and Perl.

Database-to-Web Converter
Convert any database into a Web application in just a few minutes.

Web Reports, Calendars, Galleries, Charts, Ajax and more...
Transform yourself into a Web guru by using our powerful development environment for quickly creating advanced Internet applications.

Pre-built Solutions
Customize and enhance any of the examples included with CodeCharge:


Looks like they have a 20 day evaluation copy. http://www.yessoftware.com/download/...p?product_id=1

.

Thanks y'all and this thread completely proves that you really can do business and get valuable help on gfy...I googled my ass off to find something like this but having been out of the RDBMS side of things for a long time I had no idea what terms to use

Thank Y'all so much

It's not packaged up and documented anywhere, but if you shoot me an email I'll gzip something for you. If you include a three sentence description of what you hope to use it for I can give you a better idea if it'll likely be useful.

We've used it mainly for opt-in mailing databases, so the improvements over time have focused on that use.