From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | samantha <sjatkins(at)mac(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is there a way to bypass sql? |
Date: | 2010-08-09 18:57:00 |
Message-ID: | AANLkTin6Gk6X=tcWpn5hfBxyQBbAfoJG+WO-aVKfOBRw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Aug 9, 2010 at 2:39 PM, samantha <sjatkins(at)mac(dot)com> wrote:
> I have been digging into NoSQL of late. For navigational queries it would
> be great if there was a way to bypass SQL and directly pull from an
> identifier for a record or arbitrary byte stream. Does postgresql directly
> support such ability? What is the closest that you could come?
You can get pretty close, depending on how you define 'bypass'. For
example, it is possible to send rich data structures back and forth
between the client and the server without constructing a SQL text
string. Those structures still have to be strongly typed in the
server unless you want to stuff everything into a bytea (which btw I
think is a terrible idea for most cases). Could you describe in more
detail what you'd like to do and what (if any) inefficiencies or
restrictions SQL is imposing that you would like to bypass?
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | José María Terry Jiménez | 2010-08-09 19:11:05 | How to reference a subquery column alias? |
Previous Message | Pavel Stehule | 2010-08-09 18:52:34 | Re: Is there a way to bypass sql? |