Michal Čihař - Blog Archives for English

Weekly phpMyAdmin contributions 2017-W07

Last week was mostly spent on bugfixing what can be easily seen from list of handled issues, which got quite large this week.

There is probably nothing extraordinary in the list, just dozens of issues which appeared in the 4.7.0 beta. The final 4.7.0 should be out in a month, so it's really time to polish it. Also it's time to work on translations, so that's something where you help is welcome.

Handled issues:

What's coming in Weblate 2.12

Weblate should be released by end of February, so it's now pretty much clear what will be there. So let's look at some of the upcoming features.

There were many improvements in search related features. They got performance improvements (this is especially noticeable on site wide search). Additionally you can search for strings within translation project. On related topic, search and replace is now available for component or project wide operations, what can help you in case of massive renaming in your translations.

We have worked on improving machine translations as well, this time we've added support for Yandex. In case you know some machine translation service which we do not yet support, please submit that to our issue tracker.

Biggest improvement so far comes for visual context feature - it allows you to upload screenshots which are later shown to translators to give them better idea where and in which context the translation is used. So far you had to manually upload screenshot for every source string, what was far from being easy to use. With Weblate 2.12 (and this is already available on Hosted Weblate right now) the screenshots management got way better.

There is now separate interface to manage screenshots (see screenshots for Weblate as an example), you can assign every screenshot to multiple source strings, however you can also let Weblate automatically recognize texts on the screenshots using OCR and suggest strings to assign. This can save you quite a lot of effort, especially with screenshots with lot of strings. This feature is still in early phase, so the suggestions are not always 100% matching, but we're working to improve it further.

There will be some more features as well, you can look at our 2.12 milestone at GitHub to follow the process.

Weekly phpMyAdmin contributions 2017-W06

Last week brought release of SQL parser with optional dependency on motranslator what made it lightweight to use for third party tools which are not interested in localization. Besides that the SQL parser code got several other improvements as well.

Another important update came to our Docker image which was finally updated to 4.6.6 (sorry, I forgot to do that on release time)

Handled issues:

Weekly phpMyAdmin contributions 2017-W05

Last week was a bit shorter for me due to travel to FOSDEM where I have helped Software Freedom Conservancy on a stand. More than thousand of our users have brought phpMyAdmin sticker from there :-).

There was also some progress on the code of course. Mostly it's about reviewing bug reports for first beta we've released for 4.7.0. We know there are some things broken and we are working hard to fix these.

There was also quite important change on our SQL parser - the localization is now optional, so you don't have to install motranslator as dependency (this is only in Git right now, will be released this week).

Handled issues:

Weblate 2.11

Exactly on the schedule, Weblate 2.11 is out today. This release brings extended stats available to users and various other improvements and bug fixes.

Full list of changes:

  • Include language detailed information on language page.
  • Mercurial backend improvements.
  • Added option to specify translation component priority.
  • More consistent usage of Group ACL even with less used permissions.
  • Added WL_BRANCH variable to hook scripts.
  • Improved developer documentation.
  • Better compatibility with various Git versions in Git exporter addon.
  • Included per project and component stats.
  • Added language code mapping for better support of Microsoft Translate API.
  • Moved fulltext cleanup to background job to make translation removal faster.
  • Fixed displaying of plural source for languages with single plural form.
  • Improved error handling in import_project.
  • Various performance improvements.

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. You can login there with demo account using demo password or register your own user. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Aptoide, 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.

Weekly phpMyAdmin contributions 2017-W04

Last week I focused on our libraries and all they got new major release in last week in order to move into PhpMyAdmin namespace and to follow PSR-4. We've also released first beta for 4.7.0 and looking forward to feedback based on it.

The new phpMyAdmin release also comes with new downloads structure in order to have smaller downloads for most people while provide also one with complete sources as usually needed by Linux distributions. Hopefully this new structure will better fit needs of both groups.

Another thing worth mentioning is that I've received first batch of phpMyAdmin stickers to hand out at FOSDEM, so in case you happen to be in Brussels next weekend, stop at Software Freedom Conservancy stand and grab one of them.

Handled issues:

See you at FOSDEM

This has become sort of tradition for me, but still worth mentioning - I'm going to to FOSDEM this weekend.

This time I have no talk (I somehow failed to submit anything in time), but still I'm there to meet people and listen to some talks. As I've agreed to help Software Freedom Conservancy on stand (in the H building), it's quite likely that you will find me there. You will also have unique chance to grab phpMyAdmin stickers at this stand.

Also if you spot somebody wearing Weblate t-shirt, then it's most likely me ;-).

stardicter 0.11

Stardicter 0.11, the set of scripts to convert some freely available dictionaries to StarDict format, has been released today. There are mostly minor changes and it's time to push them out in official release. The most important being fixed sorting of ascii dictionaries, what did break searching in some programs.

Full list of changes:

  • Improved deaccent filter.
  • Fixed sorting of ASCII dictionaries.

As usual, you can install from pip, download source or download generated dictionaries from my website.

Weekly phpMyAdmin contributions 2017-W03

After week of vacation, I got back to work. The week was quite busy with quite a lot of handled issues on the table. The bigger focus was on phpMyAdmin itself, but there were some minor improvements to the SQL Parser as well.

I've again focused on the OS X problems with lower_case_table_names settings in the MySQL server and yet another issue was fixed there. While working with that, I've added OS X tests to be executed on Travis CI. This has caught at least one bug which was present in phpMyAdmin on OS X since ages.

Another change important to some users, is that limited phpinfo is returning to phpMyAdmin. In past we've removed it completely as response to PMASA-2016-59, but it brought us quite some negative feedback, so this page is now back without it's dangerous parts. Still this is something you're not recommended to enable on production environment.

Handled issues:

New versions of phpMyAdmin libraries

Today, new major version of all phpMyAdmin support libraries have been released. The major reason behind this is that they all now follow PSR-4 and they are located under the PhpMyAdmin namespace.

Hopefully this will make it easier to integrate within other tools and this really should be last big API change for these libraries. They will be also used by upcoming phpMyAdmin 4.7.0, so that gives us another big commitment for API stability.

Anyway if you want to move ahead, update your dependencies in composer.json accordingly:

On the other changes, the SQL parser also gained ability to produce localized error messages (thanks to using motranslator internally).