Обсуждение: PostgreSQL and Delphi 6
I have a client who wants to use Delphi as a front end to a Database, I would like to use PostgreSQL over MSSQL and have been looking at the psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm wondering if anyone has experience with it? Any help will be appreciated. Thanks, J
we are using postgresql8 +psqlodbc8+ delphi7 ... the only problem is the server side cursor = doesn't work properly ... so we are using client side for datasets .... :) On Wed, 15 Jun 2005 23:49:29 -0400, Postgres Admin <postgres@productivitymedia.com> wrote: > I have a client who wants to use Delphi as a front end to a Database, I > would like to use PostgreSQL over MSSQL and have been looking at the > psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm > wondering if anyone has experience with it? Any help will be > appreciated. > > Thanks, > J > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if > your > joining column's datatypes do not match > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Hi J! We use here vitavoom from Steve Howe (www.vitavoom.com). It's a very good and native alternative. It's paid but not expensive and you will have a very good and qualified technical supporte. Regards, Rodrigo Carvalhaes Postgres Admin wrote: >I have a client who wants to use Delphi as a front end to a Database, I >would like to use PostgreSQL over MSSQL and have been looking at the >psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm >wondering if anyone has experience with it? Any help will be appreciated. > >Thanks, >J > > >---------------------------(end of broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > > -- Esta mensagem foi verificada pelo sistema de antivírus e acredita-se estar livre de perigo.
We tested also (pgExpress Driver) - is faster then psqlodbc but we have a problem with it: it does requery (or refresh? - I don't remember exactly) after every post in database.(for us this is a problem - if you have more then 10.000 in current dataset loaded when you add a new record and post-it you stay 1 min !? ) - for curiosity how do you deal with this posible problem ? Adrian Din, Om Computer & Software, Bucuresti, Romania On Thu, 16 Jun 2005 09:54:21 -0300, grupos <grupos@carvalhaes.net> wrote: > Hi J! > > We use here vitavoom from Steve Howe (www.vitavoom.com). It's a very > good and native alternative. > It's paid but not expensive and you will have a very good and qualified > technical supporte. > > Regards, > > Rodrigo Carvalhaes > > Postgres Admin wrote: > >> I have a client who wants to use Delphi as a front end to a Database, I >> would like to use PostgreSQL over MSSQL and have been looking at the >> psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm >> wondering if anyone has experience with it? Any help will be >> appreciated. >> >> Thanks, >> J >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 9: the planner will ignore your desire to choose an index scan if >> your >> joining column's datatypes do not match >> >> > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Hi Adrian, You're right. What we did was include one "refresh" button and inserted one configuration that after x seconds the component refresh the screen (query). If you find a better solution, please inform me. Regards, Rodrigo Din Adrian wrote: > We tested also (pgExpress Driver) - is faster then psqlodbc but we > have a problem with it: > it does requery (or refresh? - I don't remember exactly) after every > post in database.(for us this is a problem - if you have more then > 10.000 in current dataset loaded when you add a new record and > post-it you stay 1 min !? ) - for curiosity how do you deal with this > posible problem ? > > Adrian Din, > Om Computer & Software, > Bucuresti, Romania > > On Thu, 16 Jun 2005 09:54:21 -0300, grupos <grupos@carvalhaes.net> wrote: > >> Hi J! >> >> We use here vitavoom from Steve Howe (www.vitavoom.com). It's a very >> good and native alternative. >> It's paid but not expensive and you will have a very good and >> qualified technical supporte. >> >> Regards, >> >> Rodrigo Carvalhaes >> >> Postgres Admin wrote: >> >>> I have a client who wants to use Delphi as a front end to a Database, I >>> would like to use PostgreSQL over MSSQL and have been looking at the >>> psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm >>> wondering if anyone has experience with it? Any help will be >>> appreciated. >>> >>> Thanks, >>> J >>> >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 9: the planner will ignore your desire to choose an index scan >>> if your >>> joining column's datatypes do not match >>> >>> >> > > > -- Esta mensagem foi verificada pelo sistema de antivírus e acredita-se estar livre de perigo.
I am sorry - I don't understand (or my english is bad or I don't know what you mean). > What we did was include one "refresh" button and inserted one > configuration that after x seconds the component refresh the screen > (query). So: When the user push the 'post' button the driver automatically refresh the current dataset and the user have to wait many seconds (or min?!) until it's finish. ok? How did you say you avoided this ? Adrian Din, Om Computer & SoftWare Bucuresti, Romania On Thu, 16 Jun 2005 10:29:38 -0300, grupos <grupos@carvalhaes.net> wrote: > Hi Adrian, > > You're right. What we did was include one "refresh" button and inserted > one configuration that after x seconds the component refresh the screen > (query). > > If you find a better solution, please inform me. > > Regards, > > Rodrigo > > Din Adrian wrote: > >> We tested also (pgExpress Driver) - is faster then psqlodbc but we have >> a problem with it: >> it does requery (or refresh? - I don't remember exactly) after every >> post in database.(for us this is a problem - if you have more then >> 10.000 in current dataset loaded when you add a new record and post-it >> you stay 1 min !? ) - for curiosity how do you deal with this posible >> problem ? >> >> Adrian Din, >> Om Computer & Software, >> Bucuresti, Romania >> >> On Thu, 16 Jun 2005 09:54:21 -0300, grupos <grupos@carvalhaes.net> >> wrote: >> >>> Hi J! >>> >>> We use here vitavoom from Steve Howe (www.vitavoom.com). It's a very >>> good and native alternative. >>> It's paid but not expensive and you will have a very good and >>> qualified technical supporte. >>> >>> Regards, >>> >>> Rodrigo Carvalhaes >>> >>> Postgres Admin wrote: >>> >>>> I have a client who wants to use Delphi as a front end to a Database, >>>> I >>>> would like to use PostgreSQL over MSSQL and have been looking at the >>>> psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm >>>> wondering if anyone has experience with it? Any help will be >>>> appreciated. >>>> >>>> Thanks, >>>> J >>>> >>>> >>>> ---------------------------(end of >>>> broadcast)--------------------------- >>>> TIP 9: the planner will ignore your desire to choose an index scan >>>> if your >>>> joining column's datatypes do not match >>>> >>>> >>> >> >> >> > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Hi Adrian! Yes, the user have to wait until the refresh finishes... That's a problem but we didn't found any other solution... Regards, Rodrigo Carvalhaes Din Adrian wrote: > I am sorry - I don't understand (or my english is bad or I don't > know what you mean). > >> What we did was include one "refresh" button and inserted one >> configuration that after x seconds the component refresh the screen >> (query). > > > So: > When the user push the 'post' button the driver automatically refresh > the current dataset and the user have to wait many seconds (or min?!) > until it's finish. ok? > How did you say you avoided this ? > > > Adrian Din, > Om Computer & SoftWare > Bucuresti, Romania > > > > On Thu, 16 Jun 2005 10:29:38 -0300, grupos <grupos@carvalhaes.net> wrote: > >> Hi Adrian, >> >> You're right. What we did was include one "refresh" button and >> inserted one configuration that after x seconds the component >> refresh the screen (query). >> >> If you find a better solution, please inform me. >> >> Regards, >> >> Rodrigo >> >> Din Adrian wrote: >> >>> We tested also (pgExpress Driver) - is faster then psqlodbc but we >>> have a problem with it: >>> it does requery (or refresh? - I don't remember exactly) after >>> every post in database.(for us this is a problem - if you have >>> more then 10.000 in current dataset loaded when you add a new >>> record and post-it you stay 1 min !? ) - for curiosity how do you >>> deal with this posible problem ? >>> >>> Adrian Din, >>> Om Computer & Software, >>> Bucuresti, Romania >>> >>> On Thu, 16 Jun 2005 09:54:21 -0300, grupos <grupos@carvalhaes.net> >>> wrote: >>> >>>> Hi J! >>>> >>>> We use here vitavoom from Steve Howe (www.vitavoom.com). It's a >>>> very good and native alternative. >>>> It's paid but not expensive and you will have a very good and >>>> qualified technical supporte. >>>> >>>> Regards, >>>> >>>> Rodrigo Carvalhaes >>>> >>>> Postgres Admin wrote: >>>> >>>>> I have a client who wants to use Delphi as a front end to a >>>>> Database, I >>>>> would like to use PostgreSQL over MSSQL and have been looking at the >>>>> psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, >>>>> I'm >>>>> wondering if anyone has experience with it? Any help will be >>>>> appreciated. >>>>> >>>>> Thanks, >>>>> J >>>>> >>>>> >>>>> ---------------------------(end of >>>>> broadcast)--------------------------- >>>>> TIP 9: the planner will ignore your desire to choose an index >>>>> scan if your >>>>> joining column's datatypes do not match >>>>> >>>>> >>>> >>> >>> >>> >> > > > -- Esta mensagem foi verificada pelo sistema de antivírus e acredita-se estar livre de perigo.