[PHP-DB] Re: Abstraction Layer....

2004-09-19 Thread Manuel Lemos 
Hello,
On 09/19/2004 02:32 PM, M Saleh Eg wrote:
Anyone for a list of php abstraction classes?
ADODB, PEAR::DB... any others? or better?
Metabase
http://www.phpclasses.org/metabase
PEAR::MDB
http://pear.php.net/package/MDB
Creole
http://creole.phpdb.org/
--
Regards,
Manuel Lemos
PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/
PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/
Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Abstraction Layer....

2004-09-19 Thread Stefan Reimers 
PHP knows at least three more:
dba	-	for databases built on "Berkeley DB" which can be used some 
DB-configurations of MySQL

dbm	-	also very specific for dbm-format, which seems not to be a 
relational one. Some apps seem to use that kind of DB internally.

dbx	-	supports about a dozen types of RDBMS (e.g. PostgreSQL and Oracle, 
furthermore ODBC) and is very nice. I worked with it the last four 
months to write a flexible information system.

Some comparisons can be found at:
http://php.weblogs.com/Compare_PEAR_DB_ADOdb
http://phplens.com/lens/adodb/
Stefan
M Saleh Eg wrote:
Anyone for a list of php abstraction classes?
ADODB, PEAR::DB... any others? or better?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Abstraction layer or not?

2002-11-05 Thread Manuel Lemos 
Hello,

On 11/05/2002 11:21 PM, Leif K-Brooks wrote:

I'm working on a new site, and I'm wondering whether to use an 
abstraction layer or not.  I don't have any plans to switch DB system, 
but you never know what the future holds.  I figure that there's no 
reason not to, but are there any down sides?  Which abstraction layers 
are good?

There is another point on using abstraction layers which is the fact 
that since many people use the same API, all can share the eventual 
tools and components based on that API.

For instance, I am developing a data persistence layer generator that is 
able to generate code and database schemas from a description in XML of 
the structure of a set of classes and the relationships that exist 
between them.

The generator creates the modelled classes and a database schema to 
provide persistent storage for the classes objects. The classes provide 
an API to retrieve and store the objects according to your application 
as described in the model description in XML. See below for a simple 
example.

With this tool you no longer need to put up with the tedious work of 
setting databases, write SQL by hand, write code to retrieve and store 
the data, etc.. This way you can speedup the development of your 
application often by more than an order of magnitude.

The generated code and database schema description (also in XML) is 
based on Metabase database abstraction, so anybody using Metabase can 
benefit from this tool.

Read more about this here:

http://www.meta-language.net/news-2002-11-01-persistence.html

http://www.phpclasses.org/metabase

--

Regards,
Manuel Lemos



(#) $Id: cms.component,v 1.3 2002/11/06 01:52:52 mlemos Exp $
  -->

	cms
	Content management system component

	
		article

		
			title
			text
		

		
			lead
			text
		

		
			body
			text
		

		
			author
			author
		

		
			creation_date
			timestamp
		

		
			categories
			category
			articles
		

	

	
		author

		
			name
			text
		

		
			articles
			article
			author
		

	

	
		category

		
			name
			text
		

		
			description
			text
		

		
			parent
			category
		

		
			children
			category
			parent
		

		
			articles
			article
			categories
		

	

	

		
			installschema
			installschema
		

	

	

		
			getarticle
			getobject
			
article

	article

			
		

		
			getauthor
			getobject
			
author

	author

			
		

		
			getcategory
			getobject
			
category

	category

			
		

	




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php