Thread: Which variant to choose?

On 30/10/10 07:56, RP Khare wrote:
>   I want to use PostgreSQL for my standalone .NET Windows application. I
> downloaded PostgreSQL Advanced Server from EnterpriseDB's website and it
> is very smooth. The GUI also very good. But I suspect how along
> EnterpriseDB will support it.
 > The second option is to download from postgresql.org
 > <http://www.postgresql.org/>.

There aren't any substantial differences (that I'm aware of) in the free
download from EnterpriseDB vs the community release. It includes a lot
of work on the installer package.

> I want an edition that lasts long and I can easily upgrade it to future
> versions without any problems and it must work smoothly with .NET. It
> must also integrate seemlessly with third-party reporting tools.

The core postgresql project typically supports releases for about 5
years. Upgrades within a major release (e.g. 9.0.1 to 9.0.4) are simple.
Upgrades between major releases (e.g. 9.0.x to 9.1.x) can be done via a
dump/restore or (for the latest releases) the pg_upgrade utility (don't
know if it's ported to Windows).

As regards .net and reporting tools, I can't comment. We have drivers
for .net, odbc and jdbc but whether they are seamless enough only you
can decide.

--
   Richard Huxton
   Archonet Ltd

On Sat, Oct 30, 2010 at 2:56 AM, RP Khare
<passionate_programmer@hotmail.com> wrote:
> I want to use PostgreSQL for my standalone .NET Windows application. I
> downloaded PostgreSQL Advanced Server from EnterpriseDB's website and it is
> very smooth. The GUI also very good. But I suspect how along EnterpriseDB
> will support it.
> The second option is to download from postgresql.org.
> I want an edition that lasts long and I can easily upgrade it to future
> versions without any problems and it must work smoothly with .NET. It must
> also integrate seemlessly with third-party reporting tools.

EnterpriseDB adds a lot of value to Postgres, especially if you are
coming from another platform and new to the postgres ecosystem.  Along
with various product enhancements, they provide support, training, and
consulting services.  The company provides resources to PostgreSQL
development and has some core community members on its team.  You will
be in good hands.  Generally speaking, it's considered poor etiquette
to solicit and pitch commercial services on the community lists but I
have no direct affiliation so I'm covered :-).  There are also several
other companies that provide support services listed on the PostgreSQL
site: (http://www.postgresql.org/support/professional_support)...many
of them are also excellent.  PostgreSQL has a technical and community
culture that tends to attract really bright people.

merlin