GSoC_2009_IdeasList

List of ideas for Google Summer of Code 2009. This list is not definite, generally any big enough thing from feature tracker can be accepted. Our development efforts aim towards the release of phpMyAdmin 3.2.

Clever spreadsheet import

Implement support for importing data from OpenDocument spreadsheet. Ideally the import would take whole spreadsheet and would be able to automatically create tables for each sheet. This would probably also need some improvements to import system and should be made generic enough to be reusable also for importing CSV files.

There is already some code for CSV in patch tracker.

Mentor: User:Nijel

Export relations scheme other formats

We currently have support for creating PDF from relations scheme. This could be extended to create for example SVG, EPS or dia files, which are much more suitable for inclusion in documents.

Feature requests: :rfe:806035, :rfe:686260.

Mentor: User:Nijel

Support Replication (Master and Slave)

Setup and handle master and slave servers

Feature requests: :rfe:1315734.

Mentor: User:Nijel

Comparing/Syncing/Merging of Server/Databases/Tables

an often requested feature to adapt changes from dev to live servers

Mentor: User:Lem9

User Preferences

Some configuration parameters do not have an impact on security or performance; it would be interesting if each end-user of a shared PMA installation could change them on-the-fly and store these in pmadb.

Mentor: User:Lem9

Charts in server status page

"This feature would add graphs for the 'Runtime Information' tab. It could possibly show the MySQL traffic in a line or bar graph. Another bar graph would show what the top queries are for that hour, day, month, or year. Preferences for those options would be stored in the pmadb database. All graphs would be drawn using GD2 and use information from the MySQL server."

Changes tracking

It would be useful for various purposes to allow tracking of changes made for user. Typical use cases:

• Developer changes testing database and then wants to push changes later also on production environment.
• Administrator wants to be notified about all changes in database.

Feature requests: :rfe:910668.

Mentor: User:Nijel

OpenGIS support

Add support for the new OpenGIS datatypes in MySQL >= 4.1.

Feature requests: :rfe:936533.

Category:Google Summer of Code 2009