Hi All,
When I was looking at the 'Idea List' for GSoC 2011, I came across two project ideas that interest me. I would like to know more about these ideas, so I would be able to focus on one specific project idea.
The first project idea I'm interested in is 'OpenGIS support' [1]http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support. As a first step I went through the MySQL documentation on 'Spacial Extension' [2]http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html. I would like to know a rough outline of the features that is expected to be implemented under OpenGIS support.
The second project idea that caught my interest is 'phpMyAdmin_OOP' [3]http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP. Undoubtedly, when implemented this would help the life of developers much easy. I would like to know the expected scope of this project. Further I would appreciate if you could direct me to any articles or documentation I should read with regard to this.
[1] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support[2] http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html[3] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP
Hi
Dne Mon, 31 Jan 2011 11:21:24 +0530 Madhura Jayaratne madhura.cj@gmail.com napsal(a):
When I was looking at the 'Idea List' for GSoC 2011, I came across two project ideas that interest me. I would like to know more about these ideas, so I would be able to focus on one specific project idea.
That's only ideas list, it's up to you to come with proposal for GSoC and we then choose only the best proposals.
The first project idea I'm interested in is 'OpenGIS support' [1]http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support. As a first step I went through the MySQL documentation on 'Spacial Extension' [2]http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html. I would like to know a rough outline of the features that is expected to be implemented under OpenGIS support.
At least editing and displaying types nicely. Adding some search interface would be handy as well.
The second project idea that caught my interest is 'phpMyAdmin_OOP' [3]http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP. Undoubtedly, when implemented this would help the life of developers much easy. I would like to know the expected scope of this project. Further I would appreciate if you could direct me to any articles or documentation I should read with regard to this.
The scope should be defined by time you have for GSoC - 12 weeks and you are expected to spend 40 hours a week on it.
On Mon, Jan 31, 2011 at 9:03 PM, Michal Čihař michal@cihar.com wrote:
Hi
Dne Mon, 31 Jan 2011 11:21:24 +0530 Madhura Jayaratne madhura.cj@gmail.com napsal(a):
When I was looking at the 'Idea List' for GSoC 2011, I came across two project ideas that interest me. I would like to know more about these
ideas,
so I would be able to focus on one specific project idea.
That's only ideas list, it's up to you to come with proposal for GSoC and we then choose only the best proposals.
The first project idea I'm interested in is 'OpenGIS support' [1]<http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support . As a first step I went through the MySQL documentation on 'Spacial Extension' [2]<
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html%3E.
I would like to know a rough outline of the features that is expected to
be
implemented under OpenGIS support.
At least editing and displaying types nicely. Adding some search interface would be handy as well.
Hi Michal,
Thanks for the clarifications.
I will research more on data types, functions of OpenGIS to get a thorough understanding on them. Meanwhile I'll come up with a set of features for the GSoC proposal based on the suggestions you made.
Further I will submit patche(s) as proof of concept for one or two small features I wish to implement under GSoC.
P.S: Thanks for coming up as the mentor for this project idea. :)
The second project idea that caught my interest is 'phpMyAdmin_OOP'
[3]http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP. Undoubtedly, when implemented this would help the life of developers much easy. I
would
like to know the expected scope of this project. Further I would
appreciate
if you could direct me to any articles or documentation I should read
with
regard to this.
The scope should be defined by time you have for GSoC - 12 weeks and you are expected to spend 40 hours a week on it.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
On Mon, Jan 31, 2011 at 10:37 PM, Madhura Jayaratne madhura.cj@gmail.com wrote:
On Mon, Jan 31, 2011 at 9:03 PM, Michal Čihař michal@cihar.com wrote:
Hi
Dne Mon, 31 Jan 2011 11:21:24 +0530 Madhura Jayaratne madhura.cj@gmail.com napsal(a):
When I was looking at the 'Idea List' for GSoC 2011, I came across two project ideas that interest me. I would like to know more about these ideas, so I would be able to focus on one specific project idea.
That's only ideas list, it's up to you to come with proposal for GSoC and we then choose only the best proposals.
The first project idea I'm interested in is 'OpenGIS support' [1]http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support. As a first step I went through the MySQL documentation on 'Spacial Extension' [2]http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html. I would like to know a rough outline of the features that is expected to be implemented under OpenGIS support.
At least editing and displaying types nicely. Adding some search interface would be handy as well.
Hi Michal, Thanks for the clarifications. I will research more on data types, functions of OpenGIS to get a thorough understanding on them. Meanwhile I'll come up with a set of features for the GSoC proposal based on the suggestions you made. Further I will submit patche(s) as proof of concept for one or two small features I wish to implement under GSoC. P.S: Thanks for coming up as the mentor for this project idea. :)
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi Michal,
I have added patch file as proof of concept for the visualizing GIS data. You can find it here at [1].
This patch makes it able to visualize GIS data. This was done using the flot library. Please note that flot was chosen simply because this is just a proof of concept and I was playing around with it for some other task. I'm open to consider the pros and cons of other options and chose the most suitable library for the final implementation
Features: 1. 'Visualize GIS data' link is displayed in 'Query results options' pane ONLY for query results that has atleast one geometric column. 2. Visualization can be zoomed in, zoomed out and panned (thanx to flot) 3. If there are more than one geometric columns in the results, the user can chose which column to be used for th visualization 4. User can chose out of non-geometric columns a label column, which can be used for either tooltips or legend (to be implemeted) 5. User can resize the visualization.
Known limitations: 1. Here I have implemented this only for multipolygons. 2. I'm yet to handle the case where there is void area inside a polygon 3. function 'PMA_GIS_modify_query()' should be made more robust.
Enhancements: 1. Can be extended to other geometric types. Extending to other types is a simple task. Would love to do so if you are happy with the patch. 2. As mentioned earlier tooltips or legend using label column would be nice.
-- Thanks and Regards, Madhura Jayaratne
[1] https://sourceforge.net/tracker/?func=detail&aid=3248445&group_id=23...
Madhura Jayaratne a écrit :
Hi All,
When I was looking at the 'Idea List' for GSoC 2011, I came across two project ideas that interest me. I would like to know more about these ideas, so I would be able to focus on one specific project idea.
The first project idea I'm interested in is 'OpenGIS support' [1] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support. As a first step I went through the MySQL documentation on 'Spacial Extension' [2] http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html. I would like to know a rough outline of the features that is expected to be implemented under OpenGIS support.
Maybe you noticed that nobody offered to mentor this one so its fate if more uncertain. In general, I think it's up to you to propose the features that would make sense in a GUI like phpMyAdmin.
The second project idea that caught my interest is 'phpMyAdmin_OOP' [3] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP. Undoubtedly, when implemented this would help the life of developers much easy. I would like to know the expected scope of this project. Further I would appreciate if you could direct me to any articles or documentation I should read with regard to this.
The expected scope is not to rewrite all of phpMyAdmin in OOP. You'll have to pick some part of the source code that needs refactoring then OOPing; a part big enough to make sense in a 12 weeks x 40 hours project. Sorry but the exact scope of this has to be determined by the student and we'll evaluate if this makes sense.
I found that this book has interesting views about this process: http://www.manning.com/reiersol/
Hi
Dne Mon, 31 Jan 2011 10:36:22 -0500 Marc Delisle marc@infomarc.info napsal(a):
Madhura Jayaratne a écrit :
Hi All,
When I was looking at the 'Idea List' for GSoC 2011, I came across two project ideas that interest me. I would like to know more about these ideas, so I would be able to focus on one specific project idea.
The first project idea I'm interested in is 'OpenGIS support' [1] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support. As a first step I went through the MySQL documentation on 'Spacial Extension' [2] http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html. I would like to know a rough outline of the features that is expected to be implemented under OpenGIS support.
Maybe you noticed that nobody offered to mentor this one so its fate if more uncertain.
For the record: I've just added myself there :-).
On Mon, Jan 31, 2011 at 9:06 PM, Marc Delisle marc@infomarc.info wrote:
Madhura Jayaratne a écrit :
Hi All,
When I was looking at the 'Idea List' for GSoC 2011, I came across two project ideas that interest me. I would like to know more about these ideas, so I would be able to focus on one specific project idea.
The first project idea I'm interested in is 'OpenGIS support' [1] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support. As a first step I went through the MySQL documentation on 'Spacial Extension' [2] http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html. I would like to know a rough outline of the features that is expected to be implemented under OpenGIS support.
Maybe you noticed that nobody offered to mentor this one so its fate if more uncertain. In general, I think it's up to you to propose the features that would make sense in a GUI like phpMyAdmin.
The second project idea that caught my interest is 'phpMyAdmin_OOP' [3] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP.
Undoubtedly,
when implemented this would help the life of developers much easy. I would like to know the expected scope of this project. Further I would appreciate if you could direct me to any articles or documentation I should read with regard to this.
The expected scope is not to rewrite all of phpMyAdmin in OOP. You'll have to pick some part of the source code that needs refactoring then OOPing; a part big enough to make sense in a 12 weeks x 40 hours project. Sorry but the exact scope of this has to be determined by the student and we'll evaluate if this makes sense.
I found that this book has interesting views about this process: http://www.manning.com/reiersol/
Hi Marc,
I will analyse the code base to identify the areas that can be OOPed and where the design patterns can be applied. Additionally I will have a look at the code segments that have already been OOPed to get a better understanding. Hopefully I will be able to chose the scope such that it is neither too big nor too small.
Thanks for the clarifications and the useful link.
-
Madhura Jayaratne -
Marc Delisle -
Michal Čihař