PostgreSQL with .NET

**Spam Catcher** · Mar 5 '07, 11:35 PM

Re: PostgreSQL with .NET

"Penelope Dramas" <penelopeDOTdra masATpro-transportDOTcom wrote in
news:ufuUrb3XHH A.3268@TK2MSFTN GP04.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]** · Mar 6 '07, 08:55 AM

Re: PostgreSQL with .NET

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]** · Mar 6 '07, 10:25 PM

Re: PostgreSQL with .NET

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** · Mar 7 '07, 03:25 PM

Re: PostgreSQL with .NET

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]" <nospam@nospam. comwrote in message
news:tvyogpkaum sf$.dlg@thinker sroom.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** · Mar 7 '07, 07:05 PM

Re: PostgreSQL with .NET

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" <penelopeDOTdra masATpro-transportDOTcom wrote in message
news:OfRvWsMYHH A.4940@TK2MSFTN GP05.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]" <nospam@nospam. comwrote in message
news:tvyogpkaum sf$.dlg@thinker sroom.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]** · Mar 7 '07, 08:45 PM

Re: PostgreSQL with .NET

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" <penelopeDOTdra masATpro-transportDOTcom wrote in message
news:OfRvWsMYHH A.4940@TK2MSFTN GP05.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]" <nospam@nospam. comwrote in message
>news:tvyogpkau msf$.dlg@thinke rsroom.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** · Apr 12 '07, 01:45 PM

Re: PostgreSQL with .NET

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

a-wake

http://a-wake.net

Daftar Situs Slot Gacor dengan RTP Tertinggi untuk Pemain Baru

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.
>
>

PostgreSQL with .NET

PostgreSQL with .NET

Comment

Comment

Comment

Comment

Comment

Comment

Comment