phpmyedit-discuss

[PHPMyEdit-Discuss] Introduction

[Alex M. <al...@OW...>]

Hi folks,

I've only just started with PHP and phpMyEdit but since I am fairly 
experienced building web applications with perl, Java, and C++ I thought I 
ought to introduce myself and explain my interest in phpMyEdit

I'm finding that companies often want simple database applications which 
they don't want to pay much for.
To satisfy them I need to produce such database applications as swiftly and 
easily as possible.
Since the task of providing a web interface for listing records, creating 
new records, and editing existing ones is rather common and rather boring 
I've been looking for some kind of code generator like phpMyEdit.

Can anyone point me at projects similar to phpMyEdit and tell me why I 
should be using phpMyEdit and not anything else?

There seems to be something called phpMyAccess in SourceForge which has 
zero activity. Is it worth considering?

There doesn't seem to be a lot of traffic on this mailing list? Why isn't 
this project far more popular if it does what it is supposed to do?

Does phpMyEdit cope with complicated data types, enumerated data types such 
as reference datatypes?

Can I easily edit the code which phpMyEdit generates and still have those 
changes if I need to change the database schema?


Cheers

Alex McLintock






Openweb Analysts Ltd, London.
Software For Complex Websites http://www.OWAL.co.uk/
Open Source Software Companies please register here 
http://www.OWAL.co.uk/oss_support/

Re: [PHPMyEdit-Discuss] Introduction

[Ondrej J. <ne...@po...>]

> Can anyone point me at projects similar to phpMyEdit and tell me why I
> should be using phpMyEdit and not anything else?

	I do not know a lot about similar projects, even in other than PHP
programming language. Maybe the phpLens, but AFAIK this is commercial (maybe
also free, I do not know) product with different approach than phpMyEdit.
See http://phplens.com/ for more info.

> There doesn't seem to be a lot of traffic on this mailing list? Why isn't
> this project far more popular if it does what it is supposed to do?

	I do not think that this project is not so popular. My 5.2 release
download stats say something else. Problem is, that this project had no
activity since February 2002. I have couple of patches prepared and in
August 2002 I became the project maintainer. Since that time I'm only fixing
hot issues, so there was no such time for better PR or propagation yet.

> Does phpMyEdit cope with complicated data types, enumerated data types
> such as reference datatypes?

	Sorry, can you be more descriptive? I do not understand this.
However, phpMyEdit can properly handle 'set' & 'enum' datatypes and do
simple 1:N table lookups. M:N table lookup are on the long term.

> Can I easily edit the code which phpMyEdit generates and still have those
> changes if I need to change the database schema?

	Yes. You can even write loader code from scratch without setup code
generator usage. I'm doing it this way.

> Open Source Software Companies please register here
> http://www.OWAL.co.uk/oss_support/

	Is NGO supporting OSS also coonsidered as "Open Source Software
Company"? If so, why it should register there?

	=Nepto=
--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`

Re: [PHPMyEdit-Discuss] Introduction

[Alex M. <al...@OW...>]

Thanks for the info Ondrej,

I'll consider phpLens if it means that I can do work quickly and therefore 
win more contracts....

The fact that the project had no activity since Feb 2002 is a bit worrying. 
Is it because you need more people contributing code and docs....?



> > Does phpMyEdit cope with complicated data types, enumerated data types
> > such as reference datatypes?
>
>         Sorry, can you be more descriptive? I do not understand this.
>However, phpMyEdit can properly handle 'set' & 'enum' datatypes and do
>simple 1:N table lookups. M:N table lookup are on the long term.


That is pretty much what I am wondering.

> > Can I easily edit the code which phpMyEdit generates and still have those
> > changes if I need to change the database schema?
>
>         Yes. You can even write loader code from scratch without setup code
>generator usage. I'm doing it this way.


Loader code? this must be PHP terminology I am unfamiliar with.

For instance it doesn't look like phpMyEdit comes with any role based 
access control. That would be one of the first things I'd add. I would thus 
need to say something like "This action is only allowable if the user has 
this role" and have that code stay around even if the database schema 
changes and I have to re-run phpMyEdit.

> > Open Source Software Companies please register here
> > http://www.OWAL.co.uk/oss_support/
>
>         Is NGO supporting OSS also coonsidered as "Open Source Software
>Company"? If so, why it should register there?

I am trying to get companies or other organisations who support Open Source 
Software to stand up and be counted. I keep on hearing that the *perceived* 
lack of support for OSS (eg PHP) is the main reason why companies don't use 
it. So we are trying to correct that perception. There are companies out 
there who support OSS software - and my site helps list them.

Alex McLintock








Openweb Analysts Ltd, London.
Software For Complex Websites http://www.OWAL.co.uk/
Open Source Software Companies please register here 
http://www.OWAL.co.uk/oss_support/

Re: [PHPMyEdit-Discuss] Introduction

[Ondrej J. <ne...@po...>]

> >         Yes. You can even write loader code from scratch without setup code
> >generator usage. I'm doing it this way.
> Loader code? this must be PHP terminology I am unfamiliar with.

	Sorry for my bad terminology. I mean code what is usually generated
by setup script. I do not use this setup script, I wrote code for phpMyEdit
class from scratch (since I know the options much better than setup script).

> For instance it doesn't look like phpMyEdit comes with any role based
> access control. That would be one of the first things I'd add. I would
> thus need to say something like "This action is only allowable if the user
> has this role" and have that code stay around even if the database schema
> changes and I have to re-run phpMyEdit.

	Well phpMyEdit is just one class which object instance can provide
access to one database table. You can use more instances to handle more
database tables (roles, users). I have this implemented in phpMyEzin content
management system. Accoding to current logged user privileges is
$opts['options'] appropriatelly set. I hope you get the idea.

> > > Open Source Software Companies please register here
> > > http://www.OWAL.co.uk/oss_support/
> >         Is NGO supporting OSS also coonsidered as "Open Source Software
> >Company"? If so, why it should register there?
> I am trying to get companies or other organisations who support Open
> Source Software to stand up and be counted. I keep on hearing that the
> *perceived* lack of support for OSS (eg PHP) is the main reason why
> companies don't use it. So we are trying to correct that perception. There
> are companies out there who support OSS software - and my site helps list
> them.

	Yes, but we are not company but NGO (non-government organization) 
and we are not from England but Slovakia. Does registration apply also for 
us? :-)

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`