June 2009 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] releasing 3.2.0
by Marc Delisle 15 Jun '09

15 Jun '09

Hi, well, 3.2.0-rc1 behaves correctly so I plan to release the final in a few minutes, unless someone objects... -- Marc Delisle http://infomarc.info

1 0

[Phpmyadmin-devel] Using gettext?
by Michal Čihař 11 Jun '09

11 Jun '09

Hello all while looking at possibilities for web based translation tool, I (again) started to think about switching to gettext based system from current string based. The good thing is that the migration should not be hard (I already migrated one small PHP project to gettext). Pros: - standard format, what means that translators can use translation editors or other tools - support for fuzzy translations - when we have to change English text, translators will know this and translation can be also fixed - support for plural forms - texts are directly in place where they are used - not used strings will be automatically dropped Cons: - gettext extension in PHP is bad, we would have to use implementation in PHP (we can use http://savannah.nongnu.org/projects/php-gettext/) - more complicated releases/SVN deployment - you have to compile po files to binary form What do you think? In case we decide to switch I volunteer to do the migration. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

2 10

[Phpmyadmin-devel] Fwd: Erstellung eines phpMyAdmin-Themes mit eigenem Logo möglich?
by Sebastian Mendel 10 Jun '09

10 Jun '09

Hi all, today i received this message (below) from Hosteurope.de and forwarding it to the team (especially Marc) to decide how to reply: Hosteurope (ISP for webspace, virtual server and housing) is asking for permission to use phpMyAdmin with her own theme without PMA logo - for better integration with their other user interfaces (they already use phpMyAdmin for their customers, but with default theme) -------- Original Message -------- Subject: Erstellung eines phpMyAdmin-Themes mit eigenem Logo möglich? Date: Wed, 10 Jun 2009 14:42:40 +0200 From: Thomas von Mengden <tvm(a)hosteurope.de> To: cybot_tm(a)users.sourceforge.net CC: Christoph Selbach <cs(a)hosteurope.de> Sehr geehrter Herr Mendel, hinsichtlich unseres Markenrelaunches beabsichtigen wir, die eingesetzte phpMyAdmin-Oberfläche mit einem eigenen Theme den aktuell verwendeten Web-Oberflächen anderer Plattformen für unsere Kunden anzubieten, um ein einheitliches Erscheinungsbild einzuhalten, sofern dies möglich ist. Hierfür würden wir gerne das phpMyAdmin-Logo in der oberen linken Ecke des phpMyAdmin durch unser eigenes ersetzen, um das einheitliche Erscheingungsbild zu unterstreichen. In der beigefügten Lizenz ist dies nicht explizit verboten, weiterhin finden sich auf der offiziellen phpMyAdmin-Website im Internet auch einige Themes ohne offizielles Logo. Würden wir die Zustimmung seitens des Entwickler-Teams von phpMyAdmin bekommen, ein eigenes Logo zu implementieren? Mit freundlichen Grüßen Thomas von Mengden

5 8

[Phpmyadmin-devel] SQL driver class?
by Marc Delisle 08 Jun '09

08 Jun '09

Zeeshan blogged: http://zixan.info/2009/06/04/gsoc-week-two-progress/ Hi Zeeshan, please give more details about this. In phpMyAdmin we already have middleware for SQL access: the PMA_DBI_xxx() functions. Look for example in tbl_replace.php, we are using PMA_DBI_select_db(), PMA_DBI_query(), etc. If you are writing a library to duplicate the work of these functions, I consider it a loss of time. The PMA_DBI_xxx() functions support the mysql and mysqli extensions already. You can consult libraries/relation.lib.php for some functions that are already reading and writing in some tables of the pmadb. Regards, Marc

4 6

[Phpmyadmin-devel] about choosing table layout for pmadb
by Marc Delisle 08 Jun '09

08 Jun '09

Hi, Zeeshan is proposing a new table to store user preferences: http://zixan.info/2009/06/04/gsoc-week-two-progress/#comments Michal answers in the blog that this does not scale. When looking at Zeeshan's proposal, I had the same idea for a moment. However, after some researches, I am tempted to reject Michal's proposal. Michal's proposed solution (a table with key values) is also called the EAV (entity-attribute-value) model. http://en.wikipedia.org/wiki/Entity-attribute-value_model#Downsides This is advocated as a design flaw by some experts, see the comments here: http://www.devshed.com/showblog/22280/Database-Design-Using-KeyValue-Tables/ http://decipherinfosys.wordpress.com/2007/01/29/name-value-pair-design/ Marc

4 11

Re: [Phpmyadmin-devel] translatewiki.net
by Siebrand Mazeland 08 Jun '09

08 Jun '09

Hi Michal, e.a. I have no idea how you expected this message to reach me, but as some kind of miracle I stubled into a forum that has a copy of the message. At translatewiki.net[2] we use the MediaWiki extension Translate[3] to facilitate the translation process. We import from and export to native product files. For this we have file format support components[4]. As far as I could assess, we have no problem supporting phpMyAdmin's current source format, although I have no tested yet. Output files for languages other than English will be clean (stripped of all comments). Links to some examples of supported file formats and results below my signature. We are currently seeking to connect with succesful FOSS developer communities which will allow us to grow our user base, and allow newly supported products to get more localisations actively maintained. We commit early and often. Quantity and quality of the localisations will rise as time progresses - users can contribute a spell fix, one translation, or continuously maintain a localisation. We Assume Good Faith: anyone can edit after requesting translator access until it is clear he cannot, in which case we have tried to mentor, teach, correct, etc. As more users work on a product in a language, the quality of the translations improves, because of review, but also because people that are using a product in their own language suggest improvements. We encourage partnering developer communities to encourage their current translators (that often submit patches that have to be applied, etc), to start working at translatewiki.net. More information on what we do and how from a translator perspective and from a supported product developer community perspective is available. Please feel free to come look around and ask questions on-wiki. >From our perspective it is important to get an idea if phpMyAdmin and translatewiki.net working together is something that has a chance. If so, I would like to go into more detail with one or a few of you, so we can work out the details and seek wide consensus again. Cheers! Siebrand * MediaWiki messages: http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/languages/messages/Me ssagesAf.php?revision=51034&view=markup * MediaWiki extension messages: http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/ABC/ABC.i18n.php? revision=50830&view=markup * FreeCol: http://freecol.svn.sourceforge.net/viewvc/freecol/freecol/trunk/src/net/sf/f reecol/client/gui/i18n/FreeColMessages_cs_CZ.properties?revision=5420&view=m arkup * NOCC: http://nocc.svn.sourceforge.net/viewvc/nocc/trunk/webmail/lang/eu.php?revisi on=1865&view=markup * MantisBT: http://git.mantisbt.org/?p=mantisbt.git;a=blob;f=lang/strings_catalan.txt;h= 0d94e1427d0d87e2394998dcc63c7af8d97a563d;hb=be8ef7233d5538bef920bb2d9164a8a6 2b78c6cd From: Michal Čihař <michal@ci...> - 2009-05-25 10:05 Attachments: signature.asc Hi you wrote me on wiki [1] about using translatewiki.net for phpMyAdmin translations. We currently have PHP file for each translation and translators handling them. How complicated would be to include phpMyAdmin in traslatewiki.net and how do you merge translations back? [1] http://wiki.phpmyadmin.net/pma/User_talk:Nijel [2] http://translatewiki.net [3] http://www.mediawiki.org/wiki/Extension:Translate (may be a little outdated) [4] http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/Translate/ffs/

2 3

[Phpmyadmin-devel] fckeditor support for TEXT fields
by Marc Delisle 08 Jun '09

08 Jun '09

Hi, any objection about integrating fckeditor[0] to TEXT field in insert/edit modes? [0] See http://www.fckeditor.net/demo Marc

4 12

[Phpmyadmin-devel] Web based translation
by Michal Čihař 08 Jun '09

08 Jun '09

Hi all This topic has been already open several times, but now we got offer to use translatewiki.net for translating phpMyAdmin. As you are the ones who do most of work on our translations, I ask about your opinion on this topic. Are you interested in having web based interface for translating? Currently we use simple PHP files with strings to localize [*] and this probably won't change in near future and translatewiki.net seems to already support similar ways of localizing PHP applications. Now the question is whether to invest effort into this direction. Web based interface definitely lowers barrier for translating, but nobody is really responsible there and you may end up with poor quality. What is better, no translation, or not perfect translation? [*] I'd really prefer to migrate to gettext based solution for phpMyAdmin, but this seems unlikely, mostly because gettext as integrated in PHP is quite painful. Once you load translation, it is kept opened and any changes in the file lead to segfault and any replacing of the file is deleted. So the only way to make it see updated translation is to restart PHP (or Apache if you use mod_php). PS: Please discuss on phpmyadmin-translators(a)lists.sf.net not on -devel mailing list, so that all translators can see the discussion, initial post is on -devel just to notify developers who are not subscribed here. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

1 0

[Phpmyadmin-devel] Putting back the big T ?
by Marc Delisle 05 Jun '09

05 Jun '09

Hi, I'm pinging the list because I'm not sure what's best. I admit I removed the big T to promote the new display options but at least one person misses it (plus me, sometimes): https://sourceforge.net/tracker/?func=detail&aid=2724755&group_id=23067&ati… Now I realize that this feature is probably used more often than the other features in the Options slider and would agree to put it back for 3.3. Comments? Marc

2 1

[Phpmyadmin-devel] discussing GSoC development
by Marc Delisle 05 Jun '09

05 Jun '09

Hi, if part of the discussion happens in the phpmyadmin-devel list, part in private mails and part in blog replies, it's difficult for everyone to follow. In the student guide http://wiki.phpmyadmin.net/pma/GSoC_2009_Student_Guide we did mention that discussion should be done in the devel mailing list and I encourage everyone to do it there. Marc

3 2