On Thu, 14 May 2009 15:18 +0300, "Domas Mituzas" midom.lists@gmail.com wrote:
Hello,
Are there any disadvantages that would result from doing work on using a database abstraction layer such as Adodb? Or advantages that are gained from the current methods of accessing databases.
our layer is abstracting queries, not only database API. there're some differences between two approaches.
Cheers, Domas
The approach of abstracting queries does appear to be a good option, rather than just abstracting the database API, as then queries could possibly be done using SQL statements that use particular features or syntax specific to the database server.
From looking further into ADODB, it appears that the performance hit
from using it could be significant for projects like Wikipedia (14% or so from the statistics on the ADODB site).
So abstracting the database API using something like ADODB may not be a good option after all, to get it to work better with other databases than MySQL. There does not seem to be any projects with a similiar size to the ones that use MediaWiki , which use ADODB and support a range of databases.
Regards, Karun
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l