pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestions connecting to PostgreSQL.
5+ messages / 3 participants
[nested] [flat]
* Questions connecting to PostgreSQL.
@ 1999-09-30 10:31 J. Carlos Muro <SADACIA@santandersupernet.com>
0 siblings, 0 replies; 5+ messages in thread
From: J. Carlos Muro @ 1999-09-30 10:31 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Questions connecting to PostgreSQL.
@ 1999-10-06 06:18 J. Carlos Muro <SADACIA@santandersupernet.com>
1999-10-06 13:37 ` Re: [INTERFACES] Questions connecting to PostgreSQL. Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 5+ messages in thread
From: J. Carlos Muro @ 1999-10-06 06:18 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Questions connecting to PostgreSQL.
1999-10-06 06:18 Questions connecting to PostgreSQL. J. Carlos Muro <SADACIA@santandersupernet.com>
@ 1999-10-06 13:37 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Thomas Lockhart @ 1999-10-06 13:37 UTC (permalink / raw)
To: J. Carlos Muro <SADACIA@santandersupernet.com>; +Cc: pgsql-interfaces
> 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?
ODBC, libpq, libpq++, JDBC are the available options. Don't even think
about doing a custom implementation on sockets; you'll just be
duplicating work already done.
> 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?
Not sure. Look at the newest online docs at www.postgresql.org in the
chapter on Security, which discusses ssh, or check the mailing list
archives.
> 4.- I have heard about the libpq++ classes. But, are them only for
> Linux, or can I use them from the Borland C++ Builder?
They compile on two dozen platforms. Not sure what Borland requires
for code, how C++ compliant it is (the standard evolves faster than
the compilers), etc.
Good luck.
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] Questions connecting to PostgreSQL.
@ 1999-10-06 14:12 Ansley, Michael <Michael.Ansley@intec.co.za>
1999-10-07 13:20 ` Re: [INTERFACES] Questions connecting to PostgreSQL. Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Ansley, Michael @ 1999-10-06 14:12 UTC (permalink / raw)
To: J. Carlos Muro <SADACIA@santandersupernet.com>; +Cc: pgsql-interfaces
>> > 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?
>>
>> Not sure. Look at the newest online docs at www.postgresql.org in the
>> chapter on Security, which discusses ssh, or check the mailing list
>> archives.
>>
At the moment, although ssl is being built into libpq, which would enable
it's use for libpq++, ODBC does not use the libpq source, which is a bit of
a bummer. However, I suspect that it wouldn't be too difficult to include
it. If you're capable of writing a sockets server, you shouldn't find it
too difficult ;-)
MikeA
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Questions connecting to PostgreSQL.
1999-10-06 14:12 RE: [INTERFACES] Questions connecting to PostgreSQL. Ansley, Michael <Michael.Ansley@intec.co.za>
@ 1999-10-07 13:20 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Thomas Lockhart @ 1999-10-07 13:20 UTC (permalink / raw)
To: Ansley, Michael <Michael.Ansley@intec.co.za>; +Cc: J. Carlos Muro <SADACIA@santandersupernet.com>; pgsql-interfaces
> At the moment, although ssl is being built into libpq, which would enable
> it's use for libpq++, ODBC does not use the libpq source, which is a bit of
> a bummer. However, I suspect that it wouldn't be too difficult to include
> it. If you're capable of writing a sockets server, you shouldn't find it
> too difficult ;-)
Someone posted a note on how to fire up an SSL path from a client to a
server, which can then be used by the client to contact the
postmaster. In my 2 second test, it worked just fine. I didn't check
to see if subsequent connections (i.e. after the handoff to the
session backend) used SSL too. Does it, or can it? Or is this
technique only helpful to hide the initial passwords and handshaking??
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-10-07 13:20 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-30 10:31 Questions connecting to PostgreSQL. J. Carlos Muro <SADACIA@santandersupernet.com>
1999-10-06 06:18 Questions connecting to PostgreSQL. J. Carlos Muro <SADACIA@santandersupernet.com>
1999-10-06 13:37 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
1999-10-06 14:12 RE: [INTERFACES] Questions connecting to PostgreSQL. Ansley, Michael <Michael.Ansley@intec.co.za>
1999-10-07 13:20 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox