|
|
Posted by Manuel Lemos on 05/15/06 07:34
Hello,
on 05/14/2006 06:39 PM Colin McKinnon said the following:
> It may be relevant to point out that I used to earn my living developing
> RAD applications in MS-Access. It was great for battering out
> applications really quickly. It was not nearly so good for collaborative
> and large scale development work. What really put me off it - and one of
> the main reasons I began developing in PHP is that it is a total PITA
> to distribute and maintain applications. So currently I am trying to
> seperate what was good in MS-Access from the bad bits and recreate them in
> PHP. This is not always as easy as it sounds - avoiding control inversion
> in the UI component was difficult - but I think I acheived it sensibly in
> PfP Studio. Now I'm trying to do the same with the database.
Before you re-invent the wheel, you may want to take a look at Metabase.
It was the first PHP database abstraction layer to focus on total
database application portability.
This means that not only it provides an API that lets you write database
applications that work without a change to access many RDBMS (MySQL,
PostgreSQL, Oracle, MS SQL server, MS Access, SQLite, Interbase, etc..),
but it also lets you install or upgrade database schemas in a RDBMS
independent way.
Metabase can take database schema definitions in a RDBMS independent XML
format. Then it can install the schema executing the necessary DDL
statements for creating, tables, indexes, keys, sequences, etc..
The greatest part, is that when you want to upgrade the schema of an
already installed application, all you need to do is to change your
schema definition files and ask Metabase to compare and apply the
changes. The schema is upgraded without loosing records added to the
database since it was installed for the first time or upgraded for the
last time.
Metabase is available here:
http://www.phpclasses.org/metabase
The tutorial and other documentation is available here:
http://www.meta-language.net/documentation.html#metabase
--
Regards,
Manuel Lemos
Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/
PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/
Navigation:
[Reply to this message]
|