Archive

Archive for the ‘Summer of Code 2011’ Category

Drizzle support for phpMyAdmin – week 2

June 5th, 2011 No comments

With my semester nearing its end I didn’t have much time for coding, but I managed to get done with a few interesting things:

  • a new Plugins tab, which replaces Engines in Drizzle – it contains a list of installed plugins, with a list of features (engines, auth methods, functions, system views etc.) provided by each of them
  • created a Drizzle version of phpMyAdmin configuration storage, so all user preferences and other advanced functions are enabled and can work correctly
  • home page got correct wording for when user is connected to MariaDB or Drizzle database – no more indications that MySQL is used when it actually isn’t

In the future I plan to extend Plugins tab with some filtering and/or a second view, to provide a easily readable list of all plugin-provided features from one category.

During the next week I plan to concentrate on getting table Structure tab fully working, along with data browsing. Well, I say “get fully working” but in reality I want to go through all use cases and check whether it behaves correctly with Drizzle, and if it doesn’t – provide necessary fixes.

Categories: phpMyAdmin, Summer of Code 2011 Tags:

Drizzle support for phpMyAdmin – week 1

May 29th, 2011 No comments

With first week over, phpMyAdmin is now able to correctly handle displaying of navigation frame and database / table lists for Drizzle. The changes introduced this week were:

  • reading of table size and average row length from table cache (meaning that it works only if table is loaded into Drizzle’s cache),
  • showing row counts for PBMS tables, internally they are treated as InnoDB tables with approximate row count of 0,
  • database list tab works correctly, the number of available statistics is way down when compared to MySQL, but its a direct consequence of lack of table statistics in Drizzle,
  • I hid tabs for features not supported by Drizzle: Replication, Privileges, Engines (this will get replaced with a new Plugins tab),
  • due to how privileges work, everyone is treated as a superuser,
  • home page no more shows any “MySQL” headers when connected to a Drizzle server,
  • some internal changes that are not directly related to this week’s planned tasks, but involve my future work, i.e. removal of deprecated PMA_DBI_get_fields, changes to PMA_DBI_get_columns

Week ago I hoped to get accurate table and index sizes for InnoDB, as the engine itself makes it possible to access this data (as the amount of disk pages used by object), but it appears that only Percona makes this information available. MySQL seems to use it internally with its SHOW FULL TABLE STATUS, and Drizzle has currently no way of accessing it.

During next week I want to create a new server tab – Plugins, which replaces Engines tab for MySQL, and provides a list of all loaded plugins.

Categories: phpMyAdmin, Summer of Code 2011 Tags:

Drizzle support for phpMyAdmin – plans for first week

May 21st, 2011 No comments

Coding for Summer of Code is about to begin, meaning that for the next twelve weeks you will be seeing here weekly reports on my work. I have already set up my environment and made some changes to random bits of phpMyAdmin code, mostly to facilitate access to database metadata stored in information_schema and data_dictionary schemas. At the beginning I won’t be spending entire weeks on coding because my semester ends around the end of June, but changes introduced during that period will probably have the biggest impact on Drizzle support in phpMyAdmin – at the end of June all browsing and searching features should be working correctly.

Like in previous year, my public code repository lies at http://repo.or.cz/w/phpmyadmin/crack.git, with the work occurring on the drizzle branch. Demo version, updated hourly, is at http://demo.phpmyadmin.net/gsoc-piotr/. During the first week I want to make sure that the most basic functionality works correctly, i.e. we have correct and navigation frame and database/table lists. Some work on that is already done, but there are still some missing bits. If possible, I want to extract information on table and index sizes, which I should be able to do for InnoDB tables working with InnoDB plugin (HailDB doesn’t publish necessary information in data_dictionary).

Categories: phpMyAdmin, Summer of Code 2011 Tags:

Drizzle support for phpMyAdmin

April 27th, 2011 No comments

Yay, I have been accepted to Google Summer of Code for the third time! This year I will be coding my Drizzle support project for phpMyAdmin, which will enable it to be used with Drizzle.

Here is a short info on what I will be trying to achieve.

Synopsis

Implementing support for Drizzle in phpMyAdmin, which will allow users to utilize this tool with new, hopefully successful database management system.

Benefits to the users

phpMyAdmin will become a convenient tool for managing Drizzle databases, probably one of the first, if not first.

Project Details (abridged)

I want to look through phpMyAdmin code and test all features with Drizzle, making changes where necessary, so that at the end of upcoming summer all important features will work with Drizzle.

My work will encompass:

  1. Refactoring PMA_DBI_* functions to make them work with Drizzle
  2. Creating a set of functions for working with drizzle PHP extension
  3. Looking through all phpMyAdmin functionality to check whether it works with Drizzle, and making changes where necessary
  4. Removal of access to features which are unavailable in Drizzle core: privileges, replication
Categories: phpMyAdmin, Summer of Code 2011 Tags: