Dienstag, 18. August 2009

Status report August 11th - August 18th

video

http://page.mi.fu-berlin.de/rutkowsk/phpMyAdmin/howto.avi

KEY ACCOMPLISHMENTS LAST WEEK
=============================

- Wrote additional documentation, added information about the
config vars to Documentation.html

- Used add_message(_file).sh to add lang vars.

- Made the tracking of SQL dump imports working.

- Created a short how-to video (see my blog)

- Asked friends to evaluate my project.

- Registered to PMA wiki, but can't edit all articles.

KEY TASKS THAT STALLED
======================
--

KEY CONCERNS
============
Evaluation

TASKS IN THE UPCOMING WEEK(s)
==========================
- Improve the mechanism

Montag, 10. August 2009

Status report August 3rd - August 10th

Hi all,

KEY ACCOMPLISHMENTS LAST WEEK
=============================

- I added an user-friendly visualisation of the structure snapshots.
It is similar to the structure page of phpMyAdmin.

- Secondly I added handlers for CREATE/DROP/ALTER DATABASE.
Tracking for these commands is enabled by default. User has not to
create a version for it, it will created by the Tracker autmatically.

- An output for these tracked commands is available on the "Tracking"
page for databases now.

- Added a line number to the tracking report.

KEY TASKS THAT STALLED
======================
Evaluation

KEY CONCERNS
============
Evaluation, Documentation, Optimization.


TASKS IN THE UPCOMING WEEK
==========================
- Try to get feedback from users and developers.
- Write documentation, improve my code.


Best regards

Alexander

Sonntag, 2. August 2009

Status report July 25th - August 2nd

Hi all,

my report is a little bit delayed, my great-grandfather had 90th birthday on friday. I hope I will reach this age too ;)

KEY ACCOMPLISHMENTS LAST WEEK
=============================

- Created an overview page for (un)tracked tables/views in a database. It gives a short status report of tracked tables/views and links to the "create version" page for untracked tables.

- A new grey-colored icon indicates whether a table has versions but deactive tracking status.

- Added handlers for CREATE/DROP INDEX, CREATE/ALTER/DROP VIEW.

- Auto-creation functionality implemented. It creates a version of new tables and views automatically.

- Some new config vars added. Here a short introduction:

// Creates tracking of new tables and views automatically. Default value is true.
$cfg['Servers'][$i]['tracking_version_auto_create'] = true|false


// Adds "DROP VIEW" statement as prefix of "CREATE VIEW" logs. Default value is true.
$cfg['Servers'][$i]['tracking_add_drop_view'] = true|false

// Adds "DROP TABLE" statement as prefix of "CREATE TABLE" logs. Default value is true.
$cfg['Servers'][$i]['tracking_add_drop_table'] = true|false

// Defines the statements which the auto-creation mechanism uses for new tracked versions.
// Default value is
// CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,
// CREATE INDEX,DROP INDEX,
// INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,
// CREATE VIEW,ALTER VIEW,DROP VIEW,
// CREATE DATABASE,ALTER DATABASE,DROP DATABASE;

$cfg['Servers'][$i]['tracking_default_statements'] = ...

KEY TASKS THAT STALLED
======================
-

KEY CONCERNS
============
Finishing list of deliverables.


TASKS IN THE UPCOMING WEEK
==========================
- I want to focus on structure snapshots. The snapshot is saved in a php array.
A user-friendly visualisation of it would be fine. Comparison of snapshots is an idea.

- Secondly I want to add an ouput of tracked CREATE/DROP/ALTER DATABASE statements
to the "Tracking" overview page for databases.

- When time is left: start first phase of testing and evaluation. Try to get more feedback from users and developers.



Best regards

Alexander