Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 03-23-2006, 12:43 PM   #1
Registered: Apr 2004
Posts: 734

Rep: Reputation: 46
Fastest, easiest, way to creat a web database app?

What is the easiest way to create a simple, web-based, database application? Something like an asset management system.

I watched this 15 Ruby-on-Rails video, it looks promising. I know there are php/mysql application builders, I haven't tried any.

Any other opinions?
Old 03-24-2006, 06:22 AM   #2
Senior Member
Registered: Apr 2005
Location: London
Distribution: Arch - Latest
Posts: 1,522

Rep: Reputation: 45
are you trying to implement one in a workplace or build one to sell/use?

There are plenty of CMS' using PHP and MYSQL with all sorts of modules to do different things.
Old 03-24-2006, 11:51 AM   #3
Registered: Apr 2004
Posts: 734

Original Poster
Rep: Reputation: 46
I am not trying to implement a commercial package. Just something for a small group of users, maybe a single user. The sort of thing people often do with ms-access.

I realize there are a lot of CMS' using PHP and MYSQL with all sorts of modules to do different things. But there is no way those could have every specialized application covered.
Old 04-15-2006, 03:46 PM   #4
Registered: Apr 2004
Posts: 734

Original Poster
Rep: Reputation: 46
To answer my own question:

There are a lot of PHP code generators that make it easy to deveope simple database "CRUD" applications. Here are a few I've tried:

AppGini & PHPMagic. ($35 - $70) Cheap and easy to use, but not very
functional. Okay if you are making flat-file, unsecure, CRUD. No
authentication. No real relational functionallity. No event triggers. Windows only.

PHPRunner. ($199). Some authentication, but only one level. Some
relational capabilities, not great. Event triggers. Fairly easy to use,
but if you want to relate two or more tables, you have to hand code
the sql, which sort of defeats the purpose. Windows only.

dbQwikSite ($140 - $200). Some advanced features. But, slow and diffecult to work with. In fact, I couldn't get it to work at all. Windows only.

dataface (free). Interesting new project. Huge potential. But, not
really completed yet. No real security/authentication yet. Relational capabilities but awkward to use. Has, or will have event triggers.
No authentication yet. Not easy to work with. Has a "Plone" look to it, which may not be what you want. Any platform.

CodeCharge. ($150 - $500). I have looked at it, have not used it. Obviousy more expensive than others, and a steeper learning curve, but more powerful also. Works with all kinds of databases. Relational, event triggers, has built-in calendaring feature, has built-in report creating, excellent security/authentication features. Works will sorts of databases. Generates code for several differnt languages: PHP, ASP, etc. Any platform.

Other than the code generators, there are also several application frameworks available. Rails seems to be what they are all aiming to be. These have a much steeper learning curve. But they are often F/OSS, and provide much more flexability. I am presently trying CodeIgniter.

All reviews JMHO.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fastest,easiest and the best way to master linux. shyamsundar General 22 02-11-2006 10:21 AM
creat MySQL database for each user ? Data-Base SUSE / openSUSE 3 03-07-2005 03:42 PM
The fastest/zippiest, newest, easiest install/maintain, fullest (qlty sftwr) distro? SoccerballTux Linux - Distributions 8 10-13-2004 03:14 AM
Creat MySQL database for phpBB Pug405 Linux - Software 9 05-11-2004 02:24 PM
Fastest Web Browser? NCAussie Linux - Software 11 09-26-2003 05:52 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:53 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration