phpMyAdmin Planet phpMyAdmin

As the end of this year’s Google Summer of Code approaches, this issue summarizes the work done during my project.

During my project’s development, I’ve refactored the existing Twig templates, my main strategy, when it was possible, was to reorganize the functions by putting all the logical part at the beginning, and the view’s at bottom, then I created a new template, and merged all of the templates that were being used in that function, this reduced a lot the number of templates. Another thing that was done was the refactor of Twig’s extensions, I’ve removed unnecessary functions, some were logic, others just returned a template and were replaced by an include statement, the extensions were named by following the following pattern Class_function_name, after talking with my mentor, we agreed to rename all of them to just function_name. I've fixed some bug as well.

Pull requests & commits:

• Fix central columns in-line edit bug #14286
• dce39bb: Fix central columns in-line edit bug.
• Remove md5 twig extension #14305
• 927fed7: Remove md5 twig extension.
• Extension removal #14317
• 5d0fd81: Remove Twig php function extensions.
• Fix bug reported on pull request #14305 #14341
• c021125: Fix bug reported on pull request #14305.
• Refactor db central columns templates #14353
• be673f9: Refactor db central columns templates.
• Refactor db designer templates #14372
• 0d26cfb: Finish db designer refactor.
• Refactor database templates #14415
• 9950681: Refactor db search templates.
• 414c197: Change search test.
• c032147: Refactor Database Structure templates.
• 326151a: Fix Qbe casting error.
• Refactor db_tracking templates #14428
• f0eab56: Fix code sniffer ServerDatabasesController error.
• 491ce9a: Refactor db_tracking templates.
• Fix server databases statistics #14429
• 05cff7e: Fix server databases statistics.
• Refactor server templates #14442
• 15ae8d7: Refactor server_databases templates.
• 217a0db: Refactor server_variables templates.
• 28d890f: Refactor server_plugins templates.
• 36ceaee: Refactor server_engines templates.
• 7dc44b2: Fix tests for server_engine.
• Refactor tables’ tamplates #14471
• bcad25a: Refactor table_tracking main tamplates.
• e955052: Adapt table tracking main tests.
• 3b87465: Fix php code sniffer errors.
• Refactor table search templates #14480
• 4e81d3f: Refactor table search templates.
• 108f445: Merge table structure tamplates.
• Refactor table secondary tabs tamplate #14483
• 6b08a7c: Refactor table secondary tabs tamplate.
• Refactor table relation’s templates #14490
• 7ac2224: Fix secondary tabs bug.
• a017a8e: Refactor table relation’s templates.
• 4d31aa5 : Fix phpstan error report mentioned on pr#14483.
• Refactor server privileges templates #14528
• 685ccaf: Move privileges’ template dir to server’s.
• d3dfdbc: Merge template files.
• Refactor extensions #14541
• 8333a99: Rename charsets Twig extensions.
• 04890c3: Rename core Twig’s extension.
• aee045f: Remove index Twig extensions.
• 00aea88: Rename message Twig extensions.
• 76ad22c: Remove partition Twig extensions.
• 9464cbc: Rename plugins Twig extensions.
• 78c1d9e: Rename relations Twig extensions.
• d13a636: Rename ServerPrivileges Twig extension.
• eddbbeb: Rename StorageEngine Twig extensions.
• e7d36c2: Rename table Twig extension.
• 0ba17c6: Rename tracker Twig extension.
• ed8aadd: Rename Transformation Twig extensions.
• b65ede4: Refactor Url Twig extensions.
• 1037b1d: Refactor Util Twig extensions.
• ad3334c: Refactor Sanitize Twig extensions.
• 7aaaafc: Addapt for master merge.
• Remove get_div_for_slider_effect twig extension #14557
• fc9ccff: Remove get_div_for_slider_effect twig extension.

Highlights

The biggest contribution added by this project was to set a development pattern for the Twig templates that are used in phpMyAdmin.

By setting a directory structure pattern, removing unnecessary extensions and refactoring the existing templates, it will be easier to detach the front-end from the back-end, what will be done in the future, since there’s still a lot of html inside the php code.

Through this blog post, I’d like to comprehensively document all of my work done through the Google Summer of Code 2018. This involves links to all the blog posts, repositories, discussions and code merges. A huge token of thanks for all the support extended by mentors Deven Bansod and Maurício Meneghini Fauth and the entire phpMyAdmin community for their suggestions and discussions.

Some Important Links:

1. Github: https://github.com/Piyush3079
2. phpMyAdmin Home: https://www.phpmyadmin.net/
3. phpMyAdmin Github: https://github.com/phpmyadmin/phpmyadmin
4. Proposal Link: Link.
5. Project Link: https://summerofcode.withgoogle.com/projects/#5118590865375232

The changes done in the code were not merged in master branch. Instead a new branch was created and all the pull requests were merged in that branch.

Link to base branch: gsoc-js-refactoring

The following pull requests were created:

1. Mod_Js_Config [ Merged ]
2. Mod_Js_Server_Privileges [ Merged ]
3. Mod_Js_Console [ Meged ]
4. Mod_Js_Server_Status [Merged ]
5. Mod_Js_Navigation [ Merged ]
6. Mod_Js_Import_Export [ Merged ]
7. Mod_Js_Config_Js [ Merged ]
8. Mod_Js_Structuring_1 [ Merged ]
9. Mod_Js_Sql_Js [ Not Merged ]
10. Mod_Js_Sql_Profiling [ Not Merged ]
11. Mod_Js_Db_Structure [ Not Merged ]
12. Mod_Js_Tbl_Stucture [ Not Merged ]

Features Implemented:

1. Webpack as a bundler to bundle the static javascript files.
2. Babel to allow support for module import and export and also to compile ES6 code to ES5.
3. Package.json as the package manager and yarn as dependency installer.
4. Dynamic imports to allow code splitting and lazy loading of JavaScript files as modules.
5. Reduce eslint warning and error in the modular code.
6. Jsdoc to document the javascript code.

Accomplishments and Leftovers:
A large amount of codebase has been revamped till now. Major parts which are remaining are:

1. Some of the pages were giving error so they were not revamped like “Query By Example” page for databases and tables.
2. Database Designer is not revamped yet.
3. Gis Editor is remaining to be revamped.
4. RTE related pages are remaining to be revamped.
5. Error reporting for JavaScript files is not fully functional (Still working on it).

The code is functional now as the php code is edited in such a way to make sure the working of both old code and new code. Once complete code get revamped, then code cleanup for php files can be done to remove functions required for workability of old code.

Blog Posts During the GSoC Period:

• Initial Post: Introduction.
• Week 1: Week1 GSoC 2018 with phpMyAdmin
• Week 2: Week 2 GSoC with phpMyAdmin
• Week 3: Week3 GSoC with phpMyAdmin
• Week 4 & Week 5: GSoC Week 4 and Week 5
• Final Coding week: Final Coding Week of GSoC With phpMyAdmin

Mailing list discussion (phpMyAdmin):

• https://lists.phpmyadmin.net/pipermail/developers/2018-July/020792.html
• https://lists.phpmyadmin.net/pipermail/developers/2018-August/020831.html
• https://lists.phpmyadmin.net/pipermail/developers/2018-May/020756.html

Finally GSoC has come to an end and it’s been a great journey. I got to learn many new things and apart from honing my programming skills, I also learned quite a bit about Colour Theory which was a completely unknown domain for me.

My blog posts during the GSoC period are :

1. https://medium.com/@shucon01/google-summer-of-code-2018-with-phpmyadmin-automated-theme-generator-tool-1284b4872ce2
2. https://medium.com/@shucon01/how-i-am-creating-automated-colour-palettes-using-colour-theory-c72c84c927c0
3. https://medium.com/@shucon01/using-ajax-to-send-front-end-data-to-back-end-c741f006559d
4. https://medium.com/@shucon01/why-text-colour-plays-a-major-role-in-site-visibility-4ac0831dfba2
5. https://medium.com/@shucon01/automating-text-control-for-good-contrast-ratio-56c7e35d4bfc
6. https://medium.com/@shucon01/gsoc-work-report-before-2nd-evaluation-68eb27db42af
7. https://medium.com/@shucon01/wrapping-up-gsoc-18-with-phpmyadmin-77d920325671

All of my code is in a single Pull Request :

https://github.com/phpmyadmin/phpmyadmin/pull/14293

As every good thing comes to an end, the summer vacations have ended and so did the journey of GSoC. GSoC helped me to spend my summers in a productive way.

I have almost completed project with a few remaining fixes and tests. One major problem faced recently was that many people use phpMyAdmin in /var/www/ folder which needs root access thus it doesn’t directly allows theme generator to create files without giving adequate permissions to the theme folder . So for now we have made a notification indicating the users to correct user permissions before proceeding. Another idea was to create downloadable files so that the user could manually add the custom theme to the theme folder. But this was quite a big task in itself, thus it’s been left as a later project.

After GSoC

The code hasn’t been merged yet as it still needs to be reviewed. As per the reviews of the users we could then improve the UI as for now we haven’t thought about UI much.

Integrate storing user preferences in browser local storage

Post 2

Submitted pull request for the final feature feature.

Plans for this week-

1. Review the code for all the features submitted.
2. Work on tests and documentation for all the features.
3. Work on code final submission.

It has been more than two and a half months since working with phpMyAdmin under GSoC 2018. This week is the final coding week of GSoC. This blog post is a brief jouney about what has been done till now and what is remaining.

A substantial amount of code has been revamped and converted into modular code. Although it seems quite clear that the whole JavaScript code-base cannot be modularized before the coding period ends, as there are already some issues related to php which needs to be taken care before the starting of revamping the JavaScript files related to those php files so that the new code can be tested at least once in development.

Progress till now

Almost 70% of the code base has been converted into modular code. During the initial phase of the project, the created pull request became very complex to review ,suggest changes and to test for individual functionality, so the pull request was broken up into several continuous pull requests based on the individual functionality or file change.
But these pull requests were in continuation, so at that time it was not sure that merging these pull requests will break something or not so I proposed to create a new branch in the main repository to merge all these continuous pull request and once the revamped code is tested on this branch, this branch could be merged into master to make sure that nothing is breaking into the master.

After this change in the review technique, several pull requests were merged and many new pull requests were created for merge into the new branch. Some of the pull requests are:
Mod_Js_Config (Merged), Mod_Js_Server_Privileges (Merged), Mod_Js_Console (Merged), Mod_Js_Server_Status (Merged), Mod_Js_Navigation (Merged), Mod_Js_Import_Export (Merged)

The prefix Mod_Js is for differentiating these pull requests from rest of the pull requests. All these pull requests were successfully merged into the gsoc-js-refactoring branch with some functionality break (mentioned in the individual pull request itself).

Plan for this week

The plan for this week is to revamp some of the files related to table into modular code. Apart from that, I am working on some build scripts so that the new code can be used in the production release. The code is being tested in production mode to make sure that nothing is breaking. I will also try to implement jsdoc to create documentation of the JavaScript code.

Plan for next week

The next week is the documentation week for the work that has been done during the Google Summer of Code coding period. So the main focus will be towards documenting everything according to the guidelines mentioned by Google.

If jsdoc is implemented without errors and within the duration of the coding period, I’ll work on implementing better documentation of the functions, classes, and modules which can be hosted on phpMyAdmin developer page.

What’s remaining

The designer part of the phpMyAdmin is yet to be revamped. Apart from that some of the files related to the database like Routines, Triggers, Events, Query By Example are remaining. Some of the files related to the table are also remaining although I am working to revamp them.

Code cleaning, naming and renaming of files correctly are also few of the major tasks remaining.
Old js files has not been deleted yet as the anticipatory changes made in all these old files will be considered after merging this gsoc-js-refactoring pull requests into master.

Weblate 3.1 has been released today. It contains mostly bug fixes, but there are some new feature as well, for example support for Amazon Translate.

Full list of changes:

• Upgrades from older version than 3.0.1 are not supported.
• Allow to override default commit messages from settings.
• Improve webhooks compatibility with self hosted environments.
• Added support for Amazon Translate.
• Compatibility with Django 2.1.
• Django system checks are now used to diagnose problems with installation.
• Removed support for soon shutdown libravatar service.
• New addon to mark unchanged translations as needing edit.
• Add support for jumping to specific location while translating.
• Downloaded translations can now be customized.
• Improved calculation of string similarity in translation memory matches.
• Added support by signing Git commits by GnuPG.

Update:

Weblate 3.1.1 was released as well fixing test suite failure on some setups:

• Fix testsuite failure on some setup.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Integrate storing user preferences in browser local storage

Post 1

This is my favorite feature request because of its importance and the challanges it imposes. The data about add on features is stored in the configuration storage, when it is not configured, the data doesn’t persist over session. In those cases the data should be saved in browser local storage.

1. All this data(stored on client side) will be needed by the server, so we’ll need to pass the data to the server during login.
2. Whenever user makes some changes in the data, after processing it on the server side, it can be passed on to the client using ajax request and updated in browser local storage.

Plans for this week-

Automatically load settings from local storage at login time.

Add Support for CHECK Constraints

Post 2

This feature request is divided in three parts -

1. Implement an interface for interacting with these constraints
2. Update parser to understand this syntax
3. Update the export interface to allow including these in an export

Mysql does not provide any way to alter the definition of a constraint. The main idea is to add support for a constraint and additionally build a feature seperate from mysql to alter a constraint.

I’ve submitted the PR for the first part of the feature. I’m currently working on the sql-parser.(The second part)

Work done -

1. SQL parser now recognizes CHECK statements in alter table commands.

Plans for this week-

1. Make sql parse fully aware of the CHECK statements.
2. Update the export interface to allow including these in an export.

Add Support for CHECK Constraints

Post 1

This feature request is divided in three parts -

1. Implement an interface for interacting with these constraints
2. Update parser to understand this syntax
3. Update the export interface to allow including these in an export

Mysql does not provide any way to alter the definition of a constraint. The main idea is to add support for a constraint and additionally build a feature seperate from mysql to alter a constraint.

I’m currenlty working on the interface to build, edit and drop check constraints.(The first part) Work done -

1. Implemented UI to add a check constraint during table creation.

2. Implemented UI to show defined constraints on a table in table structure.

Plans for this week-

1. Finish the functionality to add/drop/alter constraints(first part).
2. Update parser to understand syntax(second part).

As the second evaluations are starting from 9th July, I would explain all the work I’ve done between first and second evaluation. The first task I did was to create a feature so that the contrast ratio between the text colour and background colour is good enough. Detailed explanation about it is present in the previous post. The next work was to create Preview Panels and integrating them with the theme generator. Initially the plan was to create sample panels for every decided element, but I had to change the plan and decided to create preview panels for only Table and Group element. Every other style is applied on the already present elements (navigation panel, background, headers etc.). The two main reasons for it were

1. To prevent unnecessary clutter.
2. The already present elements were interfering with the sample elements, thus becoming a tedious and unnecessary job.

I’ve also written some documentation and will be writing some tests in a day or two.

I’m finishing the refactor in the directories that are already in the right structure, only the table directory is not ready.

I’ve been working on the databases templates directories, which I’ve finished a couple of weeks ago, and the server templates which I’ve finished last week, during this last one, I spent some reasonable time changing the tests for ServerEnginesController, to make it work with the new structure. There was a problem, at the test for the single engine show page, that the engine used for test is not so common nowadays, and I had replaced a function call for its code in the indexAction function, and where this function tests if the engine ‘Pbxt’ isValid(), which always returned false, because the engine pbxt is not installed. The old test bypassed this conditional by calling directly the getHtml function for pbxt engine. After a lot of failed tests, I’ve realized that the best thing to do for now was to keep the getHtml function.

Now all of my efforts are focused on finishing the tables directory, this is the directory with the biggest number of templates, 45 in total.

Sixth feature submitted

I’ve submitted a PR for the sixth feature. Adds features discussed in #13023

1. Show ajax errors at the bottom of the page, instead of showing them in a popup.
2. Add copy query button for errors in processing sql queries.

Plans for next week-

The next feature(#7) that I’ll be working on is- Add warning for default user/password usage Don’t use the controluser ‘pma’ if it does not yet exist and don’t use ‘pmapass’ as password. consider testing if pma:pmapass is used, and warn about it?

As my sixth week of GSoC with phpMyAdmin has come to an end, I going to explain the problems faced and how I tackled them. The biggest problem I faced was calculating text colours with contrast ratio greater than 4.5 , while keeping in mind the colour scheme used. First I tried to use mix-blend-mode but it didn’t work out because I would have to add a span class for every text, which wasn’t feasible. So I created a new function which takes the background colour and compares with the calculated colour . If the contrast ratio is less than 4.5 it tweaks saturation and brightness till the required contrast ratio is achieved. This colour is achieved with a maximum iteration of 10. Now I have started creating Preview panels and would complete it this week, hopefully.

Working on fifth feature

I’m currently working on the fifth feature- This is one of the most requested features in my features’ list Till now I’ve done the following-

1. Added a configuration directive in config.default.php as $cfg[‘Import’][‘enable_drag_drop_import’]
2. Added a checkbox in the settings page to toggle this config on or off.
3. Disabled the handler at the server side if config is set to disabled.

TODO:

1. Test on multiple servers.
2. Disable drag drop handlers in javascript.

It’s been 5 weeks now working with phpMyAdmin under the Google Summer of Codes 2018 program. I have successfully passed the first evaluation.

During these two weeks and including this week also, my main objective was to modularize the Navigation, Error Report, PMA Console, Import and Export and the configuration file so that the configuration of these pages can be checked and settings can be changed with the modular code.

Right now I am working on inline javascript coming from the php classes containing the the configuration of the particular page which were injected in the container showing the body of html. These configurations need to be imported in the module from window of document and then used in the modular code so that any change in the setting of the page or any saved setting can be compared with new changed or setting user is going to made on the settings page and on PMA Navigation.

Regarding the Feedback from Mentor:

As per the feedback, the mentors had given, I will try to push the quality code on the pull request by the end of this week or by the mid of the coming week after making successful changes and testing of the above mentioned files,which can be reviewed.

Fourth feature submitted

I’ve submitted a PR for the fourth feature. The following new functionalities have been added-

1. Automatically add PRIMARY KEY on column edit page when user tries to set AUTO INCREMENT.
2. Disable popup when user clicks on the A_I checkbox in column insert and new table page and automatically set default index to PRIMARY with defaults.

Plans for next week-

The next feature(#5) that I’ll be working on is- Add a configuration option to disable drag drop files completely This is one of the most requested features among the ones in my proposal.

1. I’ll be adding a setting among other settings where user can disable the checkbox to disable drag/drop file functionality.
2. This setting will directly interact with the configuration file(just like how other configuration settings work). There are some workarounds suggested by the users in the feature request page, I still have to figure out the safest and best among them, or, I’ll be finding out a workaround of my own.

Working on fourth feature

I’m currently working on the fourth feature- Before starting, I was thinking about showing a popup to add index when user tries to add AUTO_INCREMENT to an existing column. But in our conversations, Isaac and I decided to -

1. Automatically add PRIMARY KEY instead of showing a popup to add index.
2. Disable popup when user clicks on the A_I checkbox in column insert and new table page.

Issues I’m currently working on-

1. Fatal javascript error while adding index to a new column, #14402

Weblate 3.0.1 has been released today. It contains several bug fixes, most importantly possible migration issue on users when migrating from 2.20. There was no data corruption, just some of the foreign keys were possibly not properly migrated. Upgrading from 3.0 to 3.0.1 will fix this as well as going directly from 2.20 to 3.0.1.

Full list of changes:

• Fixed possible migration issue from 2.20.
• Localization updates.
• Removed obsolete hook examples.
• Improved caching documentation.
• Fixed displaying of admin documentation.
• Improved handling of long language names.

If you are upgrading from older version, please follow our upgrading instructions, the upgrade is more complex this time.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Third enhancement submitted

I’ve submitted a PR for the third feature - Have set the default width for varchar fields in the insert page to cover the whole width of page. I assigned a class to the “value” th element in the table, and styled it to cover the whole page. Varchar and char textareas were also assigned a class to cover 95% of their parent elements.(width style overrides col attribute) I have set the minimum number of rows to 7. It doesn’t need any relative value, as the height of this table mostly overflows the page.

Among all the enhancements in my list, the third one was the most minor one, all the others require relatively a lot more work and testing.

Plans for next weak.

Mentor evaluation starts 11th June. I will be scrutinizing my work until now to test for bugs and for code optimization whereever possible and will be working on some issues.

This week I updated the code style to fit some of the PSR-2 rules, refactored some files and upgraded to Twig 2, in addition to helping the GSoC students.

Issues:

• #14341 Fix bug reported on pull request #14305
• #14317 Extension removal

The post Weekly phpMyAdmin contributions 2018-W22 appeared first on mauriciofauth.com.

This week I made up for the additional hours I worked on in the previous weeks. I removed the $dbi global variable from several classes, in addition to helping the GSoC students.

Issues:

• #14305 Remove md5 twig extension

The post Weekly phpMyAdmin contributions 2018-W21 appeared first on mauriciofauth.com.

This week I enabled the strict type mode in all PHP files, fixed some bugs and reviewed pull requests, in addition to helping the GSoC students.

Issues:

• #14286 Fix central columns in-line edit bug
• #14231 #13893 issue fix Simulating queries produce unexpected results
• #14272 fixes broken links to icons in the setup page
• #14304 [5.0.0-dev] Strict mode php errors
• #13893 Simulating queries produces unexpected results
• #14119 fix: AUTO_INCREMENT error when only exporting table structure in database-level exports; issue #14066
• #14066 Export MySQL Table (only structure) AUTOINCREMENT error
• #14296 Enable strict mode in PHP files
• #14278 Central columns can’t be edited or deleted by multiple selection after single edit
• #14290 Enable strict mode in some classes

The post Weekly phpMyAdmin contributions 2018-W20 appeared first on mauriciofauth.com.

This week I fixed some bugs, reviewed pull requests, replaced some deprecated jQuery functions and added type declarations to multiple classes, in addition to helping the GSoC students.

Issues:

• #14280 Adapt html functions to Twig templates
• #13999 Incorrect CURRENT_TIMESTAMP DDL generated with MariaDB 10.2
• #14265 Issue #14019 fix: Allow parameter in AllowThirdPartyFraming
• #14019 Allow parameter in ‘AllowThirdPartyFraming’
• #14189 Remember table’s sorting broken in 4.8.0
• #14204 Remember table’s sorting broken in 4.8.0 issue: #14189 fixed
• #14067 IS NULL search operator produces no WHERE SQL with spatial fields
• #14068 SPATIAL fields with no unique index/autoincrement error when clicking
• #14121 View spatial fields as WKT doesn’t work
• #14125 Fix for issues with spatial fields
• #14266 HTML entity incorrectly displayed
• #14275 Revert modifications
• #14267 Require a polyfill instead of the cytpe extension
• #14249 Edit/Replace view: missing Go button
• #14263 Fix for missing go button in view edit, #14249
• #14177 Fixes bug #13968
• #13968 Data truncated error with current_timestamp().000000 and mariaDB 10.2
• #14260 Language does not change in 4.8.0.1
• #14261 #14260 Fixed configuration for DefaultLang and Lang

The post Weekly phpMyAdmin contributions 2018-W19 appeared first on mauriciofauth.com.

This week I fixed some bugs and reviewed multiple pull requests, in addition to helping the GSoC students.

Issues:

• #14202 Binary foreign key enhancement #13894
• #14255 Addapt getTableHeader to twig template
• #14258 Patch for #14257 CodeMirror hints hidden
• #14257 CodeMirror hints hidden in functions/procedures/triggers
• #14216 Fix XML Export fatal error and add Move columns preview SQL
• #14212 [4.8.0] XML Export from single table throws fatal error (PHP 7.2)
• #14155 Feature Request: Move columns preview SQL
• #14211 Duplicate hidden token input field issue solved
• #14166 Changes to make Get auto saved query and show this query here again button functional
• #14254 #14253 Git commit info not showing when the repository is a submodule
• #14209 Duplicate hidden token input fields
• #14253 Git commit info not showing when the repository is a submodule
• #14094 Fix bugs in SQL query restore after session expire
• #14163 Not showing default query on changing table
• #14148 Not showing previous query on clearing Codemirror and then clicking get saved query
• #14144 “Show this query here again” checkbox does not work
• #14118 SQL tab already has a query loaded
• #14093 No auto saved query everytime new sql page is loaded
• #13894 Binary foreign key enhancement
• #14128 [4.8 RC1] Show 2FA Secret next to QR
• #14154 Display the secret for 2FA – #14128
• #14141 Remove inline styles from Relation.php

The post Weekly phpMyAdmin contributions 2018-W18 appeared first on mauriciofauth.com.

This week I added type declarations to some classes, refactored the PhpMyAdmin\Dbi\DbiMysqli class to use the mysqli class and fixed some bugs.

Issues:

• #14244 Fixes some jQuery Migrate warnings
• #12373 Theme selection for future releases
• #14210 Add Metro theme
• #14213 getThemeUniqueValue error in master
• #14232 4.8.0.1: Colums hidden on low resolution display
• #14102 More Dropdown not fully visible
• #14199 UI Issue – date picker hides in scroll frame
• #14029 Horizontal scrollbar not visible
• #14193 Regression – Scrolling down messes up the fixed column names
• #14206 patch fixed for the datepickerui broken #14199
• #14196 Fix for ui regression issues
• #14228 #14049 issue fix Query builder doesn’t work when the selected column …
• #14226 #12772 issue central column attributes don’t get filled in
• #14169 Regression – Action Icons glitch in 4.8.0
• #14194 UI Issue – I have to scroll down, to be able to scroll horizontally
• #14165 Query builder doesn’t work when selected column is * #14049 issue fix
• #14049 Query builder doesn’t work when selected column is *
• #12772 Central columns attributes don’t get filled in
• #14073 Central columns attributes don’t get filled in #12772 issue solved
• #14179 Remove Inline Styles from Ruotines.php
• #14173 Fix for error when running prepared statements, #14162
• #14162 SQL parser error trying to run a prepared statement
• #14137 Tables stop at border
• #14135 Tables in designer don’t stop at border
• #14224 Use array_key_exists instead of in_array + array_keys

The post Weekly phpMyAdmin contributions 2018-W17 appeared first on mauriciofauth.com.

This week I added type declarations to some classes and added the Metro theme in the master branch.

Issues:

• #14175 Theme problem in 4.8 version
• #14208 Fix errors due to undefined variables

The post Weekly phpMyAdmin contributions 2018-W16 appeared first on mauriciofauth.com.

This week the phpMyAdmin began to require PHP 7.1 in the master branch. So I updated the dependencies and removed some PHP 5 code. I also refactored some classes by replacing the static methods with instance methods.

Issues:

• #13896 Bump minimum version to PHP 7.1 for phpMyAdmin 5.0
• #13919 Remove font size feature
• #13925 Remove font size feature
• #14186 Bump minimum version to PHP 7.1

The post Weekly phpMyAdmin contributions 2018-W15 appeared first on mauriciofauth.com.

Completed 3 weeks of Google Summer of Codes with phpMyAdmin. Major task for the week was to revamp the ajax handler so that it will be compatible with the new webpack generated bundle and there should not be any need of appending the files in the head of the document as it is there in the project right now. Webpack will take care of it.

Here is the major change in the AJAX add script function. There are some more changes by I am showing only this major change.

The new function introduced import() is a function which returns a promise resolution of which contains all the exported modules.

This function will take care of the appending of script in the head tag by generating chunks for modules needed by the dynamically imported module.

This function needs some edits to make it workable for all the files rather than the two files in the array.

The snapshots of the generated webpack profile with two different configurations are as below. Both the configuration have same output size both in development and production mode.

1). When vendor files like jQuery, Codemirror are not build in a separate chunk. The size of various chunks are also shown in the next snapshot

2). Second configuration when vendor files are placed in a separate bundle and included in the Header class for loading it each time with index_new.js

The reproducible pr is already made on github.

Major task for this week would be to work on optimising the webpack bundle and working on ajax handler to revamp it further and try to create multiple entry points for separate files and the compare the output with single entry point.

It’s been three weeks since the beginning of my project. It’s been a real challenge.

2nd week

During my second week I removed all of the php functions Twig extensions. Some of this extensions required a lot of effort because they were used on a template deep in the includes tree.

3rd week

Last week I started to deal with the templates. After defining the directory structure of the templates, I began with the directories that are already in this structure, database, server and table. I finished refactoring the db_central_columns.php file, by melding all getHtml function calls into a new function called getHtmlForMain, and all of its templates, which reduced the number of templates from 5 to 2 templates files, reducing a lot the calls to Template::get() at CentralColumns.php.

This week I’ll continue to refactor the templates on database dir.

It’s my third week of GSoC and I’ve been working on automatically creating CSS files for automated theme generator. While creating different background colours some text colours were more visible than others. After some search I came to know it’s being caused by contrast ratio .

Greater ratio means greater visibility a minimum ratio of 4.5:1 is required because it compensates for the loss in contrast sensitivity usually experienced by users with vision loss and ratios greater than 7:1 is great for users with colour blindness or low visibility. So as I am coming to an end for creating Automated colour backgrounds, I’ll focus on keeping texts with high contrast ratio and also work on creating test cases.

Weblate 3.0 has been released today. It contains brand new access control module and 61 fixed isssues.

Full list of changes:

• Rewritten access control.
• Several code cleanups that lead to moved and renamed modules.
• New addon for automatic component discovery.
• The import_project management command has now slightly different parameters.
• Added basic support for Windows RC files.
• New addon to store contributor names in PO file headers.
• The per component hook scripts are removed, use addons instead.
• Add support for collecting contributor agreements.
• Access control changes are now tracked in history.
• New addon to ensure all components in a project have same translations.
• Support for more variables in commit message templates.
• Add support for providing additional textual context.

If you are upgrading from older version, please follow our upgrading instructions, the upgrade is more complex this time.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English phpMyAdmin SUSE Weblate

Completed 2 weeks of Google Summer of Codes with phpMyAdmin. My main task for the first two weeks was to implement webpack and babel configuration and converting some functions which are globally available into modules which can be imported at times of need. I have changed some of the files with modular structure, now I need to work on making this new structure compatible with existing code.

Major task for this week is to convert the AJAX global object into a module with a global scope in the application so that its instance can be used in different modules and files and making some part of new structure compatible.

Apart from that raised solved one issue regarding Edit Variable in Variables page in this pr.

The Docker container for Weblate got several improvements in past days and if you're using it, it might be worth reviewing your setup.

It has been upgraded to Python 3 and Django 2. This should cause no problems as Weblate itself supports both for quite some time, but if you were extending Weblate somehow, you might have to update these extensions to make them compatible.

The default cache backend is now redis. It will be required in future for some features, so you will have to switch at some point anyway. The memcached support is still there in case you want to stick with current setup.

Cron jobs have been integrated into the main container. So you no longer need to trigger them externally. This save quite some pain with offloaded indexing and another features which rely on regular execution.

Another important change is in logging - all logs are now go to the standard output, so you will get them by docker-compose logs and other Docker management commands. This will make debugging easier.

Filed under: Debian English SUSE Weblate

Hosted Weblate provides also free hosting for free software projects. The hosting requests queue has grown too long and waited for more than month, so it's time to process it and include new projects. I hope that gives you have good motivation to spend Christmas break by translating free software.

This time, the newly hosted projects include:

• ASS Danmaku - firefox extension for downloading danmaku
• KeePass DX - KeePass implementation for Android
• Liberapay Everywhere - the official Liberapay browser extension
• Offline QR Code Generator - browser add-on allowing you to quickly generate a QR code
• Guake - drop-down terminal for GNOME
• Planner - Project and Task manager designed for elementary OS
• EasySSH - The SSH connection manager to make your life easier.
• Misskey - A Twitter-like SNS
• Starke Verben - Android Application to learn your strong verbs
• FMIT - Free Music Instrument Tuner
• Crappy Firetitle - A firefox extension allowing customisation of windows' title
• Piano Booster - a MIDI file player that displays the musical notes AND teaches you how to play the piano

If you want to support this effort, please donate to Weblate, especially recurring donations are welcome to make this service alive. You can do that easily on Liberapay or Bountysource.

Filed under: Debian English SUSE Weblate

I’ve completed my second week of GSoC and the main task for this week was to create a form which could send palette data to the back-end to create CSS files which would be used in t he new theme. The main problem was that palette data was in HTML and was being generated dynamically by using javascript.

So I solved this problem by adding hidden input in the form when Submit button is pressed and send that using AJAX. Now my main focus is to assign different colours of colour palette to various elements.

Sorry for posting the blog this much late. Actually I got stuck in some major problems (errors to be more precise due to some changes) in the code-base so didn’t get enough time to make a blog post.

My major goal for the first two weeks was to transform some of the code-base in the ES6 format but as soon as I started to write the code in ES6 I realised that it is necessary to make some configuration files for webpack and babel so that the trans compiled code can be tested for functionality.

So in the first week I just implemented the basic configuration files for babel and webpack and try to find out what can be the possible new directory structure for js files so that the development and compiled production build files can be placed separately and some find out some basic syntax and standards of ES6 that can be implemented in the revamped code.

Apart from that I was working on this issue in changing the theme raised by me only.

Plans for 2nd week: Understanding the flow of adding js files using php code (existing one) and what changes has to be made for new code and transforming some of the files in ES6.

I’m posting this a little bit late, because I’m not used to report my work this way, hopefully I’ll get used to it fast.

This week my main goal was to remove Twig extensions that were extending php functions, there were 10 extensions, and by now I was able to remove 6 of them. I’m doing this to prevent that it’s used on future contributions that port the front-end to Twig templates.

During this work, I found some TypeErrors due to the automatic casting removal, and fixed them.

Week 3

I’m currently working on the second enhancement,

Importing table from a CSV file

When a table is imported from a CSV file, the default table name is Table ## and default names for the columns are COL ##. Default table and column names

Enhancement-

Set the imported table name to the name of the imported file and column names to the titles of each column in the csv file OR ask the user to enter table and column names.

I was planning to add the feature of setting column names of the table imported from a csv file from the title of all the different columns, but this feature is already present. Now, I’ll be working on some other feature(currently discussing with mentor).

I’m also working on some issues in the issue tracker.

1. Query > Submit query : Error 500

I’ve found an issue and I’m trying to work on it side by side.

End of Week 3

I’ve submitted a PR for the second feature - Following new features have been added to the csv import plugin-

1. For a new import, user can now directly enter the table or database name at the time of import.
2. Partial import. User can enter how many rows they want to import.
3. Show table structure edit form when the import is successful(undecided).

I’m also working on some issues in the issue tracker.

1. (Issue in Changing theme)[https://github.com/phpmyadmin/phpmyadmin/issues/14295]
2. (preg_match error when clicking Insert or Search tabs)[https://github.com/phpmyadmin/phpmyadmin/issues/14315]

Plans for next weak.

As stated in my proposal, my end sems have started and I won’t be able to work for the next 10 days. From 1st. I’ll be working on the 3rd enhancement.

​(Increase input field width for varchar(255))[https://github.com/phpmyadmin/phpmyadmin/issues/13627]

Enhancement-

In the insert row page, the dimensions of varchar textareas are small, which could be increased. As suggested in a ​comment​, the user appreciated presence of this feature in the earlier version and thus can be re-considered in the current version for a better user-experience.

Week 2

Since my end sems are approaching fast and I’ve been really busy with college projects, It has been really difficult to give 6-7 hours everyday for GSoC.

I’ve implemented the login modal and submitted a PR for review. Although, I’ve added comments at appropriate places to make the review and understanding easier. I’ll be explaining the code in detail.

I’m also working on some issues in the issue tracker.

1. getRealSize should expect also literals, not only integers This issue seems to be a question which I am discussing in the issue page.

2. Query > Submit query : Error 500

It’s been a week since I’ve been working on my Google Summer of Code project with phpMyAdmin and my work for this week was to create a separate page for the tool and add/remove functions in a preexisting colour picker tool. The existing tool was creating some palettes but they were not using colour theory to create palettes usable that could be used directly on websites. I have been focusing on four types four types of colour palettes, Monochromatic, Complementary, Analogous and Triadic.

The most difficulties were faced in Monochromatic and Analogous, in the monochromatic theme the main thing was how the palette should be managed if the hue value remains same and saturation and brightness changes of the base colour. I solved it by taking a range of saturation and brightness keeping the average of them equal to that of base colour. Also the values of saturation and brightness were in opposite orders for further contrast. In Analogous theme the problem was how further should the hue difference be set from base colour for optimal colours , I was quite satisfied with 45 degrees in the end. So in the end of this week I have completed all the colour palettes, the next step would be to start integrating the colour picker tool with back end.

I’m very happy to announce that I’ve been working with phpMyAdmin this summer under Google Summer of Code program and my project for the same is “Introducing modern JS features and tools” into phpMyAdmin’s code base. The duration of project will be nearly four months (starting April, 23 to August 14).

The project involves introducing package manager for managing modules so that the modules can be updated easily, introducing ES6 into the code base, babel for compiling ES6 to ES5 which the browsers support, webpack for creating minified files which can be served in production mode and eslint for code linting to find out problematic patterns or code that doesn’t adhere to certain style guidelines.

phpMyAdmin’s javascript code is written very well in terms of logic and best practices and very well documented but there are some problems with the current code, many of the variables are globally exposed and the external libraries like jquery are used as a downloaded library. So every time a new release is there, these files need to be replaced with the new files manually.

The global variables can be reduced by using some modern javascript ES6 features like module import and export, block scoped variables and using classes and closures for interdependent files which is not there right now.

The problem of manually updating files can be removed by using a package manager like npm or yarn, which have commands like “npm update” to update the existing modules.

As the javascript code base of phpMyAdmin is very large, it might not be possible to revamp the whole code base in three months, so my major focus will be on bringing the new code with new features in such state that the existing code and the new code can me compiled together and can be used in production.

By the end of GSoC program, I expect to implement the aforementioned tools and features without breaking the build status and consistency of the code base and convert as much of ES5 code to ES6, as possible.

For future(not part of the program): There can be some other features which can be implemented like unit testing of the functions and type check of various variables which will help in reducing and easily identifying errors related to type check.

I’m very happy to announce that I was one of the selected to work with phpMyAdmin during Google Summer of Code this year, which will happen, this winter (here at Brazil), from April 23th to August 6th.

I will be working with the Twig templates currently in use at the project, which can be found here. The idea of using a template engine is to maintain code organization and consistency, by separating your logic code from your markup, or front-end.

phpMyAdmin’s front-end is not fully implemented using Twig, there’s plenty of work to be done here, my work on this project is to Refactor this templates, using more of Twig’s features to enhance code organization. The first thing that will be done is to analyse if all Twig extensions currently in use are really necessary or if it can be replaced by a Twig feature, if changes are made in this part, it will be necessary to change the code in every part that this changes affects, what can be done while refactoring each template.

After the extensions are all good, the next thing to do is to go through the code on functions that return html and apply Twig features on this functions and templates that are used. For example, here, a possible thing to do is to use ‘Blocks’ or ‘Extends’ feature to simplify all of these front-end calls into one.

By the end of the GSoC program I expect to have contributed to a project that seizes the most of Twig’s benefits. And I hope that I’ll be able to expand my open source contributions.

I am very happy to announce that I’ll be working with phpMyAdmin this summer on the project ‘Automated Theme Generator Tool’. Currently there are pre-generated themes that can be manually installed and used. The idea is to create a tool that automates and makes easier the task of creating themes. Themes created from the Theme Generator tool would be less prone to bugs in the long run and could cater to each individuals needs. For the automated themes to look good to the eye, I’ll be using the concepts of Colour Theory.

The major goal of this project is to create a tool, that would create themes giving the users adequate freedom for changes and at the same time, automates the other parameters of the themes itself so that theme looks good i.e. by using colour combinations that are appealing to the eye. Designers use a variety of techniques to create themes and colour combinations that would be good looking. One of the main tools that would be used is a designer’s colour wheel.

Though RGB and Hexadecimal values are important for creating a webpage, they are of little use while studying Colour Theory. The HSB (hue, saturation, and brightness) are more important in working with colors. HSB values can be easily converted from hexadecimal and RGB values.

Primarily we would focus on four types of colour schemes:

• Monochromatic Colour Schemes

Monochromatic schemes use different tones from the same angle on the colour wheel. All colours are derived from the base colour and the hue value is not changed.

• Analogous Colour Schemes

Analogous colour schemes are created by using colours that are next to each other on the colour wheel.

• Complementary Colour Schemes

Complementary schemes are created by combining colours from opposite sides of the colour wheel.

• Triadic Colour Schemes

Triadic schemes are made up of hues equally spaced around colour wheel.

All the colours generated by the colour scheme using the formulas of colour theory, would be displayed on a colour palette so that the user can further tune each colour according to his choice if they want to. The main elements to keep in mind while assigning colours are:

1. Headers
2. Footers
3. Background
4. Tables
5. Groups
6. Notices
7. Results
8. Buttons

Apart from styling the webpage as a whole, the users can use the same color picker tool to customise the font color and a drop down menu to change text font from a set of predefined fonts supported by the browser.

There are many different types of text that would require different colors to distinguish each other. The most important being the following:

• Headings — These would generally match with the base color of the theme.
• Links and Links (on hover) — The two text should be distinguished from each other apart from being different from the normal text.
• Other text — This text would cover up most of the text present on a page.

One thing to keep in mind is that for the maximum visibility of text, the text color should be contrasting to that of the background color, by default. One option is to set complementary colors to that of the colors selected in the theme.

A minor tweak that can be allowed are a set of predefined icons and if time permits, we could start working on adding gradient to the themes. The last thing required would be to save the theme settings so that the same theme opens the every time phpMyAdmin is reopened.

The final tool would look somewhat like this:

Mockup

The four color wheels indicate the different scheme types to choose from, currently the monochromatic color scheme is shown to be selected. A color picker tool is shown which could easily convert HSB, RGB and hexadecimal values into each other. The Elements and Text palette shows the colors that would be used for them respectively. On hovering on a particular color, a popup would show for what elements the particular color would be used (Example: The cursor is on the blue color, and a pop-up displays that it would be used for hyperlinks). The Theme name asks for an input to save the theme with a particular name. The Font Style option shows a drop-down menu to select a font style. A Preview and Go button are at the bottom of the page which displays a preview and saves the theme respectively. At the right side the Sample Preview shows various sample previews of four main components(Main Window, Query and Table List, Navigation Panel, Table Data). These preview panels can be hard coded on this page rather than linking it with the original pages, this would save time and make things easier. At the end of the project we could expect the theme generator tool to be completed and ready to be pushed to master branch, and later to STABLE branch after adequate testing. A summarised list of expected deliverables are:

1. A customised color picker tool.
2. Different color scheme modes.
3. Custom text color and fonts.
4. Theme preview mode.
5. Save the themes settings and creating the necessary files.
6. Choice of predefined icons. (Optional — as advised by the mentor)
7. Color gradient on different elements. (If time permits)
8. Remove inline style scripts. (As required and as per time)

Project Schedule

April 23, 2018 — May 14, 2018

• Bonding with community.
• Discuss and clear the ambiguities and implementation details.

May 14, 2018 — May 21,2018

• Create a new page for Theme Generator Tools.
• Implement Basic Colour Picker Tool and customising it according to our needs (adding necessary functions and removing the unnecessary ones).

May 22,2018 — May 29,2018

• Save theme and create necessary files automatically.
• Opens the same theme when phpMyAdmin restarts.
• Test cases and documentation.

May 30,2018 — June 6,2018

• Add color schemes functions.
• Integrating the color scheme functions with the color picker tool.
• Basic color changing webpage.
• Fix inline styles where necessary.

June 7,2018 — June 14,2018

• Make-up week.
• Fix any bugs and write the required documentation.
• Submit work for phase-1 evaluations.

Mid evaluation: June 11–15, 2018

June 15,2018 — June 22,2018

• Add remaining color schemes functions.
• Integrate text color changes with color picker tool.
• Automate text colors with the selected color scheme.

June 23,2018 — June 30,2018

• Create Sample Preview Panels
• Font changes.
• Write Tests and documentation.

July 1,2018 — July 8,2018

• Make-up week.
• Submit work for phase-2 evaluations.

Mid evaluation: July 9–13, 2018

July 9,2018 — July 16,2018

• Predefined icon picker drop-down menu.
• Integrate Theme Generator with Sample Preview.
• Travis test cases.

July 17,2018 — July 24,2018

• Fine tune CSS features.
• Fix any bugs that might have gone unnoticed.
• Remaining Travis test cases.

July 25,2018 — August 1,2018

• Add gradient tool.
• Fix any colour scheme automation .
• Write Documentation.

August 2,2018 — August 6,2018

• Make up week.
• Wrap up the work.
• Fix any bugs and do required documentation.
• Work on more features if time permits.

Final evaluation: August 6–14, 2018

I’ll be updating my weekly progress of the project on this blog.

GSoC progress in community bonding period.

Worked on some issues in the Issue Tracker

1. There was a bug in the edit view feature, where the form submission button was missing. It was a small task to add the button. Currently, I am working on removing two buttons in create view form as discussed in the issue page.

2. There is a bug in the recent tables list on the navigation panel which doesn’t show the recently visited tables. I’ve submitted a PR which solves this issue.

Started working on the first enhancement

As I’ve stated in my proposal that I won’t be able to give 5-6 hours from 28th May to 8th June. I’ve already started working on the first enhancement. The aim is to append a modal on the page which would ask for login, instead of rendering the whole login page, which would preserve the information which user entered in the previous session.

Progress

I’ve made the modal which is correctly appended on the page when session times out and logs in the user.

Implementation in detail-

There is a function UpdateIdleTime() in functions.js which sends post request just a second before the session runs out. When it finds that the session has expired(according to server response, more on this below), it reloads the page. I’ve changed it so that instead of reloadin the page, it appends the modal returned(more on this below).

When updateIdleTime() sends a request to the server and it detects session timeout, it sends with a success false response and updateIdleTime() reloads the page. Instead of returning a false response, I’ve changed the file “libraries/classes/Auth/AuthenticationCookie.php” to return a modal.

When the user logs in again, a new session is started issuing a new session token, all the hidden form elements with the old session token are replaced with the new token. If a new user logs in, it reloads the page.

Security Concerns

I’m currenty testing for security vulnerabilities and implementing security features to prevent unauthorized access.

1. Page is automatically reloaded if the modal is deleted explicilty.
2. All the page functionalities are disabled while the modal appears.
3. …..

See you next time. :)

Next release on Weblate roadmap is called 3.0 and will bring some important changes. Some of these are already present in the Git repository and deployed on Hosted Weblate, but more of that will follow.

Component discovery

Component discovery is useful feature if you have several translation components in one repository. Previously import_project management command was the only way to help you, however it had to be executed manually on any change. Now you can use Component discovery addon which does quite similar thing, however is triggered on VCS update, so it can be used to follow structure of your project without any manual interaction. This feature is already available in Git and on Hosted Weblate, though you have to ask for initial setup there.

Code cleanups

Over the years (first Weblate release was more than six years ago) the code structure is far from optimal. There are several code cleanups scheduled and some of them are already present in Git repository. This will make Weblate easier to maintain and extend (eg. with third party file format drivers).

User management

Since the beginning Weblate has relied on user management and permissions as provided by Django. This is really not a good fit for language / project matrix permissions which most people need so we've come with Group ACL to extend this. This worked quite well for some use cases, but it turned out to be problematic for others. It is also quite hard to setup properly. For Weblate 3.0 this will be dropped and replaced by access control which fits more use cases. This is still being finalized in our issue tracker, so if you have any comments to this, please share them.

Migration path

Due to above mentioned massive changes, migrations across 3.0 will not be supported. You will always have to upgrade to 3.0 first and then upgrade to further versions. The code cleanups will also lead to some changes in the configuration, so take care when upgrading and follow upgrading instructions.

Filed under: Debian English SUSE Weblate

Selected for GSoC 2018 :).

Why phpmyadmin

I started backend development about a year ago and I’ve been using phpmyadmin ever since. I can’t remember a time in my learning when I didn’t use phpmyadmin to manage my databases. Using phpmyadmin makes the development process so easy and fast because I don’t have to write SQL queries again and again, and can focus on writing code for my app.

I was determined to participate in GSoC this year and wanted to work in php to apply what I had learned and to take my development skills to a higher level. When I saw phpmyadmin as one of the organisations in GSoC, I had instantly decided that I’ll be applying in this org.

Early participation and contributions

I started contributing to phpmyadmin in January this year and I was fascinated to see the well-maintained multi-platform (Web, Desktop, Mobile) support and codebase.

Through my contributions in phpmyadmin I have learnt a lot about open source development and more importantly about good software development techniques. Following are the links to my contributions to the repository.

1. Closed PRs.
2. Open PRs.
3. Issues found

I am excited about contributing to phpmyadmin and hope to meet the expected standards.

Project Abstract

The aim of the project is to implement some of the enhancements suggested in the issue tracker to improve user experience(adding new useful features and making the app easier to use), security and performance.

Project Mentor : Isaac Bennetch

Blog and Checkins

I have still to figure out how often would I post on this blog. I am planning something of a weekly update posts but that’d depend on how the work progresses. I’ll stay in contact with my mentor, reporting the progress, getting feedback about the ideas and the code I’ll write.

Following is the list of enhancements I’ll work on this summer.

1. ​Add modal to login after session expired

The default idle session timeout is 24 minutes, after which the session is destroyed and the user has to login again to use the app. The problem is that the login page is rendered over the current page leading to loss of all the information user was entering. Login page overwrites the current page

Enhancement -

Append a modal on the page which would ask for login, instead of rendering the whole login page, which would preserve information.

2. Importing table from a CSV file

When a table is imported from a CSV file, the default table name is Table ## and default names for the columns are COL ##. Default table and column names

Enhancement-

Set the imported table name to the name of the imported file and column names to the titles of each column in the csv file OR ask the user to enter table and column names.

3. ​Increase input field width for varchar(255)

Enhancement-

In the insert row page, the dimensions of varchar textareas are small, which could be increased. As suggested in a ​comment​, the user appreciated presence of this feature in the earlier version and thus can be re-considered in the current version for a better user-experience.

Default width of varchar textareas in insert page

4. ​Edit an existing row and setting auto increment should prompt to add index

Making an existing int column ‘auto_increment’ shows the error message “#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key”. Error message when trying to add auto increment on existing column

Enhancement-

Show a dialog to add an index to the column.

5. ​Configuration option to disable drag drop files completely

Enhancement-

Add a configuration option to disable drag and drop files support.

6.​ ​Error popup

In the error popup, it is difficult to read the query when it overflows and it’s not possible to copy the query as the popup closes when clicked. Error popup

Enhancement-

1. Disable onclick close by default and add a close button at the top right corner.
2. Wrap the query if it overflows for better readability.
3. Add a ‘Copy Query’ button.

7.​ ​Add warning for default user/password usage

Enhancement-

1. Don’t use the controluser ‘pma’ if it does not yet exist and don’t use ‘pmapass’ as password.

2. Test if pma:pmapass is used, and warn about it.

8. ​Order distinct values table by count

The distinct values table is currently ordered by value.

Enhancement-

Order the distinct values by count in descending order.

9. ​Store user preferences in browser local storage

All user configuration is stored in the user preferences. When the phpMyAdmin storage configuration is not configured, these do not persist over session.

Enhancement-

Use browser local storage for storing user configuration.

10. ​Add support for CHECK constraints (feature request)

MariaDB (MySQL-compatible) added support for CHECK constraints to version 10.2. (stable=10.2.8). It would be very useful if PHPMyAdmin had a UI for adding and managing these in tbl_create.php and tbl_structure.php.

Enhancement-

Implement a UI for adding and managing CHECK constraints in tbl_create.php and tbl_structure.php.

Last week I refactored some classes by replacing the static methods with instance methods.

Issues:

• #14057 Login screen doesn’t appear in android native browser+chrome
• #14076 Enable columns names by default for CSV in issue #14007 solved
• #14007 Enable columns names by default for CSV exports

The post Weekly phpMyAdmin contributions 2018-W14 appeared first on mauriciofauth.com.

Hosted Weblate provides also free hosting for free software projects. The hosting requests queue has grown too long and waited for more than month, so it's time to process it and include new projects. I hope that gives you have good motivation to spend Christmas break by translating free software.

This time, the newly hosted projects include:

• OCCRP Investigative Dashboard - Organized Crime and Corruption Reporting Project
• Tachiyomi - manga reader for Android
• Sozi - a zooming presentation editor and player
• SoundSwitch - application to switch default playing device on Windows
• Project Hamster - a time tracking application
• Fragments - a GTK3 BitTorrent client
• Quack - Qualitative and Usable Aur paCKage helper
• RMS: Personal Data Safe - an article from Richard Stallman

If you want to support this effort, please donate to Weblate, especially recurring donations are welcome to make this service alive. You can do that easily on Liberapay or Bountysource.

Filed under: Debian English SUSE Weblate

Weblate 2.20 has been released today. There are several performance improvements, new features and bug fixes.

Full list of changes:

• Improved speed of cloning subversion repositories.
• Changed repository locking to use third party library.
• Added support for downloading only strings needing action.
• Added support for searching in several languages at once.
• New addon to configure Gettext output wrapping.
• New addon to configure JSON formatting.
• Added support for authentication in API using RFC 6750 compatible Bearer authentication.
• Added support for automatic translation using machine translation services.
• Added support for HTML markup in whiteboard messages.
• Added support for mass changing state of strings.
• Translate-toolkit at least 2.3.0 is now required, older versions are no longer supported.
• Added built in translation memory.
• Added componentlists overview to dashboard and per component list overview pages.
• Added support for DeepL machine translation service.
• Machine translation results are now cached inside Weblate.
• Added support for reordering commited changes.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Last week was very productive. I spent most of my time reviewing all the pull requests. I’ve also fixed a few minor bugs and refactored the static methods of some classes.

Issues:

• #14117 Designer: “Add options” dialog doesn’t reset when canceling: #14110 issue fixed
• #14122 Enhancement: Button to add a central column from existing tables #14043
• #14110 Designer: “Add options” dialog doesn’t reset when canceling
• #14126 Designer: Add option dialogue error handling needs to be modified
• #14139 Error while adding central column from existing tables
• #14142 Fix for adding central column, #14139
• #14043 Enhancement- Button to add a central column from existing tables.
• #14111 Designer: Add options dialog is pre-filled with spaces
• #14114 Designer: Add options dialog is pre-filled with spaces #14111 issue fix
• #14113 Designer: Improperly escaped code in “Add option” dialog #14109 issue fix
• #14109 Designer: Improperly escaped code in “Add option” dialog
• #14115 Fix for “Export tables as seperate files”, #14080
• #14080 “Export tables as separate files” gives empty download
• #14097 JavaScript error in Designer: getElementById() #14079 issue fix
• #14079 JavaScript error in Designer: getElementById()
• #14092 Fixes error 404 on creating views, issue #14082
• #14082 error 404 on creating new view in new PhpMyAdmin releases
• #14012 Fix errors on zoom search errors, issue #13439
• #13439 Table zoom page errors
• #14031 Fixes error in foreign key sql generation + drop foreign key contraint
• #14010 Fix broken Relation View
• #14009 Problem with saving the relation view
• #14037 fix: wrong argument type passed when creating foreign key
• #13941 Argument 5 passed to PhpMyAdmin\Table::_getSQLToCreateForeignKey() must be of the type array, string given
• #14105 Cannot read property sql_query of undefined: #14104 issue fix
• #14104 Cannot read property ‘sql_query’ of undefined
• #14101 sqlform is undefined error when browsing a GIS table

The post Weekly phpMyAdmin contributions 2018-W13 appeared first on mauriciofauth.com.

Last week was mostly spent on reviewing GSoC proposals and on reviewing pull requests. I’m also refactored the PhpMyAdmin\Relation class by replacing the static methods with instance methods.

Issues:

• #14103 jQuery.fn.blur() event shorthand is deprecated
• #14107 Addapt getHtmlForAddColumn to use twig template
• #14071 Database structure page improperly escaped HTML code
• #14098 Fix improperly escaped HTML code in database structure page; issue #14071
• #14011 “Show Report Details” button does not work
• #14116 Addapt getHtmlForTableNavigation to twig template
• #14108 Fixes JavaScript error when editing rows with Internet Explorer
• #14072 Import fails with error code 200
• #14085 Fixes Import Fail
• #14064 Fix buggy sql.lib.php on debian9 with PHP7.2
• #13981 Remove inline styles in ReplicationGui.php
• #14030 Fatal error: Uncaught TypeError: Argument 5 passed to PhpMyAdmin\Table::_getSQLToCreateForeignKey() must be of the type array, string given

The post Weekly phpMyAdmin contributions 2018-W12 appeared first on mauriciofauth.com.

Last week I refactored some classes by replacing the static methods with instance methods and fixed a few minor bugs.

Issues:

• #14075 Fixes for issue 14059
• #14061 Login form not shown with Internet Explorer 11
• #14059 Indexes are not created on Structure tab after update to 4.7.9

The post Weekly phpMyAdmin contributions 2018-W11 appeared first on mauriciofauth.com.

Last week was pretty quiet. The most interesting part was licensing issue with two factor authentication library we use. In the end the library was relicensed to MIT, what makes it compatible with pretty much anything.

I've spent some time on the Debian packages as well, I'm getting closer to make them work again, but there are still some issues to overcome.

Handled issues:

• #14074 Replace google2fa library
• #14046 Restore SQL query after session expire

Filed under: English phpMyAdmin

Last week was a bit quiet, I've spend some time on our infrastructure and doing reviews. There is still big pending task to update Debian packages and I will hopefully get to it this week.

Handled issues:

• #14065 Can not connect to remote server without manual modification in codebase
• #61 Add CAA DNS Record for PMA websites when possible
• #179 Documentation improvements

Filed under: English phpMyAdmin

Last week I've continued on reviewing incoming pull requests and issues without coding much myself. It seems that amount of incoming issues is still quite big.

Handled issues:

• #14005 Supported versions
• #14048 Fixes adding new column in query builder, #14047
• #13940 arg_separator breaks PMA: Call to a member function getCurrentUserAndHost
• #13927 NEED HELP PHPMyAdmin compatibility with PHP 7.1
• #13984 Unable to logout of phpMyAdmin-4.6.6-5 on Ubuntu
• #14003 Issue saving design
• #14047 Add column button in query builder doesn't work
• #14032 Warning in ./libraries/sql.lib.php#601
• #14034 Designer add table
• #14035 Fix Broken Designer Add Table
• #13887 4.7.7: PHP Warning: Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini.

Filed under: English phpMyAdmin

Last week I back-ported a bug fix that was affecting branch 4.7. I removed the references to PMD in favor of Designer and I also refactored some classes by replacing the static methods with instance methods.

Issues:

• #14025 Class ‘ZipArchive’ not found in /srv/pma/libraries/classes/ZipExtension.php:29
• #14000 Add PHP Nightly version to Travis-CI
• #13931 Sort is broken
• #14036 Fix broken sort
• #14042 Rename PMD to Designer

The post Weekly phpMyAdmin contributions 2018-W08 appeared first on mauriciofauth.com.

Last week was mostly spent on reviewing pull requests. There is quite a lot them coming in and I always feel bad when we're not able to review incoming code in timely manner, but unfortunately it happens time to time.

Handled issues:

• #13892 Fix charset error when creating/editing routines; bug #13889
• #14036 Fix broken sort
• #14006 Translated using Weblate (Filipino)
• #13964 Warning: hash_equals(): Expected known_string to be a string, null given
• #14021 fix maintenance operations
• #14022 Max height not set for console
• #14024 Set console max height, issue #14022
• #13889 Create/Edit routine charset bug
• #150 Security release 4.7.8 missing on docker hub

Filed under: English phpMyAdmin