From: jesse <je...@st...> - 2004-12-31 18:12:08
|
Yes, postgres & mysql both have ODBC drivers - a quick check on their page confirms that. I believe you are mixing up the components being talked about. The php adodb is just a database wrapper class for all the db drivers that php supports - mysql, mssql, postgres, *odbc*, yadda yadda. If you'll take a little time to read about it, it simply tries to give you normal operation for standard queries that will work on any/whichever you are interested in dbs, then has some methods to help 'build' queries whose equivalent sql on others platforms is not the same. Those functions address most of the concerns that have been posed (which is why it has been repeatedly suggested for people to look at). Others can be worked around by taking some of the logic out of the db by using more simple sql queries and letting php compile/compute data, thus working around various incompatible SQL syntaxes. ODBC has always been, still is, and will likely always be slow - this is why everyone uses native db drivers as much as possible. For the original 2 questions - it handles transactions if the actual underlying db driver handles transactions, and I believe the above answers the second. Also, as Jake mentioned, if speed ever was an issue (and it likely would only really show in high-use situations), there are several methods that can be employed to work around them, the simplest of which is a php extension available for php 4.3+ under linux and windows. here's where it's at: http://adodb.sourceforge.net/ jesse Jake Stride wrote: > Steve Kaill wrote: > >> Thanks for the info Jake. >> >> Wait a minute. Are we saying that there are no ODBC drivers to >> communicate >> to a MySQL or PostgreSQL database. I would be surprised about that. >> I can >> understand if you are saying that they do not use ODBC internally in >> order >> to get their job done. > > > Sorry no, I beleive there is ODBC for my/postgresql but I would say > that it is easier/faster to use the php interface to the databases > where applicable. > > Jake > >> >> My understanding is that ODBC is a layer/translator between your >> application >> database code and the database. ODBC has a standardized sql command >> set and >> all the databases are expected to accommodate it, possibly by using a >> driver >> for that type of database. The ODBC commands get converted into the >> native >> database command(s). Kind of like an assembly instruction gets >> converted to >> several micro-instructions within the cpu. ODBC enforces >> standardization as >> it is the same language for all databases. >> >> Steve >> >> ----- Original Message ----- From: "Jake Stride" >> <ns...@us...> >> To: <web...@li...> >> Sent: Friday, December 31, 2004 11:15 AM >> Subject: Re: [WebERP-developers] Postgres Anyone? >> >> >> >>> Steve Kaill wrote: >>> >>>> Does look interesting. However, a couple of thoughts... >>>> >>>> 1) Wonder if it handles InnoDB with transaction processing. >>>> >>>> 2) Does its language for communication to all the various databases >>> >> >> offer >> >>>> common functionality that extends beyond ODBC? If so, is adodb better >>>> because it is faster or is it possibly slower and maybe even uses ODBC >>> >> >> in >> >>>> the end anyway. >>> >>> >>> Have a look at >>> >>> http://phplens.com/adodb/supported.databases.html >>> >>> some of the databases use odbc, but mysql and postgres don't, I beleive >>> the performance should not be impacted too much and in some cases you >>> could use the built in caching features which help speed things up, >>> coupled with the C extensions and if you use a PHP cache then you >>> should >>> not really notice too much difference. >>> >>> The following link has some bench marking as aposed to my general >>> summary >> >> >> :) >> >>> http://phplens.com/lens/adodb/ >>> >>> Jake >>> >>> >>>> Steve >>>> >>>> ----- Original Message ----- From: "Jake Stride" >>>> <ns...@us...> >>>> To: <web...@li...> >>>> Sent: Friday, December 31, 2004 6:34 AM >>>> Subject: Re: [WebERP-developers] Postgres Anyone? >>>> >>>> >>>> >>>> >>>>> Steve Kaill wrote: >>>>> >>>>> >>>>>> Unless we're talking about M$ ADO as in new COM("ADODB.Connection") >>>>> >>>> >>>> which I >>>> >>>> >>>>>> believe is only for M$/Win then I don't understand what adodb is. >>>>>> >>>>>> How good would an ODBC solution be? Is ODBC any faster these days? >>>>> >> >> Can >> >>>>>> ODBC handle what we do? >>>>> >>>>> >>>>> http://adodb.sourceforge.net/ >>>>> >>>>> It is pretty good and makes building queries etc much easier. >>>>> >>>>> Have a read of there blurb. >>>>> >>>>> Jake >>>>> >>>>> >>>>> >>>>>> Steve >>>>>> >>>>>> ----- Original Message ----- From: "Franck Martin" >>>>>> <fr...@av...> >>>>>> To: <web...@li...> >>>>>> Sent: Wednesday, December 29, 2004 6:43 PM >>>>>> Subject: Re: [WebERP-developers] Postgres Anyone? >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------------------------------- >>>>>> The SF.Net email is sponsored by: Beat the post-holiday blues >>>>>> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. >>>>>> It's fun and FREE -- well, >>>>>> almost....http://www.thinkgeek.com/sfshirt >>>>>> _______________________________________________ >>>>>> Web-erp-developers mailing list >>>>>> Web...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>>>> >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------- >>>>> The SF.Net email is sponsored by: Beat the post-holiday blues >>>>> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. >>>>> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt >>>>> _______________________________________________ >>>>> Web-erp-developers mailing list >>>>> Web...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------- >>>> The SF.Net email is sponsored by: Beat the post-holiday blues >>>> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. >>>> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt >>>> _______________________________________________ >>>> Web-erp-developers mailing list >>>> Web...@li... >>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>> >>> >>> >>> >>> ------------------------------------------------------- >>> The SF.Net email is sponsored by: Beat the post-holiday blues >>> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. >>> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt >>> _______________________________________________ >>> Web-erp-developers mailing list >>> Web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> >> >> >> >> ------------------------------------------------------- >> The SF.Net email is sponsored by: Beat the post-holiday blues >> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. >> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > ------------------------------------------------------- > The SF.Net email is sponsored by: Beat the post-holiday blues > Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. > It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |