[Phpmyadmin-devel] Fwd: regex-replace UI suggestion

[Karol Danko]

Hi Mark, thank you for reply

I will use both POSIX (for WHERE) and PCRE for (match&replace)

The script will first select all rows matching WHERE fieldset
after that it will loop the results and handle the replace via PHP
(2nd fieldset MATCH and 3rd fieldset REPLACE)

(So to check all rows with PHP, the WHERE fieldset would be empty)

The problem however is the use of both POSIX and PCRE on the same page which
may be confusing,
but using only MySQL POSIX would make more complicated replaces impossible.
On the other hand using only PHP's PCRE and looping all the results may be
very inefficient on large result sets.


On Sun, Apr 10, 2011 at 12:45 PM, Marc Delisle <marc at infomarc.info> wrote:

> Le 2011-04-10 05:35, Karol Danko a écrit :
> > Hi everybody,
> >
> > (I used phpmyadmin-users mailing first but I did not receive any response
> so
> > sorry for double-post)
> >
> > I'm new to phpmyadmin development, so far I have been just passive daily
> > user.
> > I think phpmyadmin is great and I would love to help making it even
> better.
> >
> > I'm working on regex-replace interface for phpmyadmin:
> >
> http://sourceforge.net/tracker/index.php?func=detail&aid=1398891&group_id=23067&atid=377411
> >
> >
> > I would love to hear your thoughts about this concept I have, I suggest
> > following UI:
> > http://karoldanko.com/img/regex-replace.png
>
> Hi Karol,
> I'll have suggestions about the interface but first a question.
>
> Looking at http://dev.mysql.com/doc/refman/5.5/en/regexp.html it seems
> that MySQL REGEXP is based on POSIX extended regular expressions and not
> PCRE (which supports back references).
>
>
> --
> Marc Delisle
> http://infomarc.info
>
>
> ------------------------------------------------------------------------------
> Xperia(TM) PLAY
> It's a major breakthrough. An authentic gaming
> smartphone on the nation's most reliable network.
> And it wants your games.
> http://p.sf.net/sfu/verizon-sfdev
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110410/1631d444/attachment.html>