Skip site navigation (1) Skip section navigation (2)

Questions connecting to PostgreSQL.

From: "J(dot) Carlos Muro" <SADACIA(at)santandersupernet(dot)com>
To: PostgreSQL Interfaces Mailing List <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Questions connecting to PostgreSQL.
Date: 1999-09-30 10:31:13
Message-ID: 37F33BF1.FAD649BC@santandersupernet.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
This is my first message to the list so hello everybody !!

I want to develop a database application with Borland C++ Builder. I
want to access a PostgreSQL sited in a remote Linux, and I have many
general questions to solve before starting:

1.- ¿What ways can I use to connect to the database? (ODBC ...¿?)
I would like not using ODBC because it is too slow. I have heard about
sockets connections. Ideas?  Doc available?

2.- I want to transmit data in encrypted way. Is it true that ODBC
doesn't send data encryted? Is there a kwown solution for it?

3.- I have asked many other people about using the socket way (I like it
the most, 'cause it is the fastest way for communications, and I could
encrypt data). But these people said to me that I must do the next:
    * Implemment a UNIX daemon listening for the data arriving in the
database machine.
    * Immplement an application to pick the data up from this daemon and
sending it to PostgreSQL.
    * In the Window$ side, two ways:
        - Develop a DLL in an application server way, implementing my
own 'ODBC', that prepares data for my data controls from the VCL
(Borland C++ Builder controls), ie. DBList, DBText, etc ...
        - Develop my own classes based on VCL components, implemmentin
its own methods for data manipulating, ie. MyDBList, MyDBText, etc ...
The question is: Is it true? Am I messing too much :D ?

4.- I have heard about the libpq++ classes. But, are them only for
Linux, or can I use them from the Borland C++ Builder?

5.- Turning back to the question 1 (and considering the other
questions), is there anything that solves what I am looking for? I
suppose that I am not the first person that looks for it, so perhaps all
this is already done. What am I overlooking?

I would be thankfull for your help or any reference to documentation
that tells this. I am really confused since I have not even configured
PostgreSQL yet in my Linux. I had never installed it, so I have a long
way to run :D

Thanks:
Juan Carlos Muro
The Gseq Team


pgsql-interfaces by date

Next:From: Jelle RuttenbergDate: 1999-09-30 10:39:13
Subject: ODBC-client->Linux-server: datatype boolean not recognized?
Previous:From: zhang-lanDate: 1999-09-30 09:19:42
Subject: Access database via Servlet

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group