Thread: ODBC wrapper code for postgreSql 8.2
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.
Thanks,
Sandy
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. 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 |
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
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 attachments to this message are intended for the exclusive useof 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 allcopies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for thepresence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
Hi Sandy, You might want to check this directory: http://www.google.com/Top/Computers/Programming/Languages/C++/Class_Libraries/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 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. > > 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 >
Thanks Bart. The link is very useful. Thanks for the advice, we are anyway not planned to use MFC Database classes Thanks, Sandy -----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 > 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 > 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. > > 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 The information contained in this electronic message and any attachments to this message are intended for the exclusive useof 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 allcopies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for thepresence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com