Software-update: phpMyAdmin 3.0.0

Na een alpha, een bèta en twee release candidates is kortgeleden de finalrelease van van versie 3.0.0 van phpMyAdmin verschenen. Met behulp van dit databasemanagementprogramma is een Mysql-database via een webbrowser te onderhouden. Het is niet alleen mogelijk om databases en tabellen te maken, maar deze kunnen ook gedropt en gewijzigd worden. Daarnaast is het mogelijk om query's los te laten op de database. De belangrijkste veranderingen in versie 3.0.0 zijn ondersteuning voor diverse nieuwe mogelijkheden uit versie 5.1 van Mysql en de zogenaamde Maria en pbxt storage engines. Hieronder zijn de volledige release notes van deze versie te vinden:

Requirements for 3.0.0:

• PHP 5.2+, MySQL 5.0+; refer to Documentation.html for required PHP extensions

Improvements for 3.0.0:

• [table] support MySQL 5.1 PARTITION: CREATE TABLE / Table structure, partition maintenance
• [privileges] support for EVENT and TRIGGER
• [gui] Events
  • minimal support on db structure page
  • export
• [engines] Maria support
• [engines] MyISAM and InnoDB: support ROW_FORMAT table option
• [engines] PBXT: table options, foreign key (relation view, designer)
• [error handler] NEW handle errors to prevent path disclosure and display/collect errors
• [mysqlnd] do not display strMysqlLibDiffersServerVersion if the client is mysqlnd
• [webapp] experimental Mozilla Prism support
• [export] new plugin "codegen" for NHibernate
• [export] new export to Texy! markup
• [config] new parameter CheckConfigurationPermissions
• [config] new parameter ShowDatabasesCommand
• [config] new parameter CountTables
• rfe #1775288 [transformation] proper display if IP-address stored as INT
• rfe #1758177 [core] Add the Geometry DataTypes
• rfe #1741101, patch #1798184 UUID default for CHAR(36) PRIMARY KEY
• rfe #1840165 [interface] Enlarge column name field in vertical mode
• patch #1847534 [interface] New "Inside field" in db search
• [GUI] Mootools js library (http://mootools.net) and new parameter InitialSlidersState
• [core] cache some MySQL stats (do not query them with every page request)
• [view] clearer dialog WITH (CASCADED | LOCAL) CHECK OPTION
• [pdf] Merged tcpdf 2.2.002 (PHP5 version)
• prevent search indexes from indexing phpMyAdmin installations
• [lang] New Bangla
• [interface] Display options
• rfe #1962383 [designer] Option to create a PDF page
• [GUI] Color picker
• [navi] new parameter LeftDefaultTabTable
• [display] headwords for sorted column
• rfe #1692928 [transformation] Option to disable browser transformations
• [import] Speed optimization to be able to import the sakila database
• [doc] Documentation for distributing phpMyAdmin in README.VENDOR.

Fixes for 3.0.0.x:

• bug #1910621 [display] part 2: do not display a BINARY content as text
• [export] properly handle line breaks for YAML
• bug #1664240 [GUI] css height makes cfg TextareaRows useless
• bug #1724217 [Create PHP Code] doesn't include newlines for text fields
• bug #1845605 [i18n] translators.html still uses iso-8859-1
• bug #1823018 [charset] Edit(Delete) img-links pointing to wrong row
• bug #1826205 [export] Problems with yaml text export
• bug #1344768 [database] create/alter table new field can not have empty string as default
• patch #2007196, Typos in comments
• bug #1982315 [GUI] Comma and quote in ENUM
• bug #1970836 [parser] SQL parser is slow
• bug #2033962 [import] Cannot import zip file
• [core] Safer handling of temporary files with open_basedir
• bug #2066923 [display] Navi browse icon does not go to page 1
• patch #2075263 [auth] Single sign-on and cookie clearing
• bug #2080963 [charset] Clarify doc and improved code
• bug [charset] Cannot sort twice on a column when the table name contains accents
• bug #2113848 [navi] Page number after database switching
• patch #2115966 [GUI] Checkboxes and IE 7
• bug #114066 [core] ForceSSL generates incorrectly escaped redirections

[break]