10 Apr
2011
10 Apr
'11
6:35 a.m.
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&gr…
I would love to hear your thoughts about this concept I have, I suggest
following UI:
http://karoldanko.com/img/regex-replace.png
The 'Rows to replace' is simply a where statement
The second fieldset contains user defined regular expression matches.
Each regexp has sort of ID which is later used when addressing correct token
The last fieldset contains fields to be replaced.
Fields are replaced by addressing ID of the match and token, e.g. #1$2 means
token 2 from match 1
thank you in advance
Karol
10 Apr
10 Apr
7:45 a.m.
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&gr…
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
4:44 p.m.
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(a)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&gr…
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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
4:55 p.m.
Le 2011-04-10 15:44, Karol Danko a écrit :
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.
Indeed. About the interface, don't you think that introducing a new
syntax ($1 and #1) would be too confusing?
I think it would be better to offer a simpler syntax even if this means
having less functionality. Therefore you would keep the "standard" way
of using a backreference, a backslash followed by a digit.
On Sun, Apr 10, 2011 at 12:45 PM, Marc Delisle <marc(a)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&gr…
>>
>>
>> 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
--
Marc Delisle
http://infomarc.info
11 May
11 May
10:12 p.m.
Hi, I have done basic functionality - It still needs more work but any
feedback would be great
I did not implement the original proposal which can be found sooner in this
mailing list, instead I made it more simple as Marc Delisle suggested
screen:
http://phpmyadmin-regexreplace.karoldanko.com/screen1.png
just select 'regex' function in select fieldset, uncheck 'ignore' in
replace
fieldset
demo:
http://phpmyadmin-regexreplace.karoldanko.com/
user: parizank_test
pass: phpmyadmin
git:
http://repo.or.cz/w/phpmyadmin-regexreplace.git
On Sun, Apr 10, 2011 at 9:55 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Le 2011-04-10 15:44, Karol Danko a écrit :
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.
Indeed. About the interface, don't you think that introducing a new
syntax ($1 and #1) would be too confusing?
I think it would be better to offer a simpler syntax even if this means
having less functionality. Therefore you would keep the "standard" way
of using a backreference, a backslash followed by a digit.
On Sun, Apr 10, 2011 at 12:45 PM, Marc Delisle <marc(a)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&gr…
>>
>>
>> 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
--
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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
12 May
12 May
8:18 a.m.
2011/5/12 Karol Danko <quibusus(a)gmail.com>om>:
Hi, I have done basic functionality - It still needs
more work but any
feedback would be great
I did not implement the original proposal which can be found sooner in this
mailing list, instead I made it more simple as Marc Delisle suggested
screen:
http://phpmyadmin-regexreplace.karoldanko.com/screen1.png
just select 'regex' function in select fieldset, uncheck 'ignore' in
replace
fieldset
demo:
http://phpmyadmin-regexreplace.karoldanko.com/
user: parizank_test
pass: phpmyadmin
git:
http://repo.or.cz/w/phpmyadmin-regexreplace.git
I think it would be useful to have some example available (eg. "how do
I replace all occurrences of 'Name Surname' with 'Surname Name'")
and
a link to MySQL docs explaining REGEXP syntax. Also, some explanation
on Function column would be nice.
Check for column types, phpMyAdmin doesn't show REGEXP operator for
int columns - in this case col1 in Replace is useless (?).
--
Piotr Przybylski
4867
days inactive
4899
days old
5 comments
3 participants
participants (3)
-
Karol Danko -
Marc Delisle -
Piotr Przybylski