[Phpmyadmin-devel] Ajaxify phpMyAdmin - List of tasks to complete

[Ninad Pundalik]

On 28 May 2010 22:19, Marc Delisle <marc at infomarc.info> wrote:
> Ninad,
> your list is interesting and covers a lot of actions. I am not sure
> about your intention for some actions. For example, the "copy database"
> action; what's your plan? Will the user see a progress bar for the whole
> operation? and/or see a display of the current table name being copied?

Currently, when copying a database, a series of SQL queries is
executed and then, the same page reloads, with the successful query
shown on the page along with a message that the database has been
copied.  Keeping this in mind, my idea was to show the response
(success/error) in either a dialog, or append it to the current page.
If the user has requested to switch to the new database, then the page
would be reloaded with the new database, otherwise, the user can carry
on working with the current database.  This is a very simple
interface.

For a progress bar to be shown, we would have to break down this task
into smaller steps (like Create db, Create tables, copy data into
tables) and stream responses to the client/browser as each step is
completed.  Or, can this be done in a better way?  I'll read up
streaming HTTP responses if this is to be implemented.

> than the Search page, would it be possible to ajaxify the table Search
> page instead? A behavior that annoys me (and surely others) is that the

The search page uses sql.php to actually run the query, which I will
be modifying for Ajax.  So, it will not be very difficult to ajaxify
the database and table search page.  I've added it to the list of
tasks. :)

I've created a page on the phpMyAdmin wiki with the list of tasks (
http://wiki.phpmyadmin.net/pma/AJAXify_Interface ).  Please use this
for further reference instead of the pastebin.

Ninad S. Pundalik
Twitter: @ni_nad | Identica : @ninad | http://ninadpundalik.co.cc/blog
GPG Key Fingerprint: 2DF7 B856 C75E C9F9 0504 C0EF D456 1946 7C45 2C69