PostgreSQL with .NET

[Penelope Dramas]

Hello,

We have decided to change our database back-end from MSDE to postgreSQL.

Would anyone please share his/her experience with this database as far as
speed, functionality and security concerns.
Thanks,

Pen D.

[Spam Catcher]

"Penelope Dramas" <penelopeDOTdramasATpro-transportDOTcomwrote in
news:uf**************@TK2MSFTNGP04.phx.gbl:

Hello,

We have decided to change our database back-end from MSDE to
postgreSQL.

Would anyone please share his/her experience with this database as far
as speed, functionality and security concerns.

Any particular reason you're going with Postgres and not something like
that SQL Server Express, MySQL or SQL Server? These databases have a more
active .NET developer base.

[Frans Bouma [C# MVP]]

Penelope Dramas wrote:

Hello,

We have decided to change our database back-end from MSDE to
postgreSQL.

Would anyone please share his/her experience with this database as
far as speed, functionality and security concerns.

PostgreSql is very reliable, well documented and has a rich set of
functionality. They had a vulnerability some time ago but that was
patched as well. The .NET provider for PostgreSql is OK, and is
actively maintained.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

[Rad [Visual C# MVP]]

On Mon, 5 Mar 2007 16:37:53 -0600, Penelope Dramas wrote:

Hello,

We have decided to change our database back-end from MSDE to postgreSQL.

Would anyone please share his/her experience with this database as far as
speed, functionality and security concerns.

Thanks,

Pen D.

PostgreSQL is a pretty good database. I don't think you have much to worry
about. Personally I would move to SQL Express ... Much better in the sense
that it has increased security, easier to deploy, improved performance and
most importantly no need to rewrite queries, views, etc

--
Bits.Bytes
http://bytes.thinkersroom.com

[Penelope Dramas]

Sorry for late reply, was out of office yesterday.

Thank you all for answers, I'm sure PostgreSQL will do good for us.

We're having issues with 1cpu limit, application performance dropped by 25%
when switched to SQLExpress. Our customers mainly have dual (physical) CPU
servers.
MSDE 2000 was perfect product, free and good, I don't know why, except for
money reason, Microsoft would introduce so much limitations to SQLExpress
comparing to MSDE (1cpu limit, no agent, ...)
"Rad [Visual C# MVP]" <no****@nospam.comwrote in message
news:tv***************@thinkersroom.com...

On Mon, 5 Mar 2007 16:37:53 -0600, Penelope Dramas wrote:

>Hello,

We have decided to change our database back-end from MSDE to postgreSQL.

Would anyone please share his/her experience with this database as far as
speed, functionality and security concerns.

Thanks,

Pen D.

PostgreSQL is a pretty good database. I don't think you have much to worry
about. Personally I would move to SQL Express ... Much better in the sense
that it has increased security, easier to deploy, improved performance and
most importantly no need to rewrite queries, views, etc

--
Bits.Bytes
http://bytes.thinkersroom.com

[Penelope Dramas]

Just to add that we wanted to add Unix/Linux server compatibility to our
application. Clients will obviously have to remain on Windows due to .net.
"Penelope Dramas" <penelopeDOTdramasATpro-transportDOTcomwrote in message
news:Of**************@TK2MSFTNGP05.phx.gbl...

Sorry for late reply, was out of office yesterday.

Thank you all for answers, I'm sure PostgreSQL will do good for us.

We're having issues with 1cpu limit, application performance dropped by
25% when switched to SQLExpress. Our customers mainly have dual (physical)
CPU servers.
MSDE 2000 was perfect product, free and good, I don't know why, except for
money reason, Microsoft would introduce so much limitations to SQLExpress
comparing to MSDE (1cpu limit, no agent, ...)
"Rad [Visual C# MVP]" <no****@nospam.comwrote in message
news:tv***************@thinkersroom.com...

>On Mon, 5 Mar 2007 16:37:53 -0600, Penelope Dramas wrote:

>>Hello,

We have decided to change our database back-end from MSDE to postgreSQL.

Would anyone please share his/her experience with this database as far
as
speed, functionality and security concerns.

Thanks,

Pen D.

PostgreSQL is a pretty good database. I don't think you have much to
worry
about. Personally I would move to SQL Express ... Much better in the
sense
that it has increased security, easier to deploy, improved performance
and
most importantly no need to rewrite queries, views, etc

--
Bits.Bytes
http://bytes.thinkersroom.com

[Rad [Visual C# MVP]]

On Wed, 7 Mar 2007 12:47:47 -0600, Penelope Dramas wrote:

Just to add that we wanted to add Unix/Linux server compatibility to our
application. Clients will obviously have to remain on Windows due to .net.

"Penelope Dramas" <penelopeDOTdramasATpro-transportDOTcomwrote in message
news:Of**************@TK2MSFTNGP05.phx.gbl...

>Sorry for late reply, was out of office yesterday.

Thank you all for answers, I'm sure PostgreSQL will do good for us.

We're having issues with 1cpu limit, application performance dropped by
25% when switched to SQLExpress. Our customers mainly have dual (physical)
CPU servers.
MSDE 2000 was perfect product, free and good, I don't know why, except for
money reason, Microsoft would introduce so much limitations to SQLExpress
comparing to MSDE (1cpu limit, no agent, ...)
"Rad [Visual C# MVP]" <no****@nospam.comwrote in message
news:tv***************@thinkersroom.com...

>>On Mon, 5 Mar 2007 16:37:53 -0600, Penelope Dramas wrote:

Hello,

We have decided to change our database back-end from MSDE to postgreSQL.

Would anyone please share his/her experience with this database as far
as
speed, functionality and security concerns.

Thanks,

Pen D.

PostgreSQL is a pretty good database. I don't think you have much to
worry
about. Personally I would move to SQL Express ... Much better in the
sense
that it has increased security, easier to deploy, improved performance
and
most importantly no need to rewrite queries, views, etc

--
Bits.Bytes
http://bytes.thinkersroom.com

Ah, cross platform compatibility is a whole different ball game.
--
Bits.Bytes
http://bytes.thinkersroom.com

[Petar Atanasov]

Hi,
Last year I've got some experience with PostgreSQL migration from SQL
server 2000 of real world working database.
One of the most common problems after porting data to the particular
data types implemented in the RDBMS is porting the functionality.

MS SQL server is the only RDBMS which serves multiple result sets, thus
implementation of that kind of stored procedures is impossible in
PostgreSQL (although its my favorite open source DB).

Further more - /stored procedures are functions in Postgresql/, there
were some additional problems with output parameters and other small but
very important issues related to it, which were hard to overcome.

My advice is to stay with SQL server - it's really the best choice, if
you are determined to present professional solution. For educational,
and proof-of-concept, etc. experiments - PostreSQL is ok. SQL is the
leading one, much more reliable, scalable and flexible. Well it's not
perfect but it's ages in front of the others (with features like DDL
triggers in the new 2K5, XML Indexes, materialized views and etc.)

Regards,
Petar Atanasov
http://a-wake.net

p.s.
MySQL - out of the discussion - we're talking about databases ;)

Penelope Dramas wrote:

Hello,

We have decided to change our database back-end from MSDE to postgreSQL.

Would anyone please share his/her experience with this database as far as
speed, functionality and security concerns.
Thanks,

Pen D.