CRUD tool to manage a single table?

Hello

A friend of mine asked me to whip a way for him to manage a
single table, so I figured PHP + MySQL will do the job.

I need the usual:
- create/modify/delete a record through a form. Some items are
multiple-choice like Country, etc.
- list/delete records from a list. The list must be sortable through
some of the columns (ASC, DESC)

This is so common that I'm sure there some ready-to-use solutions.
What would your recommended that is very light and easy to use (ie. no
portal, etc.)

Thank you.

Re: CRUD tool to manage a single table?

Hello,

on 01/28/2008 08:51 PM Gilles Ganault said the following:
> Hello
>
> A friend of mine asked me to whip a way for him to manage a
> single table, so I figured PHP + MySQL will do the job.
>
> I need the usual:
> - create/modify/delete a record through a form. Some items are
> multiple-choice like Country, etc.
> - list/delete records from a list. The list must be sortable through
> some of the columns (ASC, DESC)
>
> This is so common that I'm sure there some ready-to-use solutions.
> What would your recommended that is very light and easy to use (ie. no
> portal, etc.)

You may find some solutions here:

http://www.phpclasses.org/searchtag/crud/by/package/tag/crud /

--

Regards,
Manuel Lemos

PHP professionals looking for PHP jobs
http://www.phpclasses.org/professionals/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

Re: CRUD tool to manage a single table?

On Jan 28, 11:22 pm, Manuel Lemos wrote:
> Hello,
>
> on 01/28/2008 08:51 PM Gilles Ganault said the following:
>
> > Hello
>
> > A friend of mine asked me to whip a way for him to manage a
> > single table, so I figured PHP + MySQL will do the job.
>
> > I need the usual:
> > - create/modify/delete a record through a form. Some items are
> > multiple-choice like Country, etc.
> > - list/delete records from a list. The list must be sortable through
> > some of the columns (ASC, DESC)
>
> > This is so common that I'm sure there some ready-to-use solutions.
> > What would your recommended that is very light and easy to use (ie. no
> > portal, etc.)
>
> You may find some solutions here:
>
> http://www.phpclasses.org/searchtag/crud/by/package/tag/crud /
>
> --
>
> Regards,
> Manuel Lemos
>
> PHP professionals looking for PHP jobshttp://www.phpclasses.org/professionals/
>
> PHP Classes - Free ready to use OOP components written in PHPhttp://www.phpclasses.org/

Mysql-Admin (php) : http://sourceforge.net/projects/mysql-admin/

--
Kailash Nadh | http://kailashnadh.name

Re: CRUD tool to manage a single table?

On Mon, 28 Jan 2008 16:56:55 -0800 (PST), Kailash Nadh
wrote:
(snip)

Thanks guys, but

1. considering that CRUD is the bread-and-butter of computer
programming, isn't there a couple of major tools to do this for PHP?
It seems like no tool really gained traction. How come?

2. this is to write an application, so a database manager like
PhpMySQL or MySQL Admin won't do. I really need some tool to handle
this within the application

For instance, I've seen those:

http://p4a.crealabsfoundation.org/
http://codeigniter.com
http://www.fusebox.org
http://www.phpobjectgenerator.com/plog/
http://www.crudphp.com/
http://www.phpulse.com/
http://propel.phpdb.org/
http://www.qcodo.com
http://cakephp.org/

Thanks.

Re: CRUD tool to manage a single table?

Gilles Ganault wrote:
> On Mon, 28 Jan 2008 16:56:55 -0800 (PST), Kailash Nadh
> wrote:
> (snip)
>
> Thanks guys, but
>
> 1. considering that CRUD is the bread-and-butter of computer
> programming, isn't there a couple of major tools to do this for PHP?
> It seems like no tool really gained traction. How come?
>

It is useful for accessing databases, but I wouldn't call it the
"bread-and-butter" of computer programming.

> 2. this is to write an application, so a database manager like
> PhpMySQL or MySQL Admin won't do. I really need some tool to handle
> this within the application
>
> For instance, I've seen those:
>
> http://p4a.crealabsfoundation.org/
> http://codeigniter.com
> http://www.fusebox.org
> http://www.phpobjectgenerator.com/plog/
> http://www.crudphp.com/
> http://www.phpulse.com/
> http://propel.phpdb.org/
> http://www.qcodo.com
> http://cakephp.org/
>
> Thanks.
>

So write the code to do it. It would take less time to do that than
you've spent doing all of your searches. It's really a small job.

And since a general purpose application won't work, you need something
specific, anyway.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: CRUD tool to manage a single table?

On Mon, 28 Jan 2008 21:19:03 -0500, Jerry Stuckle
wrote:
>It is useful for accessing databases, but I wouldn't call it the
>"bread-and-butter" of computer programming.

I mean that probably a good 80% of programming jobs, especially LAMP
apps, revolve around creating, reading, updating records, so I
expected a couple of tools to have become standard.

Do PHP developpers all rewrite their eg. MySQL routines when they need
to handle DB tasks?

>And since a general purpose application won't work, you need something
>specific, anyway.

But precisely, this need comes up often, so it was the opportunity to
see what's available instead of copy/pasting the same type of code
again and again.

Re: CRUD tool to manage a single table?

Gilles Ganault wrote:
> On Mon, 28 Jan 2008 21:19:03 -0500, Jerry Stuckle
> wrote:
>> It is useful for accessing databases, but I wouldn't call it the
>> "bread-and-butter" of computer programming.
>
> I mean that probably a good 80% of programming jobs, especially LAMP
> apps, revolve around creating, reading, updating records, so I
> expected a couple of tools to have become standard.
>

I haven't found that to necessarily be the case. It all depends on what
you're doing. Some sites I have are quite heavy on DB access; others
don't do much at all.

> Do PHP developpers all rewrite their eg. MySQL routines when they need
> to handle DB tasks?
>

Sure. I encapsulate my DB access in classes. It doesn't take long,
then the pages are quite easy.

>> And since a general purpose application won't work, you need something
>> specific, anyway.
>
> But precisely, this need comes up often, so it was the opportunity to
> see what's available instead of copy/pasting the same type of code
> again and again.
>

I find it faster to write from scratch than try to modify something else
to make it work.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: CRUD tool to manage a single table?

Hello,

on 01/29/2008 12:12 AM Gilles Ganault said the following:
> Thanks guys, but
>
> 1. considering that CRUD is the bread-and-butter of computer
> programming, isn't there a couple of major tools to do this for PHP?

I thought you wanted something simple. Major tools are not simple.

I use Metastorage. This is not exactly a framework but rather a code
generation tool.

Metastorage takes the definition of a model with your application
persistent objects, including relationships, validation rules, and base
functions that you need your model to implement.

Then it generates the code for the classes to store and retrieve your
objects from database tables, as well any custom functionality you
requested to make the classes match the needs of your application.

Metastorage also generates a database schema definition and a special
class to install or upgrade the schema in the database of your
application enviroment.

It also generates report data extraction classes, which are more
efficient to retrieve data from the database for read only operations,
than using model access classes.

The generated code is very compact and practically as efficient as if I
would written in manually. The code is commented and is also database
independent. It supports MySQL, PostgreSQL, SQLite, Oracle and Microsoft
SQL server.

There would be a lot more to say about Metastorage. I just can tell you
in a few words that I have been using it since 2002 to speedup my PHP
database driven application development.

This is a very mature tool. It has saved me many hundreds of development
time when compared with traditional application development based on
writing your own database model access code manually.

If you want to know more you can find more information in:

http://www.metastorage.net/

Here you can see some screenshots of the code generator Web interface
and sample application pages:

http://www.meta-language.net/screenshots.html

Here you can see a sample application:

http://www.meta-language.net/metanews.html

Here you can see a quick start tutorial:

http://www.meta-language.net/metastorage-tutorial.html


> It seems like no tool really gained traction. How come?

Not everybody in the PHP world has the same views about a single
solution for the same problem.


--

Regards,
Manuel Lemos

PHP professionals looking for PHP jobs
http://www.phpclasses.org/professionals/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

Re: CRUD tool to manage a single table?

On Tue, 29 Jan 2008 01:23:45 -0200, Manuel Lemos
wrote:
>I use Metastorage. This is not exactly a framework but rather a code
>generation tool.

Thanks for the pointer. I'll take a look.

Re: CRUD tool to manage a single table?

On Mon, 28 Jan 2008 22:03:51 -0500, Jerry Stuckle
wrote:
>I find it faster to write from scratch than try to modify something else
>to make it work.

But productivity is pathetic compared to the tools we have in VB and
Delphi :-/

Re: CRUD tool to manage a single table?

Hello,

on 01/29/2008 01:55 AM Gilles Ganault said the following:
> On Mon, 28 Jan 2008 22:03:51 -0500, Jerry Stuckle
> wrote:
>> I find it faster to write from scratch than try to modify something else
>> to make it work.
>
> But productivity is pathetic compared to the tools we have in VB and
> Delphi :-/

You can use Delphi for PHP. Same IDE philosophy. I have reviewed it last
year:

http://www.phpclasses.org/reviews/id/B000NOIR8U.html

--

Regards,
Manuel Lemos

PHP professionals looking for PHP jobs
http://www.phpclasses.org/professionals/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

Re: CRUD tool to manage a single table?

Gilles Ganault wrote:
> On Mon, 28 Jan 2008 22:03:51 -0500, Jerry Stuckle
> wrote:
>> I find it faster to write from scratch than try to modify something else
>> to make it work.
>
> But productivity is pathetic compared to the tools we have in VB and
> Delphi :-/
>

It's all what you're used to, I guess. I find it faster to code in PHP.
But then I don't use any code-writing tools for web work.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: CRUD tool to manage a single table?

On Tue, 29 Jan 2008 02:14:20 -0200, Manuel Lemos
wrote:
>You can use Delphi for PHP. Same IDE philosophy. I have reviewed it last
>year:

Did you like it? Is it worth it, or just some 1.0 that Borland will
kill?

Re: CRUD tool to manage a single table?

Hello,

on 01/29/2008 03:41 AM Gilles Ganault said the following:
> On Tue, 29 Jan 2008 02:14:20 -0200, Manuel Lemos
> wrote:
>> You can use Delphi for PHP. Same IDE philosophy. I have reviewed it last
>> year:
>
> Did you like it? Is it worth it, or just some 1.0 that Borland will
> kill?

The generated code uses a specific methodology. It is not bad, buf if
you have your own methodology it is probably not very useful to you.

Other than that, there are things that are very good like the ability to
create your own plug-ins to extend the IDE using just PHP. AFAIK, it is
the only PHP IDE that can be extended using pure PHP code.

The debugger works right away out of the box with no further setup,
which is a big deal, I think.

Delphi for PHP is not very useful to me because it is only available for
Windows and I do not use Windows at all, but it may be a good
productivity tool for developers that use Windows on their desktop
machines to write PHP applications.

--

Regards,
Manuel Lemos

PHP professionals looking for PHP jobs
http://www.phpclasses.org/professionals/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

Re: CRUD tool to manage a single table?

On Tue, 29 Jan 2008 10:35:54 -0200, Manuel Lemos
wrote:
>Delphi for PHP is not very useful to me because it is only available for
>Windows and I do not use Windows at all, but it may be a good
>productivity tool for developers that use Windows on their desktop
>machines to write PHP applications.

Thanks for the feedback. I'll download a trial version and see what
it's like.