Re: Application Development with PostgreSQL

Joanne,

> I’m really a newbie when it comes to application
> development, I used to develop website through PHP and
> now I’m undergoing training for application
> development… I hope you can answer some of my
> questions. Me and my colleagues would like to develop
> help fix one of the application in the company. This
> application will be shared throughout the company
> network. One of my colleagues suggested the use of
> PostgreSQL for some data and use it together with
> Delphi or Visual Basic. In general there any
> advantage in using Delphi / VB than using ordinary
> PHP…particularly with speed and reliability issues?

I can give you a very simple answer: No.

The advantage of using Delphi or VB for your interface are the advantages that
come with a client-side application instead of a web app:
1) Interactive & immediate response to user input (no screen reloads).
2) Fine-grained formatting options and printer-friendly reporting.
3) Two-way session control for user security.

The disadvantages are:
1) Platform dependence (e.g. VB runs only on Windows and Delphi doesn't do
OSX).
2) Plaform version issues and corruption of program binaries by viruses and
disk corruption on the desktop;
3) Rollout issues with installing each interface bug fix on each user desktop;
4) Secure communications protocol issues with communication btw. the desktop
clients and the server;
5) Speed issues with poorly configured or "sick" desktop machines;
6) Vastly more cumbersome external access for work-from-home users.

My company used to develop applications using VB clients. Now we pretty much
exclusively develop intranet-based applications (usually PHP + PostgreSQL);
they are cheaper, easier, and faster.

--
Josh Berkus
Aglio Database Solutions
San Francisco