Re: Clarification Desired
Rich Shepard <rshepard <at> appl-ecosys.com>
2006-08-08 21:31:17 GMT
On Mon, 7 Aug 2006, Alfredo Yong wrote:
> the point you are arising is very interesting. In fact, it can be reasonable
> to think that if your application uses adodb, it should be possible to have
> any database behind it.
To repeat: this is not _my_ application. Rather, it is one that I would
like to use with postgres but which has been developed specifically for
> The answer is a definitive may be. IF you have written the queries
> thinking in porting, then it should be no problem. You have to understand
> that you can execute through adodb propietary extensions of the SQL
> language. If you, as programmer, are used to that extensions (I have that
> "problem" with my beloved PostgreSQL) then it may be hard to you to limit
> yourself to the ANSI 92 (or ANSI 99) SQL standard.
> On the other hand, adobd have some support to propietary estensions,
> providing, depending upon the driver to the dabatase you are using, a
> wrapper or a emulation of that extension.
Now I understand. The application's developers may have incorporated mysql
extensions and local dialect in the application, and that is what is fed to
I've been told my core PostgreSQL developers that it is more ANSI
compliant than is mysql, and that can cause portability issues.
> Hope my English is good enough to be understood, and also i hope this help
> you in your decision. I would like to ask you to tell us about your decision
> and the reasons behind it.
As a businessman I am frustrated that there is no readily useful client
management and sales lead, prospect, and campaign administration
application that supports postgres. Well, there is one, but they want to add
even more layers on top of apache, and that's not what I want to support.
Large enterprises with separate computer support staffs might not mind all
the time and effort required to keep everything running, but we're much too
small to devote that level of effort.
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc.(TM) | Accelerator
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo