From: Merlin Moncure <mmoncure@gmail.com>
To: John R Pierce <pierce@hogranch.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Raimon Fernandez <coder@montx.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Implementing Frontend/Backend Protocol TCP/IP
Date: Tue, 27 Oct 2009 10:07:27 -0400
Message-ID: <b42b73150910270707n62fdd776x11dae4f0e3c48b43@mail.gmail.com> (raw)
In-Reply-To: <4AE62E21.7040600@hogranch.com>
References: <92781008-8A70-42CE-A49B-6EE67103FACB@montx.com>
<FC6CBC8C-A398-4835-B3A3-C16C6F4F62D9@pgedit.com>
<E084987E-A212-4B70-8CFF-D83AA00629C5@montx.com>
<C670629A-1E54-4F80-9497-6CCAC1A8BDC0@montx.com>
<20091026231516.GN8812@alvh.no-ip.org>
<4AE62E21.7040600@hogranch.com>
On Mon, Oct 26, 2009 at 7:17 PM, John R Pierce <pierce@hogranch.com> wrote:
> Alvaro Herrera wrote:
>>>
>>> I'm trying to implement the front-end protocol with TCP from
>>> REALbasic to PostgreSQL.
>>>
>>
>> That sounds the most difficult way to do it. Can't you just embed
>> libpq?
>>
>
> yah, seriously. the binary protocol is not considered stable, it can
> change in subtle ways in each version. libpq handles the current version
> and all previous versions, and exposes all methods.
small clarification:
There is only one protocol and it is binary. For example the length
of datums is never sent as a string. The protocol is quite
stable...it hasn't changed since 7.4 and there hasn't really been a
big call (some of the quite interesting comments in this thread aside)
for it to change IMO.
The protocol has a binary or text mode, so that user data can be
sent/received in text or binary. Using the binary mode is not stable,
which is what I think you were basically saying.
Now, (self serving pitch here) if you use libpqtypes, you get all the
benefits of binary protocol mode (performance, easy data marshaling)
without having to worry about data format changes between versions
:-D.
merlin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mmoncure@gmail.com, pierce@hogranch.com, alvherre@commandprompt.com, coder@montx.com, pgsql-general@postgresql.org
Subject: Re: Implementing Frontend/Backend Protocol TCP/IP
In-Reply-To: <b42b73150910270707n62fdd776x11dae4f0e3c48b43@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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