pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedImplementing Frontend/Backend Protocol
4+ messages / 3 participants
[nested] [flat]
* Implementing Frontend/Backend Protocol
@ 2007-04-17 09:22 Raimon Fernandez <coder@montx.com>
2007-04-17 13:07 ` Re: Implementing Frontend/Backend Protocol Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 02:03 ` Re: Implementing Frontend/Backend Protocol John DeSoi <desoi@pgedit.com>
0 siblings, 2 replies; 4+ messages in thread
From: Raimon Fernandez @ 2007-04-17 09:22 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
I don't know if this is the correct mailing list for this ...
We want to implement, or at least, investigate how difficult will be
to talk directly with PostgreSQL via TCP/IP.
We have the original documentation, and in chapter 43 there is some
info.
Do you know where can we find examples (code) to start the project ?
We found some but where not related to TCP/IP.
Thanks in advance,
rai
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Implementing Frontend/Backend Protocol
2007-04-17 09:22 Implementing Frontend/Backend Protocol Raimon Fernandez <coder@montx.com>
@ 2007-04-17 13:07 ` Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 0 replies; 4+ messages in thread
From: Alvaro Herrera @ 2007-04-17 13:07 UTC (permalink / raw)
To: Raimon Fernandez <coder@montx.com>; +Cc: pgsql-interfaces
Raimon Fernandez wrote:
> I don't know if this is the correct mailing list for this ...
>
> We want to implement, or at least, investigate how difficult will be
> to talk directly with PostgreSQL via TCP/IP.
>
> We have the original documentation, and in chapter 43 there is some
> info.
>
> Do you know where can we find examples (code) to start the project ?
Yes, the src/interfaces/libpq directory contains a working
implementation. There are independent implementations elsewhere (JDBC,
ODBCng, etc).
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Implementing Frontend/Backend Protocol
2007-04-17 09:22 Implementing Frontend/Backend Protocol Raimon Fernandez <coder@montx.com>
@ 2007-04-19 02:03 ` John DeSoi <desoi@pgedit.com>
2009-10-23 09:25 ` Re: Implementing Frontend/Backend Protocol Raimon Fernandez <coder@montx.com>
1 sibling, 1 reply; 4+ messages in thread
From: John DeSoi @ 2007-04-19 02:03 UTC (permalink / raw)
To: Raimon Fernandez <coder@montx.com>; +Cc: pgsql-interfaces
It takes a bit of work to implement, but it is not too difficult.
What is your target implementation language?
Here is source library for Lisp:
http://common-lisp.net/project/postmodern/
John
On Apr 17, 2007, at 5:22 AM, Raimon Fernandez wrote:
> We want to implement, or at least, investigate how difficult will
> be to talk directly with PostgreSQL via TCP/IP.
>
> We have the original documentation, and in chapter 43 there is some
> info.
>
> Do you know where can we find examples (code) to start the project ?
>
> We found some but where not related to TCP/IP.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Implementing Frontend/Backend Protocol
2007-04-17 09:22 Implementing Frontend/Backend Protocol Raimon Fernandez <coder@montx.com>
2007-04-19 02:03 ` Re: Implementing Frontend/Backend Protocol John DeSoi <desoi@pgedit.com>
@ 2009-10-23 09:25 ` Raimon Fernandez <coder@montx.com>
0 siblings, 0 replies; 4+ messages in thread
From: Raimon Fernandez @ 2009-10-23 09:25 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
We're investigating again the idea of creating a directly connection
between our app and postgresql, using TCP/IP.
I found some examples in src/interfaces/libpq but they are in C, and
also found interesting the ones from Lisp.
But I can't figure it out almost nothing ...
:-)
So, maybe a practical example would be better:
I can start a connection, but I'm getting an error when I send the
start up sequence.
StartupMessage (F)
Int32
Length of message contents in bytes, including self.
** The total length including the total string => 33
Int32(196608)
The protocol version number. The most significant 16 bits are the
major version number (3
for the protocol described here). The least significant 16 bits are
the minor version number
(0 for the protocol described here).
** 300
The protocol version number is followed by one or more pairs of
parameter name and value
strings. A zero byte is required as a terminator after the last name/
value pair. Parameters can
appear in any order. user is required, others are optional. Each
parameter is specified as:
String
The parameter name. Currently recognized names are:
user
The database user name to connect as. Required; there is no default.
database
The database to connect to. Defaults to the user name.
options
Command-line arguments for the backend. (This is deprecated in favor
of setting indi-
vidual run-time parameters.)
In addition to the above, any run-time parameter that can be set at
backend start time might
be listed. Such settings will be applied during backend start (after
parsing the command-line
options if any). The values will act as session defaults.
String
The parameter value.
Ok, I can't see how I have to separate the name/value, maybe with a
slash / ?
And how I have to separate the next name/value ?
I understand that I have to add a byte 0 at the end of the last name/
value but not between them ?
user/postgresdatabase/scann0
this is what I send:
33300user/postgresdatabase/scann0
thanks,
regards,
r.
On 19/04/2007, at 4:03, John DeSoi wrote:
> It takes a bit of work to implement, but it is not too difficult.
> What is your target implementation language?
>
> Here is source library for Lisp:
>
> http://common-lisp.net/project/postmodern/
>
> John
>
>
>
> On Apr 17, 2007, at 5:22 AM, Raimon Fernandez wrote:
>
>> We want to implement, or at least, investigate how difficult will
>> be to talk directly with PostgreSQL via TCP/IP.
>>
>> We have the original documentation, and in chapter 43 there is some
>> info.
>>
>> Do you know where can we find examples (code) to start the project ?
>>
>> We found some but where not related to TCP/IP.
>
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2009-10-23 09:25 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-17 09:22 Implementing Frontend/Backend Protocol Raimon Fernandez <coder@montx.com>
2007-04-17 13:07 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 02:03 ` John DeSoi <desoi@pgedit.com>
2009-10-23 09:25 ` Raimon Fernandez <coder@montx.com>
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