Hi all
This is just a copy from my [blog][b], because I'm not sure everybody
here follows it.
As the project is over, I think it's time for some summary. I think
this year we got quite a good improvements. Most of them are already
merged in trunk, but they might need some polishing, especially as the
branches were developed separately and now they are first time used
together. Anyway if you want to give new code a try, please go to our
[demo server][1] and play with it!
So what do we have?
#### Import and export improvements
When I saw the proposal for first time, I thought that this is the best
prepared proposal I've ever seen and we must have this student. And it
turned to be true. Derek did great job, going in more directions than
proposal included and brought great improvements to phpMyAdmin.
To start with import part, phpMyAdmin can now take any spreadsheet or
CSV and create table from it automatically, with some kind of
heuristics to find out numerical or date columns.
On the export side, he integrated [PHPExcel][2] library and phpMyAdmin
can now generate proper Excel 2003 and 2007 documents.
The good thing also is that he wants to stay active even after GSoC.
#### Changes tracking
Even though Alexander Rutkowski was really quited in first half of the
project, he indeed did code in that time and he brought feature that
will be useful mostly for application developers. You can activate
tracking of certain table, all your changes will be logged and you can
get SQL commands to replay the changes on other database later.
This can be useful either for monitoring changes which users did or for
making changes on development system and applying them later on
production one.
#### Database synchronisation
Zahra Naeem did originally also apply for changes tracking, but as we
did not want to have two students on the same topic, we persuaded him
to take another project, which was not taken by other students -
database synchronisation. This feature is somewhat similar to previous
in one use case - you can use it to apply changes from development
system to production one. You enter connection settings for two
database servers and phpMyAdmin finds out difference between the
databases and allows you to synchronize them.
I feel like Zahra felt that almost everything is done in mid-term and
slowed down a lot and I'm still not happy with documentation he had
provided. Hopefully he will get to that and improve it.
#### Replication support
This project was mentored by Marc and to me it looks like Tomáš Srnka
did good job there. The changes are not yet in trunk, but hopefully
they will be merged soon and I will then try to set up some replication
stuff on demo server, so that you can play with it.
#### Permanent user preferences
The only unsuccessful project this year. The student failed to deliver
something for mid-term evaluation and because of this he failed. We
still have his patch in [patch tracker][3] and I think I will try to
find time to look at it more deeply, whether it is worth using and
cleaning up or it is better to write whole thing from beginning.
#### Summary
I think this Summer of Code was great and I hope next year we will be
really a separate project there and not under MySQL hood (not that
would be bad, but I think with five students it is better to be
directly there than coordinating with MySQL guys). And I hope we will
have more students like Derek :-).
[1]:http://demo.phpmyadmin.net/
[2]:http://www.codeplex.com/PHPExcel
[3]:https://sourceforge.net/tracker/?func=detail&aid=2825187&group_id=23067&…
[b]:http://blog.cihar.com/archives/2009/08/27/summer_of_code_in_phpmyadmin/
--
Michal Čihař | http://cihar.com | http://phpmyadmin.cz
Hi
Dne Fri, 21 Aug 2009 12:29:10 +0500
Zahra Naeem <xara.fast(a)gmail.com> napsal(a):
> My branch is ready and please process it separately.
> Please take the latest code from the branch as I have also committed after
> 17 Aug.
Where is the documentation?
> From my side all updations are done, I think you should inquire Tomáš about
> the status aswell.
Okay, waiting for his reply.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi all
while merging GSoC branches, I really understood how painful are
branches in SVN. I use Git for most other projects and such thing is
much easier there as well as it adds some other benefits
(eg. possibility to work offline).
As sf.net has gained support for Git recently, this brought me to
obvious question - how about to migrate to it? The migration of data
from SVN is quite easy, so this should not be the issue. But the
question is whether some of you know Git or are willing to learn it.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi all
two of GSoC branches are now merged, the remaining ones are tomas and
zahra. Is your common branch ready to get merged or each one should be
processed separately? I did not yet review the code, I just ask what
you two think about it.
PS: Merging with svn is not as good as with git and with addition of
slow and disconnecting sf.net servers it is really painful. I had to
split commits because otherwise they did terminate SSL connection...
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi all,
KEY ACCOMPLISHMENTS LAST WEEK
=============================
- Wrote additional documentation, added information about the
config vars to Documentation.html
- Used add_message(_file).sh to add lang vars.
- Made the tracking of SQL dump imports working.
- Created a short how-to video (see my blog).
- Asked friends to evaluate my project.
- Registered to PMA wiki, but can't edit all articles.
KEY TASKS THAT STALLED
======================
--
KEY CONCERNS
============
Evaluation
TASKS IN THE UPCOMING WEEK(s)
==========================
- Improve the mechanism
Of course I hope you will send me feedback.
You can test it at http://demo.phpmyadmin.net/gsoc-alex/
My blog is available at http://trackingmech.blogspot.com/
What do you think about video tutorials? Do we need it for PMA ?
In my view it's sometimes better than reading a lot of written howtos
with dozens of screenshots.
Best regards
Alexander
Hi all
as you might already noticed, we have first code from this year in
trunk. The first thing which got merged were import (and at the end
also export) improvements from Derek Schaefer. I think it is great
addition to our features and I hope now more people will actually test
it.
Just reviewing other students branches for merging them.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi
Dne Mon, 17 Aug 2009 21:46:16 +0000
drummingds1(a)users.sourceforge.net napsal(a):
> Revision: 12815
> http://phpmyadmin.svn.sourceforge.net/phpmyadmin/?rev=12815&view=rev
> Author: drummingds1
> Date: 2009-08-17 21:46:08 +0000 (Mon, 17 Aug 2009)
>
> Log Message:
> -----------
> Additions and change made to documentation, and other minor alterations.
>
> Modified Paths:
> --------------
> branches/gsoc/derek/phpMyAdmin/ChangeLog
> branches/gsoc/derek/phpMyAdmin/libraries/common.lib.php
> branches/gsoc/derek/phpMyAdmin/libraries/database_interface.lib.php
> branches/gsoc/derek/phpMyAdmin/libraries/import/xls.php
> branches/gsoc/derek/phpMyAdmin/libraries/import/xlsx.php
> branches/gsoc/derek/phpMyAdmin/libraries/import.lib.php
>
> Property Changed:
> ----------------
> branches/gsoc/derek/phpMyAdmin/
>
>
> Property changes on: branches/gsoc/derek/phpMyAdmin
> ___________________________________________________________________
> Modified: svn:mergeinfo
> - /trunk/phpMyAdmin:12672-12790
> + /trunk/phpMyAdmin:12672-12811
Please do not mix merge commits with regular ones, then it is hard to
find out what is actually your change.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
Hello, everyone,
I have uploaded the final
revision<https://sourceforge.net/tracker/index.php?func=detail&aid=2825187&group_id=…>for
permanent storage feature. I would appreciate if members of the
community can test it, and provide me with their valuable feedback.
This final revision will allow you to update following settings straight
form your browser:
- naviWidth
- maxRows
- foreignKeyMaxLimit
- propertiesIconic
- propertiesNumColumns
- leftFrameLight
- useDbSearch
- maxDbList
- maxTableList
- fullText
- loginCookieValidity
- navBarIconic
I hope my work helps the community, and phpmyadmin's users find it worthy of
their use. Also, I would appreciate if someone from the developers team can
assign him to the patch.
Thanks so much for the cooperation!
--------------------------------------------------
Best regards,
Zeeshan Mughal
Email: zeeshanmughal(a)ieee.org
Web: http://www.zixan.info