need information

Started by Peeyushalmost 17 years ago8 messagesbugsgeneral
Jump to latest
#1Peeyush
peeyush_jain@persistent.co.in
bugsgeneral

Hey guys,

I need some information on

1. What are the best features of Npgsql product as compare to other
commercial .net data providers?

2. If you have encountered any major problems, bugs or performance issue
etc... With this product?

Thanks in advance,

Peeyush Jain| Software Engineer -Netezza Dev | Persistent Systems Ltd

<mailto:peeyush_jain@persistent.co.in> peeyush_jain@persistent.co.in |
Cell: +91 9373069475 | Tel: +91 (20) 3023 6762

Innovation in software product design, development and delivery-
<http://www.persistentsys.com/&gt; www.persistentsys.com

DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Peeyush (#1)
bugsgeneral
Re: need information

Peeyush wrote:

I need some information on

1. What are the best features of Npgsql product as compare to
other commercial .net data providers?

2. If you have encountered any major problems, bugs or
performance issue etc... With this product?

You sent this to way too many lists, and you didn't select
those very carefully (pgsql-bugs ??).

The correct place for such a question is either the general list
(this one) or - even better - the Npgsql open-discussion forum:

http://pgfoundry.org/forum/forum.php?forum_id=518

As to your questions:

Question 1 is wrong, because Npgsql is no commercial .NET data provider.
That's the main advantage: it is open source.

Concerning your second question, the only unresolved problem I am
aware of is with SSL connections, and that is a problem in
Mono, see https://bugzilla.novell.com/show_bug.cgi?id=321325

Yours,
Laurenz Albe

#3Joshua D. Drake
jd@commandprompt.com
In reply to: Laurenz Albe (#2)
bugsgeneral
Re: need information

On Wed, 2009-04-15 at 17:15 +0200, Albe Laurenz wrote:

As to your questions:

Question 1 is wrong, because Npgsql is no commercial .NET data provider.
That's the main advantage: it is open source.

This is actually a misconception. Open Source doesn't disqualify it as
commercial. It disqualifies it as proprietary. I can make money
providing consulting for Npgsql, that makes it commercial or at least
the opportunity for it to be commercial.

Not to be pedantic but let's be accurate with our data. We are database
people after all :)

Sincerely,

Joshua D. Drake

--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

#4Francisco Figueiredo Jr.
francisco@npgsql.org
In reply to: Peeyush (#1)
bugsgeneral
Re: need information

On Wed, Apr 15, 2009 at 07:57, Peeyush <peeyush_jain@persistent.co.in> wrote:

Hey guys,

Hi, Peeyush!

I need some information on

1. What are the best features of Npgsql product as compare to other
commercial .net data providers?

Well, the first one is that it is opensource. :)

We are working actively on it and we try to provide as fast as
possible the features our users need. Although some times we don't
deliver them as fast as we wished :(

We already have a very nice code base which can give you almost
anything you would need in your programs.

Please, give it a try and let us know what you think.

2. If you have encountered any major problems, bugs or performance issue
etc... With this product?

Well, one of the biggest performance problems we have but we already
did some performance tunning is with bytea handling. It used to take a
lot of time with large data.

Our current performance problem is with prepared statements. Npgsql
still needs some tunning on this.

I think this is it for while.

As Albe already said, you would get a good feedback if you post your
question to our forum.

Thanks in advance.

I hope it helps.

Thanks in advance,

Peeyush Jain| Software Engineer –Netezza Dev | Persistent Systems Ltd

peeyush_jain@persistent.co.in  | Cell: +91 9373069475 | Tel: +91 (20) 3023
6762

Innovation in software product design, development and delivery-
www.persistentsys.com

DISCLAIMER ========== This e-mail may contain privileged and confidential
information which is the property of Persistent Systems Ltd. It is intended
only for the use of the individual or entity to which it is addressed. If
you are not the intended recipient, you are not authorized to read, retain,
copy, print, distribute or use this message. If you have received this
communication in error, please notify the sender and delete all copies of
this message. Persistent Systems Ltd. does not accept any liability for
virus infected mails.

--
Regards,

Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
http://friendfeed.com/franciscojunior

#5Peeyush
peeyush_jain@persistent.co.in
In reply to: Francisco Figueiredo Jr. (#4)
bugsgeneral
Re: need information

Thanks a lot for kind information.

Currently I am investigating on Npgsql and dotConnect .. because we have
feature list of dotConnect I attached the same for your quick reference but
we don't have in Npgsql. If you can help me in this then it will be greatful
for me.

Thanks & regards,

Peeyush Jain | Software Engineer -Netezza Dev | Persistent Systems Ltd

peeyush_jain@persistent.co.in | Cell: +91 9373069475 | Tel: +91 (20) 3023
6762

Innovation in software product design, development and delivery-
www.persistentsys.com

-----Original Message-----
From: francisco.figueiredo.jr@gmail.com
[mailto:francisco.figueiredo.jr@gmail.com] On Behalf Of Francisco Figueiredo
Jr.
Sent: Wednesday, April 15, 2009 11:40 PM
To: Peeyush
Cc: pgsql-general@postgresql.org; npgsql-devel
Subject: Re: [GENERAL] need information

On Wed, Apr 15, 2009 at 07:57, Peeyush <peeyush_jain@persistent.co.in>
wrote:

Hey guys,

Hi, Peeyush!

I need some information on

1. What are the best features of Npgsql product as compare to other

commercial .net data providers?

Well, the first one is that it is opensource. :)

We are working actively on it and we try to provide as fast as

possible the features our users need. Although some times we don't

deliver them as fast as we wished :(

We already have a very nice code base which can give you almost

anything you would need in your programs.

Please, give it a try and let us know what you think.

2. If you have encountered any major problems, bugs or performance issue

etc... With this product?

Well, one of the biggest performance problems we have but we already

did some performance tunning is with bytea handling. It used to take a

lot of time with large data.

Our current performance problem is with prepared statements. Npgsql

still needs some tunning on this.

I think this is it for while.

As Albe already said, you would get a good feedback if you post your

question to our forum.

Thanks in advance.

I hope it helps.

Thanks in advance,

Peeyush Jain| Software Engineer -Netezza Dev | Persistent Systems Ltd

peeyush_jain@persistent.co.in | Cell: +91 9373069475 | Tel: +91 (20) 3023

6762

Innovation in software product design, development and delivery-

www.persistentsys.com

DISCLAIMER ========== This e-mail may contain privileged and confidential

information which is the property of Persistent Systems Ltd. It is

intended

only for the use of the individual or entity to which it is addressed. If

you are not the intended recipient, you are not authorized to read,

retain,

copy, print, distribute or use this message. If you have received this

communication in error, please notify the sender and delete all copies of

this message. Persistent Systems Ltd. does not accept any liability for

virus infected mails.

--

Regards,

Francisco Figueiredo Jr.

Npgsql Lead Developer

http://www.npgsql.org

http://fxjr.blogspot.com

http://twitter.com/franciscojunior

http://friendfeed.com/franciscojunior

DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

#6Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Joshua D. Drake (#3)
bugsgeneral
Re: need information

Joshua D. Drake wrote:

Question 1 is wrong, because Npgsql is no commercial .NET data provider.
That's the main advantage: it is open source.

This is actually a misconception. Open Source doesn't disqualify it as
commercial. It disqualifies it as proprietary. I can make money
providing consulting for Npgsql, that makes it commercial or at least
the opportunity for it to be commercial.

Not to be pedantic but let's be accurate with our data. We are database
people after all :)

Thank you for the correction.

Although I'd say that the fact that you can make money by consulting
for something does not make it commercial software. Maybe I'm wrong.

But it is of course possible to forbid people to use your open source
software unless they pay for it, which would make it commercial
in my eyes.

This is getting off topic, sorry.

Yours,
Laurenz Albe

#7David Fetter
david@fetter.org
In reply to: Laurenz Albe (#6)
bugsgeneral
Re: need information

On Thu, Apr 16, 2009 at 11:22:46AM +0200, Albe Laurenz wrote:

Joshua D. Drake wrote:

Question 1 is wrong, because Npgsql is no commercial .NET data provider.
That's the main advantage: it is open source.

This is actually a misconception. Open Source doesn't disqualify it as
commercial. It disqualifies it as proprietary. I can make money
providing consulting for Npgsql, that makes it commercial or at least
the opportunity for it to be commercial.

Not to be pedantic but let's be accurate with our data. We are database
people after all :)

Thank you for the correction.

Although I'd say that the fact that you can make money by consulting
for something does not make it commercial software. Maybe I'm wrong.

"Commercial" means, "used in commerce." It has nothing to do with the
terms under which the software's source code is (or is not) available.

But it is of course possible to forbid people to use your open
source software unless they pay for it, which would make it
commercial in my eyes.

That would make it *proprietary*, as no FLOSS license allows such a
restriction.

This is getting off topic, sorry.

Vaguely. Has that stopped us before? ;)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

#8Francisco Figueiredo Jr.
francisco@npgsql.org
In reply to: Peeyush (#1)
bugsgeneral
Re: need information

On Thu, Apr 16, 2009 at 02:12, Peeyush <peeyush_jain@persistent.co.in> wrote:

Sorry missed the attachment L

No problem.

Thanks for the document with feature list of dotConnect.
I'll create one for Npgsql which can give more information. Npgsql is
missing a list like that for a long time.

Another missing feature from the list is the design time support. We
are working on that although we don't anything ready yet.

We also don't have something like pgdump or pgloader.

We don't have compact framework support

Those are the biggest features we are lacking. I can see a lot more
compared to dotConnect which we still would need to work on.

As soon as I compile the list I'll let you know.

Thanks for your interest in Npgsql. Your feedback also is very nice so
we can improve even more Npgsql.

Peeyush Jain| Software Engineer –Netezza Dev | Persistent Systems Ltd

peeyush_jain@persistent.co.in  | Cell: +91 9373069475 | Tel: +91 (20) 3023 6762

Innovation in software product design, development and delivery- www.persistentsys.com

________________________________

From: Peeyush [mailto:peeyush_jain@persistent.co.in]
Sent: Thursday, April 16, 2009 10:37 AM
To: 'francisco@npgsql.org'

Cc: 'pgsql-general@postgresql.org'; 'npgsql-devel'
Subject: RE: [GENERAL] need information

Thanks a lot for kind information.

Currently I am investigating on Npgsql and dotConnect …… because we have feature list of dotConnect I attached the same for your quick reference but we don’t have in Npgsql. If you can help me in this then it will be greatful for me.

Thanks & regards,

Peeyush Jain | Software Engineer –Netezza Dev | Persistent Systems Ltd

peeyush_jain@persistent.co.in  | Cell: +91 9373069475 | Tel: +91 (20) 3023 6762

Innovation in software product design, development and delivery- www.persistentsys.com

-----Original Message-----

From: francisco.figueiredo.jr@gmail.com [mailto:francisco.figueiredo.jr@gmail.com] On Behalf Of Francisco Figueiredo Jr.
Sent: Wednesday, April 15, 2009 11:40 PM
To: Peeyush
Cc: pgsql-general@postgresql.org; npgsql-devel
Subject: Re: [GENERAL] need information

On Wed, Apr 15, 2009 at 07:57, Peeyush <peeyush_jain@persistent.co.in> wrote:

Hey guys,

Hi, Peeyush!

I need some information on

1. What are the best features of Npgsql product as compare to other

commercial .net data providers?

Well, the first one is that it is opensource. :)

We are working actively on it and we try to provide as fast as

possible the features our users need. Although some times we don't

deliver them as fast as we wished :(

We already have a very nice code base which can give you almost

anything you would need in your programs.

Please, give it a try and let us know what you think.

2. If you have encountered any major problems, bugs or performance issue

etc... With this product?

Well, one of the biggest performance problems we have but we already

did some performance tunning is with bytea handling. It used to take a

lot of time with large data.

Our current performance problem is with prepared statements. Npgsql

still needs some tunning on this.

I think this is it for while.

As Albe already said, you would get a good feedback if you post your

question to our forum.

Thanks in advance.

I hope it helps.

Thanks in advance,

Peeyush Jain| Software Engineer –Netezza Dev | Persistent Systems Ltd

peeyush_jain@persistent.co.in  | Cell: +91 9373069475 | Tel: +91 (20) 3023

6762

Innovation in software product design, development and delivery-

www.persistentsys.com

DISCLAIMER ========== This e-mail may contain privileged and confidential

information which is the property of Persistent Systems Ltd. It is intended

only for the use of the individual or entity to which it is addressed. If

you are not the intended recipient, you are not authorized to read, retain,

copy, print, distribute or use this message. If you have received this

communication in error, please notify the sender and delete all copies of

this message. Persistent Systems Ltd. does not accept any liability for

virus infected mails.

--

Regards,

Francisco Figueiredo Jr.

Npgsql Lead Developer

http://www.npgsql.org

http://fxjr.blogspot.com

http://twitter.com/franciscojunior

http://friendfeed.com/franciscojunior

DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

--
Regards,

Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
http://friendfeed.com/franciscojunior