Le Lundi 18 Mars 2002 22:53, Dale Anderson a écrit :
> A couple of our developers, which are Microsoft VB developers, are
> complaining about not being able to use proprietary MS stuff with
> PostgreSQL.
Dear Dale,
Maybe you could consider using pgAdmin2 (http://pgadmin.postgresql.org),
which displays all database objects (tables, views, functions, triggers,
rules, etc...) in a nice Window$ interface.
An MS SQL Server migration wizard is also included. Historically, several
pgAdmin2 developpers come from an microsoft-oracle background and wanted to
get out of the matrix.
The most visible difference between MS SQL Server and PostgreSQL is that MS
SQL Server can be programmed in VB, whereas PostgreSQL supports serveral
server-side languages : PLpgSQL, PLperl, PLpython, even C...
People usually underestimate the power of server-side scripting. Oracle does
not and sell each server-side programming "cartridge" separately. PostgreSQL
provides them for free.
Furthermore, pgAdmin2 is provided with an abstraction layer called pgSchema,
which gives access to most database objects through an OCX technology.
pgSchema can be used in any VB project very easilly.
Therefore, in my humble opinion, PostgreSQL provides a very reliable solution
for both client-side (VB) and server-side (PostgreSQL) programming needs. The
power of PostgreSQL is to be able to do things smartly because we offer a
complete development environment.
The only thing your developpers need is to install pgAdmin2 and start
learning a server-side language (like PLpgSQL which is very easy). There is
probably a lot of client-code in you applications to migrate server-side.
PostgreSQL is also a great community of developpers. For help, the best place
are pgsql-admin, pgsql-general and pgadmin-hackers mailing lists.
Best regards,
Jean-Michel POURE
