GSoC_2011_Projects

This page lists all Google Summer of Code 2011 projects at phpMyAdmin. You can follow the progress on aggregated feed at https://planet.phpmyadmin.net/.

OpenGIS support for phpMyAdmin

OpenGIS data types are supported in MySQL since version 4.1. It’s high time that phpMyAdmin add support for these data types. Support needs to be added in number of areas, data browsing, data insertion, data editing, searching based on relevant criteria, data exporting being few of them. In the proposed GSoC project I present my suggestions, plans and proposed schedule on adding the necessary functionality to phpMyAdmin for it to effectively support OpenGIS data types.

Student: Madhura Jayaratne

Mentor: User:Nijel

Blog: https://madhuracj.blogspot.com/

Git: https://repo.or.cz/w/phpmyadmin/madhuracj.git

Proposal: https://www.google-melange.com/archive/gsoc/2011/orgs/phpmyadmin/projects/madhura_cj.html

Demo: demo.phpmyadmin.net/gsoc-madhura

Zoom-search

This project aims to provide a tool for visualizing data in a relational table as a scatter plot along any two of its columns. For example, each movie in a movies table can be represented in a scatter plot with popularity and release year acting as the X and Y axis. A user can also drill down(zoom) to have a closer look at certain portions of the plot and get any details about the data on demand. It will provide a powerful means to interpret, explore and communicate data/information.

Student: Ammar Yasir

Mentor: User:Lem9

Blog: https://ammaryasirr.blogspot.com/

Git: https://repo.or.cz/w/phpmyadmin/ammaryasirr.git

Proposal: https://www.google-melange.com/archive/gsoc/2011/orgs/phpmyadmin/projects/ammar_yasir.html

Demo: demo.phpmyadmin.net/gsoc-ammar

Browse-mode Improvements ++

This project is intended to improve the convenience of users when using phpMyAdmin, particularly when browsing tables. This can be achieved by adding the following features to phpMyAdmin: • Browse recently used tables • Remember the last way user sorted tables • Flexible table’s column width • Reorder table’s column using mouse during browsing • Show only selected columns • Integration of navigation bar • Edit only selected field • Grid view in the table edit page.

Student: Aris Feryanto

Mentor: User:Lem9

Blog: https://arispma.wordpress.com/

Git: https://repo.or.cz/w/phpmyadmin/arisferyanto.git

Proposal: https://www.google-melange.com/archive/gsoc/2011/orgs/phpmyadmin/projects/arisferyanto.html

Demo: demo.phpmyadmin.net/gsoc-aris

Drizzle support

Implementing support for Drizzle in phpMyAdmin, which will allow users to utilize this tool with new, hopefully successful database management system.

Student: Piotr Przybylski

Mentor: User:Ruleant

Blog: http://crackpl.eu/blog/

Git: https://repo.or.cz/w/phpmyadmin/crack.git

Proposal: https://www.google-melange.com/archive/gsoc/2011/orgs/phpmyadmin/projects/pprzybylski.html

Demo: demo.phpmyadmin.net/gsoc-piotr

AJAXify phpMyAdmin Interface

With this proposal I’m proposing to improve the usability of some identified important features in phpMyAdmin by applying ajax behavior using jquery library. After improving those features, they will be able to provide a quick and consistent flow of operations to the PMA users.

Student: Thilanka Kaushalya

Mentor: User:Lem9

Blog: https://coders-view.blogspot.com/

Git: https://repo.or.cz/w/phpmyadmin/thilanka.git

Proposal: https://www.google-melange.com/archive/gsoc/2011/orgs/phpmyadmin/projects/lgtkaushalya.html

Demo: demo.phpmyadmin.net/gsoc-thilanka

Support for Procedures: Creating a user friendly interface for the manipulation of routines, triggers and events in phpMyAdmin

The goal of this project is make advanced features provided by MySQL easier to use in phpMyAdmin.

Student: Rouslan Placella

Mentor: User:Nijel

Blog: roccivic.blogspot.com

Git: https://repo.or.cz/w/phpmyadmin/roccivic.git

Proposal: https://www.google-melange.com/archive/gsoc/2011/orgs/phpmyadmin/projects/roccivic.html

Demo: demo.phpmyadmin.net/gsoc-rouslan

Query statistics & charts for the status page

The project aims to enhance the status page of PMA by the following features: Live status variables and history keeping, Query statistics & charts: Extraction of useful data from the slow query log to help identify slow or suboptimal queries and restructuring of the page to add more interactivity to it.

Student: Tyron Madlener

Mentor: User:Nijel

Blog: https://tyronx.blogspot.com/

Git: https://repo.or.cz/w/phpmyadmin/tyronm.git

Proposal: https://www.google-melange.com/archive/gsoc/2011/orgs/phpmyadmin/projects/tyron.html

Demo: demo.phpmyadmin.net/gsoc-tyron

phpMyAdmin Automated Testing

phpMyAdmin - the most popular web tool to manage databases. Well as phpMyAdmin is a quite old project and is currently unit testing is not very popular in this project. My goal is to help the project by writing unit tests and setting up continuous integration.

Student: Zarubin Stas

Mentor: User:Helmo

Blog: http://zsv.org.ua/

Git: gitorious.org/phpmyadmin

Proposal: www . google-melange.com/archive/gsoc/2011/orgs/phpmyadmin/projects/zarubin.html

Demo: demo.phpmyadmin.net/gsoc-zarubin

Category:Google Summer of Code 2011