SQL Database Designers inside - GoFuckYourself.com

mikesouth · 05-10-2012, 10:33 AM

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

nextri · 05-10-2012, 10:43 AM

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/

Brujah · 05-10-2012, 10:44 AM

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

mikesouth · 05-10-2012, 10:49 AM

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.

ilnjscb · 05-10-2012, 11:03 AM

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.

Why · 05-10-2012, 11:53 AM

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.

raymor · 05-10-2012, 12:09 PM

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.

u-Bob · 05-10-2012, 12:28 PM

Quote:

Originally Posted by raymor

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?

sarettah · 05-10-2012, 07:09 PM

Quote:

Originally Posted by mikesouth

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

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

.

mikesouth · 05-10-2012, 07:12 PM

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

raymor · 05-10-2012, 07:14 PM

Quote:

Originally Posted by u-Bob

is it available somewhere?

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.

05-10-2012, 10:33 AM	#1
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	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 __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

05-10-2012, 10:43 AM	#2
nextri Confirmed User Industry Role: Join Date: May 2004 Location: Norway Posts: 1,661	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/ __________________ DivaTraffic - Traffic for Models

05-10-2012, 10:44 AM	#3
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	maybe google the phrase crud generator and add the language you prefer __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

05-10-2012, 10:49 AM	#4
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	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. __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

05-10-2012, 12:09 PM	#7
raymor Confirmed User Join Date: Oct 2002 Posts: 3,745	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. __________________ For historical display only. This information is not current: support@bettercgi.com ICQ 7208627 Strongbox - The next generation in site security Throttlebox - The next generation in bandwidth control Clonebox - Backup and disaster recovery on steroids

05-10-2012, 11:03 AM	#5
ilnjscb Confirmed User Industry Role: Join Date: Jun 2009 Posts: 8,858	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.

05-10-2012, 11:53 AM	#6
Why MFBA Industry Role: Join Date: Mar 2003 Location: PNW Posts: 7,230	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.

05-10-2012, 07:12 PM	#10
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	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 __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.