Hi
Dne Mon, 29 Jun 2009 14:35:33 -0500 Derek Schaefer derek.schaefer@gmail.com napsal(a):
First, possibilities for the new import interface. For those who don't know much about my GSoC project, one of the goals was to create an intermediary interface for editing the structure of a new database/table set that was deduced from some import data. Via this interface the structure is to be altered and changed as necessary (dropping tables, changes keys, etc.) and once the user is satisfied, it is created and the data (now adapted to the new structure) in inserted. This involved storing all the data from the import in a PHP session so the source wouldn't have to be reanalyzed after the user made edits to the structure. I have been having some second thoughts regarding such an interface. Depending on the size of the import, the PHP session could take up a considerable amount of memory. Also, all database and table options are editable after creation via the current regular db/table interface, therefore I believe the intermediary interface would be redundant at best, and counterintuitive as worst. All the while being rather inefficient. I find that directing the user towards the newly created database and/or tables via a notification after a successful import is simple, effective, and vastly more efficient.
It might be an option. However converting some data later might be problematic, but I fail to find good example right now :-).
Second, I would like to propose a new XML export format to better support my new import features. This new format will present the option to export the SQL creation code for each of the exported tables in the manner outlined below:
<?xml version="1.0" encoding="utf-8" ?>
<!-- - - phpMyAdmin XML Dump - ... etc. etc. etc. -->
<pma_xml_export version="1.0" xmlns:pma="http://www.phpmyadmin.net/some_doc_url/%22%3E pma:structure pma:db_name pma:tbl_name_1CREATE TABLE `tbl_name_1`...</pma:tbl_name_1>
Please make it proper XML then and do not (re)introduce variable tag names.
pma:structure <pma:db name="databaze"> <pma:table name="tabulka">CREATE...</pma:table> ... <pma:view name="pohled">CREATE...</pma:view> <pma:trigger name="procedura">...</pma:trigger> </pma:db> </pma:structure>