ODBC wrapper code for postgreSql 8.2

This is a multi-part message in MIME format.

------_=_NextPart_001_01C73953.A976F525
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable


Hi,
=20
We are planning to use PostgreSql 8.2 for one of our project, so anbody
knows a ODBC wrapper code written in C++, which has very a good
performance, as we need to support 300 transactions per second.
=20
Thanks,
Sandy =20



The information contained in this electronic message and any attachments to=
this message are intended for the exclusive use of the addressee(s) and=
may contain proprietary, confidential or privileged information. If you=
are not the intended recipient, you should not disseminate, distribute or=
copy this e-mail. Please notify the sender immediately and destroy all=
copies of this message and any attachments.=20

WARNING: Computer viruses can be transmitted via email. The recipient=
should check this email and any attachments for the presence of viruses.=
The company accepts no liability for any damage caused by any virus=
transmitted by this email.
=20
www.wipro.com
------_=_NextPart_001_01C73953.A976F525
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Re: ODBC wrapper code for postgreSql 8.2

sandarsh.devappa@wipro.com wrote:
>
> Hi,
>
> We are planning to use PostgreSql 8.2 for one of our project, so anbody
> knows a ODBC wrapper code written in C++, which has very a good
> performance, as we need to support 300 transactions per second.

Hi Sandy,

If you're going to use C++ and don't mind committing yourself to
Postgresql, you might consider skipping ODBC altogether and using the ver=
y
robust libpqxx:

http://thaiopensource.org/development/libpqxx/

It does things STL-style, supports automatic reconnects for robustness,
query pipelining for high performance, etc.

Hope this helps!

Cheers,
Bart

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: ODBC wrapper code for postgreSql 8.2

Hi Bart,

Thanks a lot.

Currently it's a pilot project, in future we have to move to Oracle Rac
database as per customer interaction. If we use libpqxx, I feel we have
to face migration problem. So, we planned to use ODBC. I'm new to this
field, So, don't have much idea about ODBC. It would great help if we
can point us to good ODBC program.

Thanks and Regards,
Sandy

-----Original Message-----
From: Bart Samwel [mailto:bart@samwel.tk]=20
Sent: Tuesday, January 16, 2007 3:54 PM
To: Sandarsh Devappa (WT01 - IP-Multimedia Carrier & Ent Networks)
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] ODBC wrapper code for postgreSql 8.2

sandarsh.devappa@wipro.com wrote:
>
> Hi,
>
> We are planning to use PostgreSql 8.2 for one of our project, so=20
> anbody knows a ODBC wrapper code written in C++, which has very a good

> performance, as we need to support 300 transactions per second.

Hi Sandy,

If you're going to use C++ and don't mind committing yourself to
Postgresql, you might consider skipping ODBC altogether and using the
very robust libpqxx:

http://thaiopensource.org/development/libpqxx/

It does things STL-style, supports automatic reconnects for robustness,
query pipelining for high performance, etc.

Hope this helps!

Cheers,
Bart


The information contained in this electronic message and any attachments to=
this message are intended for the exclusive use of the addressee(s) and ma=
y contain proprietary, confidential or privileged information. If you are n=
ot the intended recipient, you should not disseminate, distribute or copy t=
his e-mail. Please notify the sender immediately and destroy all copies of =
this message and any attachments.=20

WARNING: Computer viruses can be transmitted via email. The recipient shoul=
d check this email and any attachments for the presence of viruses. The com=
pany accepts no liability for any damage caused by any virus transmitted by=
this email.
=20
www.wipro.com

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: ODBC wrapper code for postgreSql 8.2

Hi Sandy,

You might want to check this directory:

http://www.google.com/Top/Computers/Programming/Languages/C+ +/Class_Libra=
ries/Database/

I have no personal experience with any of these, but they might work for
you. Try to find some users' experiences on the net before you commit to
using one tool or the other. And whatever you do, don't use the MFC
database classes. They suck.

Cheers,
Bart

sandarsh.devappa@wipro.com wrote:
>
> Hi Bart,
>
> Thanks a lot.
>
> Currently it's a pilot project, in future we have to move to Oracle Rac
> database as per customer interaction. If we use libpqxx, I feel we have
> to face migration problem. So, we planned to use ODBC. I'm new to this
> field, So, don't have much idea about ODBC. It would great help if we
> can point us to good ODBC program.
>
> Thanks and Regards,
> Sandy
>
> -----Original Message-----
> From: Bart Samwel [mailto:bart@samwel.tk]
> Sent: Tuesday, January 16, 2007 3:54 PM
> To: Sandarsh Devappa (WT01 - IP-Multimedia Carrier & Ent Networks)
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] ODBC wrapper code for postgreSql 8.2
>
> sandarsh.devappa@wipro.com wrote:
>>
>> Hi,
>>
>> We are planning to use PostgreSql 8.2 for one of our project, so
>> anbody knows a ODBC wrapper code written in C++, which has very a good
>
>> performance, as we need to support 300 transactions per second.
>
> Hi Sandy,
>
> If you're going to use C++ and don't mind committing yourself to
> Postgresql, you might consider skipping ODBC altogether and using the
> very robust libpqxx:
>
> http://thaiopensource.org/development/libpqxx/
>
> It does things STL-style, supports automatic reconnects for robustness,
> query pipelining for high performance, etc.
>
> Hope this helps!
>
> Cheers,
> Bart
>
>
> The information contained in this electronic message and any attachment=
s
> to this message are intended for the exclusive use of the addressee(s) =
and
> may contain proprietary, confidential or privileged information. If you
> are not the intended recipient, you should not disseminate, distribute =
or
> copy this e-mail. Please notify the sender immediately and destroy all
> copies of this message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses=
..
> The company accepts no liability for any damage caused by any virus
> transmitted by this email.
>
> www.wipro.com
>


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: ODBC wrapper code for postgreSql 8.2

Thanks Bart.
The link is very useful.
Thanks for the advice, we are anyway not planned to use MFC Database
classes

Thanks,
Sandy

=20

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Bart Samwel
Sent: Tuesday, January 16, 2007 4:30 PM
To: Sandarsh Devappa (WT01 - IP-Multimedia Carrier & Ent Networks)
Cc: bart@samwel.tk; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] ODBC wrapper code for postgreSql 8.2

Hi Sandy,

You might want to check this directory:

http://www.google.com/Top/Computers/Programming/Languages/C+ +/Class_Libr
aries/Database/

I have no personal experience with any of these, but they might work for
you. Try to find some users' experiences on the net before you commit to
using one tool or the other. And whatever you do, don't use the MFC
database classes. They suck.

Cheers,
Bart

sandarsh.devappa@wipro.com wrote:
>
> Hi Bart,
>
> Thanks a lot.
>
> Currently it's a pilot project, in future we have to move to Oracle=20
> Rac database as per customer interaction. If we use libpqxx, I feel we

> have to face migration problem. So, we planned to use ODBC. I'm new to

> this field, So, don't have much idea about ODBC. It would great help=20
> if we can point us to good ODBC program.
>
> Thanks and Regards,
> Sandy
>
> -----Original Message-----
> From: Bart Samwel [mailto:bart@samwel.tk]
> Sent: Tuesday, January 16, 2007 3:54 PM
> To: Sandarsh Devappa (WT01 - IP-Multimedia Carrier & Ent Networks)
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] ODBC wrapper code for postgreSql 8.2
>
> sandarsh.devappa@wipro.com wrote:
>>
>> Hi,
>>
>> We are planning to use PostgreSql 8.2 for one of our project, so=20
>> anbody knows a ODBC wrapper code written in C++, which has very a=20
>> good
>
>> performance, as we need to support 300 transactions per second.
>
> Hi Sandy,
>
> If you're going to use C++ and don't mind committing yourself to=20
> Postgresql, you might consider skipping ODBC altogether and using the=20
> very robust libpqxx:
>
> http://thaiopensource.org/development/libpqxx/
>
> It does things STL-style, supports automatic reconnects for=20
> robustness, query pipelining for high performance, etc.
>
> Hope this helps!
>
> Cheers,
> Bart
>
>
> The information contained in this electronic message and any=20
> attachments to this message are intended for the exclusive use of the=20
> addressee(s) and may contain proprietary, confidential or privileged=20
> information. If you are not the intended recipient, you should not=20
> disseminate, distribute or copy this e-mail. Please notify the sender=20
> immediately and destroy all copies of this message and any
attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient=20
> should check this email and any attachments for the presence of
viruses.
> The company accepts no liability for any damage caused by any virus=20
> transmitted by this email.
>
> www.wipro.com
>


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


The information contained in this electronic message and any attachments to=
this message are intended for the exclusive use of the addressee(s) and ma=
y contain proprietary, confidential or privileged information. If you are n=
ot the intended recipient, you should not disseminate, distribute or copy t=
his e-mail. Please notify the sender immediately and destroy all copies of =
this message and any attachments.=20

WARNING: Computer viruses can be transmitted via email. The recipient shoul=
d check this email and any attachments for the presence of viruses. The com=
pany accepts no liability for any damage caused by any virus transmitted by=
this email.
=20
www.wipro.com

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq