22 Mar
2010
22 Mar
'10
2:36 p.m.
Hi,
As you may already know Joomla! didn't participate in GSoC this year.
Last year I was a GSoC student doing a project for Joomla:
http://jwcp.googlecode.com/
Here you can find my last year's proposal: http://edo.webmaster.am/proposals/11
This year I want to extend it and make possible to select tables from
the database which can be kept under revision control with the help of
mysql triggers.
Currently in Working Copy I'm using a "spy" implemented with mysql
triggers which can log the changes made on the table.
What do you think can the versioning of mysql tables become a project
for phpMyAdmin?
Regards,
Edvard
22 Mar
22 Mar
5:56 p.m.
Edvard Ananyan a écrit :
Hi,
As you may already know Joomla! didn't participate in GSoC this year.
Last year I was a GSoC student doing a project for Joomla:
http://jwcp.googlecode.com/
Here you can find my last year's proposal: http://edo.webmaster.am/proposals/11
This year I want to extend it and make possible to select tables from
the database which can be kept under revision control with the help of
mysql triggers.
Currently in Working Copy I'm using a "spy" implemented with mysql
triggers which can log the changes made on the table.
What do you think can the versioning of mysql tables become a project
for phpMyAdmin?
In phpMyAdmin 3.3 we already have changes tracking; we expect would-be
participants to be familiar with the current phpMyAdmin version.
How would your project be different than what is currently in version 3.3?
--
Marc Delisle
http://infomarc.info
23 Mar
23 Mar
3:09 p.m.
Hi Marc,
As I can understand the tracking is implemented in the php code. So if
I run a query directly in the database without using phpMyAdmin
functions, the trucking will not function. However my idea is not the
tracking, I want to keep table row versions.
So here is what I think:
1. Add a new tab for a database table (like Tracking) -- Let's call it Revisions
2. Allow the user to enable revision control for that table -- user
can select which table fields need to be kept under control
3. Using php it will create new table called Table_history and will
add a mysql trigger on Table to add the row changes to the history
table. So in this case it will be implemented in the database, not in
the php code. So let's say I'm running a joomla site and I want to
keep jos_content table versions. I go to phpMyAdmin create a revision
for that table. So when I edit my content through the joomla
administration area, which is not running on phpMyAdmin php functions,
it will still keep revisions for that table.
Let me know your thoughts.
Regards,
Edvard
In phpMyAdmin 3.3 we already have changes tracking; we
expect would-be
participants to be familiar with the current phpMyAdmin version.
How would your project be different than what is currently in version 3.3?
--
Marc Delisle
http://infomarc.info
On Mon, Mar 22, 2010 at 3:36 PM, Edvard Ananyan <edo888(a)gmail.com> wrote:
Hi,
As you may already know Joomla! didn't participate in GSoC this year.
Last year I was a GSoC student doing a project for Joomla:
http://jwcp.googlecode.com/
Here you can find my last year's proposal: http://edo.webmaster.am/proposals/11
This year I want to extend it and make possible to select tables from
the database which can be kept under revision control with the help of
mysql triggers.
Currently in Working Copy I'm using a "spy" implemented with mysql
triggers which can log the changes made on the table.
What do you think can the versioning of mysql tables become a project
for phpMyAdmin?
Regards,
Edvard
3:16 p.m.
Edvard Ananyan a écrit :
Hi Marc,
As I can understand the tracking is implemented in the php code. So if
I run a query directly in the database without using phpMyAdmin
functions, the trucking will not function. However my idea is not the
tracking, I want to keep table row versions.
So here is what I think:
1. Add a new tab for a database table (like Tracking) -- Let's call it Revisions
2. Allow the user to enable revision control for that table -- user
can select which table fields need to be kept under control
3. Using php it will create new table called Table_history and will
add a mysql trigger on Table to add the row changes to the history
table. So in this case it will be implemented in the database, not in
the php code. So let's say I'm running a joomla site and I want to
keep jos_content table versions. I go to phpMyAdmin create a revision
for that table. So when I edit my content through the joomla
administration area, which is not running on phpMyAdmin php functions,
it will still keep revisions for that table.
Let me know your thoughts.
Regards,
Edvard
I see, but this is not a big enough project for 12 weeks of 40 hours, IMO.
--
Marc Delisle
http://infomarc.info
3:34 p.m.
Yes, it's not that big. But here what I propose in two words.
Can phpMyAdmin mentor this:
1. Implementation of the described table row revision control
2. Implementation of the same interface into Working Copy project
developed for Joomla: http://jwcp.googlecode.com
3. Also I want to implement ajax task tracking system for the same
project to avoid php execution timeouts. Because when a task takes
more than 30 seconds (by default on the most of hosting servers) and
php safe mode is on, which doesn't let set_time_limit(0), the task
fails. So I want to divide the task into small tasks and then use
javascript to fire that small tasks.
In this case both phpMyAdmin and Joomla will benefit.
Let me know your thoughts about this, or if you have any other suggestions.
Thanks,
Edvard
On Tue, Mar 23, 2010 at 4:16 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Edvard Ananyan a écrit :
Hi Marc,
As I can understand the tracking is implemented in the php code. So if
I run a query directly in the database without using phpMyAdmin
functions, the trucking will not function. However my idea is not the
tracking, I want to keep table row versions.
So here is what I think:
1. Add a new tab for a database table (like Tracking) -- Let's call it Revisions
2. Allow the user to enable revision control for that table -- user
can select which table fields need to be kept under control
3. Using php it will create new table called Table_history and will
add a mysql trigger on Table to add the row changes to the history
table. So in this case it will be implemented in the database, not in
the php code. So let's say I'm running a joomla site and I want to
keep jos_content table versions. I go to phpMyAdmin create a revision
for that table. So when I edit my content through the joomla
administration area, which is not running on phpMyAdmin php functions,
it will still keep revisions for that table.
Let me know your thoughts.
Regards,
Edvard
I see, but this is not a big enough project for 12 weeks of 40 hours, IMO.
--
Marc Delisle
http://infomarc.info
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
3:39 p.m.
Edvard Ananyan a écrit :
Yes, it's not that big. But here what I propose in
two words.
Can phpMyAdmin mentor this:
1. Implementation of the described table row revision control
2. Implementation of the same interface into Working Copy project
developed for Joomla: http://jwcp.googlecode.com
3. Also I want to implement ajax task tracking system for the same
project to avoid php execution timeouts. Because when a task takes
more than 30 seconds (by default on the most of hosting servers) and
php safe mode is on, which doesn't let set_time_limit(0), the task
fails. So I want to divide the task into small tasks and then use
javascript to fire that small tasks.
In this case both phpMyAdmin and Joomla will benefit.
Let me know your thoughts about this, or if you have any other suggestions.
Please ... I'm allergic to top-posting...
Your project mentored by a phpMyAdmin mentor needs to be related to
phpMyAdmin only.
Thanks,
Edvard
On Tue, Mar 23, 2010 at 4:16 PM, Marc Delisle <marc(a)infomarc.info> wrote:
--
Marc Delisle
http://infomarc.info
Edvard Ananyan a écrit :
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel Hi Marc,
As I can understand the tracking is implemented in the php code. So if
I run a query directly in the database without using phpMyAdmin
functions, the trucking will not function. However my idea is not the
tracking, I want to keep table row versions.
So here is what I think:
1. Add a new tab for a database table (like Tracking) -- Let's call it Revisions
2. Allow the user to enable revision control for that table -- user
can select which table fields need to be kept under control
3. Using php it will create new table called Table_history and will
add a mysql trigger on Table to add the row changes to the history
table. So in this case it will be implemented in the database, not in
the php code. So let's say I'm running a joomla site and I want to
keep jos_content table versions. I go to phpMyAdmin create a revision
for that table. So when I edit my content through the joomla
administration area, which is not running on phpMyAdmin php functions,
it will still keep revisions for that table.
Let me know your thoughts.
Regards,
Edvard
I see, but this is not a big enough project for 12 weeks of 40 hours, IMO.
--
Marc Delisle
http://infomarc.info
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
5295
days inactive
5296
days old
5 comments
2 participants
participants (2)
-
Edvard Ananyan -
Marc Delisle