Development Google Summer Of Code Open Source Summary  -  Google Summer of Code’ 17 with phpmyadmin

Summary  -  Google Summer of Code’ 17 with phpmyadmin

By Unknown -

Here is the list of issues on which I have worked this summer.

#1: Implement responsive/mobile interface

https://github.com/phpmyadmin/phpmyadmin/issues/13023

As the number of mobile users are increasing day by day so responsive design should be implemented into phpMyAdmin.

  • Proposed Design
  • Added Viewport
  • Used CSS Media Queries
  • 30+ Pages
  • Fixed Tests Cases

Pull Request: https://github.com/phpmyadmin/phpmyadmin/pull/13422

Status: Merged

#2: Nice view for JSON data

https://github.com/phpmyadmin/phpmyadmin/issues/12944

It will add the feature to have an easy view of the JSON data of a column of a table. Right now it shows in only one line, without any kind of format, so we can have an option to show when you are viewing a table with JSON data or when editing a nice JSON view.

Pull Request: https://github.com/phpmyadmin/phpmyadmin/pull/13317

Status: Merged

#3: Remove inline javascript

https://github.com/phpmyadmin/phpmyadmin/issues/12261

There are several places which uses inline javascript (like onclick, onsubmit and onchange). These should be removed and placed into javascript files. After removal we can get rid of ‘unsafe-inline’ for scripting in CSP.

  • Removed onmouseover
  • Removed onmouseout
  • Removed onmousedown
  • Removed onsubmit
  • Removed onchange
  • Removed onclick

Pull Requests

Status: Merged

#4: Disable charset conversion during import when SET NAMES is present

https://github.com/phpmyadmin/phpmyadmin/issues/9419

If the import file is not in supported formats and it’s not ‘utf-8’ then it runs the SET NAMES for the selected charset during the import option. So I will disable the second time encoding if the selected charset is same as that of the charset mentioned in the SET NAMES.

Pull Request: https://github.com/phpmyadmin/phpmyadmin/pull/13457

Status: Review

#5: Import/Export Progress bar

https://github.com/phpmyadmin/phpmyadmin/issues/6311

https://github.com/phpmyadmin/phpmyadmin/issues/12401

It would be really nice to have a progress bar showing import and export progress in real time in terms of percentage and having some more detailed information like which step/table it is processing.

For Export (export.php will be used)

Export Status in Percentage (including how many tables and rows have been already processed and which is in progress right now)

For Import (import.php will be used)

Upload a file and Unzip it. Import into a database (including how many tables and rows have been already processed and which is in progress right now)

Pull Request: https://github.com/phpmyadmin/phpmyadmin/pull/13502

Status: Review

#6: Password “No” shown for user not in user table

https://github.com/phpmyadmin/phpmyadmin/issues/12718

When a user has access to a db (or table), but is not in the user table he’s shown as not having a password. Even after successfully running the query delete from mysql.user where user = ‘test’ I was still able to login with the test account.

I will show the message “NO” without red mark and with showing an information icon with a tooltip saying that the user exists in some tables but not the user table.

Pull Request: https://github.com/phpmyadmin/phpmyadmin/pull/13305

Status: Merged

#7: Fallback to default table names

https://github.com/phpmyadmin/phpmyadmin/issues/12887

The PMA should fallback to default table names if controluser + pmadb options are set while other like ‘relation’, ‘column_info’ are NOT in config.inc.php.

So if the above conditions are matched I will make all features that are listed as Enabled instead of Disabled.

Pull Request: https://github.com/phpmyadmin/phpmyadmin/pull/13524

Status: Merged

Weekly Blog Posts

I have also posted the weekly update for my project. Following are the links of every week that includes the details and links to pull requests.

Week 1

https://medium.com/@manishbisht/week-1-google-summer-of-code-17-with-phpmyadmin-dfa88d8bfb4a

Week 2

https://medium.com/@manishbisht/week-2-google-summer-of-code-17-with-phpmyadmin-415fb3d64483

Week 3

https://medium.com/@manishbisht/week-3-google-summer-of-code-17-with-phpmyadmin-906017806ac2

Week 4

https://medium.com/@manishbisht/week-4-google-summer-of-code-17-with-phpmyadmin-265521adaf57

Week 5

https://medium.com/@manishbisht/week-5-google-summer-of-code-17-with-phpmyadmin-e988b69d6a80

Week 6

https://medium.com/@manishbisht/week-6-google-summer-of-code-17-with-phpmyadmin-7a2621f1456a

Week 7

https://medium.com/@manishbisht/week-7-google-summer-of-code-17-with-phpmyadmin-74f202a73499

Week 8

https://medium.com/@manishbisht/week-8-google-summer-of-code-17-with-phpmyadmin-f186d502522f

Week 9

https://medium.com/@manishbisht/week-9-google-summer-of-code-17-with-phpmyadmin-90f3699459e8

Week 10

https://medium.com/@manishbisht/week-10-google-summer-of-code-17-with-phpmyadmin-6bf6fb791b49

Week 11

https://medium.com/@manishbisht/week-11-google-summer-of-code-17-with-phpmyadmin-72b4a18597a2

Week 12

https://medium.com/@manishbisht/week-12-google-summer-of-code-17-with-phpmyadmin-2f0a77f48c93

Project Presentation Link

I have also presented this project in my college also. So here it the link of the presentation https://docs.google.com/presentation/d/1-rnFgE1AIx82hgj41DfbVqflmWyyo0MOFw9L2ylF5kE/

Result

I have learned a lot of new things. This organisation have the best community I have seen it till now. I will keep on contributing to this organisation to make phpmyadmin better.

Thanks phpyadmin for the awesome summer and special thanks to my project mentor Isaac Bennetch :)

This was originally posted on my medium account.
Tags: , ,
Unknown

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)