Michal Čihař - Blog Archives for phpMyAdmin

Big phpMyAdmin changes

This has already happen yesterday, but I decided to announce it today, because now there is snapshot with all those changes.

With Subversion we can rename files without losing their histrory and this possibility lead to huge cleanup of file names. I dropped all _details and _properties parts of table and database pages. As user you should not notice anything (except for different URL), but there might be still some problematic parts which has not been detected when I did this change.

So please give a current trunk snapshot or demo a bit of testing so that we can find problems before going to RC stage.

Bugreport in OpenDocument text? Oh my god!

In-Reply-To: [Newer version yield unexpected result....][b]

No I will never understand why somebody wants to submit bug report (which is duplicate anyway) in OpenDocument text, with yellow background, huge fonts and other crazy stuff. I'm probably old-fashioned, but I still think that plain text is enough (especially when another reporter was able to write it in few sentences). And of course writing useful summary is useless thing, the reason for summary field is just to write nothing saying sentence.

Security in phpMyAdmin?

There was recently bug in our bug tracker that we compete with Microsoft to achieve highest number of security bugs. We definitely do not compete! However there always be security issues in such big application.

Majority of them are XSS issues, which are hard to detect automatically, so you either have to test various inputs or deeply analyze the code. Most attackers choose testing method and it sometimes bring them fruit. We try to fix any found issue as soon as possible, but it is not in our possibilities to fix it for all past releases that might have been included in some distribution.

Anyway I'd like to improve phpMyAdmin in this area and I think nobody would object if somebody would help us with code audit. I'm not enough experienced to see all possible flaws in code.

Make your software scalable!

Okay, I finally give up with SubStats. It is software that might be useful for repository with few commits, but definitely not suitable for phpMyAdmin:

  1. You can not make graph for more than 1000 revisions of phpMyAdmin, it crashes because "stack is too low".
  2. Generated SVG make most browsers really busy as it contains too much points and they usually render it few minutes.
  3. I managed to analyse about 5000 revisions, but it now requires about 800 MiB of memory.

So I have unusable graphs of 1/10 of repository and analysed data for 1/2 of repository where I can not continue.

Howto upset developer?

Just set priority to highest and when developer decreases it, just tell him to stay **** off . Okay I will stay off your fucking issue, no problem.

(Side note: I have nothing against the issue itself, but this attitude won't make me to do anything about it.)

Subversion stats?

Okay, I failed to use both tools to do subversion stats I found - SubStats crash somewhere around 1000th revision (out of almost 10000 we currently have), MPY SVN STATS crashed even sooner. We're not that big project! Is there something else what can I use? I'd welcome any ideas.

Otherwise I will probably try to debug SubStats sometimes, but I lack time for that right now.

Just for record: I didn't use remotely overloaded SourceForge SVN server what was cause of my first problems, I did setup own server using SVN data from them. Only change it did made is that error appeared sonned and my computer had lot of work to do for about an hour.

phpMyAdmin switched to subversion

As we switched to subversion last night, I've also switched demo and snapshots to use subversion instead of CVS. Please report if there is something wrong or still refering to CVS.

The only thing which remains are statistics, for which I need to find good enough tool. For now I tested substats.rb, but it seems to miserably fail on some internal server error from Sourceforge.

Update: SubStats seem to work now, but it will process all data for quite a long time, so maybe there will be some results tomorrow :-).

Various download formats

For quite a long time phpMyAmin provided downloads in zip, tar.bz2 and tar.gz formats. As time went and project grow up, files were larger and larger.

Recently we finally decided to make change in that. We provide several stripped down versions and better compression, so that you can freely decide whether you want to download 761 KiB English only version compressed with 7zip or full bloated 3573 KiB version compressed by regullar zip. You can see all other variants in between on SourceForge Files section.