Database Schema Manager
| From: | Lukas Smith | Date: | Thu, 19 Jun 2003 11:23:42 +0000 |
| Subject: | Database Schema Manager | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-17567@lists.php.net to get a copy of this message | ||
Hi,
I am working on separating the Schema Manager in MDB into a separate
package.
The idea is that the new Manager will actually not require MDB anymore.
Instead the main part of the manager is handling array structures that
represent a schema. These array structures can be build up one by one,
merged, compared etc.
Also the Manager can call a parser or a writer to read or write a
schema.
I intent to provide the following parsers:
- XML (old parser)
- SQL (new)
- MDB (old reverse engineering)
and the following writers:
- XML (new, used to be embedded in the manager)
- SQL (new)
- MDB (old default behaviour)
There are all sorts of other parser and writers possible (someone else
needs to decide if they are feasible enough to be implemented) like:
- PEAR DB
- WDDX
- Excel
- PDF
- etc.
Here is my preliminary work on the API:
http://www.backendmedia.com/MDB/Manager/
I don't know yet how to name it.
Basically the schema manager does not require MDB by default anymore.
Actually it is possible to write a writer and/or parser for any database
abstraction layer.
So possible names are as follows:
DB_Manager
MDB_Manager
DB_Schema_Manager
MDB_Schema_Manager
...
Regards,
Lukas Smith
smith@backendmedia.com
_______________________________
BackendMedia
www.backendmedia.com
berlin@backendmedia.com
Linn Zwoch Smith GbR
Pariser Str. 44
D-10707 Berlin
Tel +49 30 83 22 50 00
Fax +49 30 83 22 50 07