Fwd: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Wed, Apr 4, 2012 at 9:53 AM, Dobes Vandermeer wrote: > I think there is something to be gained by having a first-class concept of a > "document" in the database.  It might save some trouble managing > parent/child relations, versioning, things like that. Methinks this needs a *lot* more specif

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Wed, Apr 4, 2012 at 6:26 AM, Josh Berkus wrote: > > > While I was doing this I always thought this would have been a better > > approach for my previous project, an accounting application. If I could > > just have stored entities like invoice & customer as a single document > that > > is inse

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

> While I was doing this I always thought this would have been a better > approach for my previous project, an accounting application. If I could > just have stored entities like invoice & customer as a single document that > is inserted, updated, etc. atomically it would be a lot simpler and fas

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Sat, Mar 31, 2012 at 6:37 AM, Dobes Vandermeer wrote: > On Sat, Mar 31, 2012 at 1:44 AM, Daniel Farina wrote: >> >> On Fri, Mar 30, 2012 at 10:21 AM, Daniel Farina wrote: >> > Any enhancement here that can't be used with libpq via, say, drop-in >> > .so seems unworkable to me, and that's why

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Sat, Mar 31, 2012 at 1:44 AM, Daniel Farina wrote: > On Fri, Mar 30, 2012 at 10:21 AM, Daniel Farina wrote: > > Any enhancement here that can't be used with libpq via, say, drop-in > > .so seems unworkable to me, and that's why any solution that is > > basically proxying to the database is ba

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Fri, Mar 30, 2012 at 10:21 AM, Daniel Farina wrote: > Any enhancement here that can't be used with libpq via, say, drop-in > .so seems unworkable to me, and that's why any solution that is > basically proxying to the database is basically a non-starter outside > the very earliest prototyping st

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Fri, Mar 30, 2012 at 9:11 AM, Andrew Dunstan wrote: > > > On 03/30/2012 11:41 AM, Robert Haas wrote: >> >> On Fri, Mar 30, 2012 at 10:55 AM, Dobes Vandermeer >>  wrote: >>> >>> Well, in our case HTTP is a clear win (but not replacement) and SPDY a >>> potential one (even as a replacement).  Eve

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On 03/30/2012 11:41 AM, Robert Haas wrote: On Fri, Mar 30, 2012 at 10:55 AM, Dobes Vandermeer wrote: Well, in our case HTTP is a clear win (but not replacement) and SPDY a potential one (even as a replacement). Even if SPDY is not widely adopted it could still replace FEBE if there's a clear

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Fri, Mar 30, 2012 at 10:55 AM, Dobes Vandermeer wrote: > Well, in our case HTTP is a clear win (but not replacement) and SPDY a > potential one (even as a replacement).  Even if SPDY is not widely adopted > it could still replace FEBE if there's a clear advantage to using it, I > don't know eno

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Fri, Mar 30, 2012 at 9:57 PM, Merlin Moncure wrote: > On Thu, Mar 29, 2012 at 10:04 AM, Andrew Dunstan > wrote: > > 1. I've been in discussion with some people about adding simple JSON > extract > > functions. We already have some (i.e. xpath()) for XML. > > Your json work is a great start in

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Fri, Mar 30, 2012 at 4:30 PM, Daniel Farina wrote: > On Thu, Mar 29, 2012 at 10:55 PM, Dobes Vandermeer > wrote: > >> Virtual hosts. Same port.>> I think SPDY or like-protocols [...] give a > crisp treatment to > >> interactive, stateful workloads involving > >> > >> back-and-forth between cl

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On 03/30/2012 09:57 AM, Merlin Moncure wrote: What I'm saying is that jsonpath probably isn't the whole story: another way of bulk moving json into native backend structures without parsing would also be very helpful. For example, being able to cast a json document into a record or a record a

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Thu, Mar 29, 2012 at 10:04 AM, Andrew Dunstan wrote: > 1. I've been in discussion with some people about adding simple JSON extract > functions. We already have some (i.e. xpath()) for XML. I've built a couple of applications that push data in and out of xml via manual composition going out an

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Thu, Mar 29, 2012 at 10:55 PM, Dobes Vandermeer wrote: >> Virtual hosts. Same port. > > In that case, the frontend would not be tied to a specific PostgreSQL > server, then?  I think initially this might complicate things a bit, and you > could solve it by putting an HTTP proxy in front to do t

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Fri, Mar 30, 2012 at 10:55 AM, Daniel Farina wrote: > On Thu, Mar 29, 2012 at 6:37 PM, Dobes Vandermeer > wrote: > > On Fri, Mar 30, 2012 at 3:59 AM, Daniel Farina > wrote: > >> > >> On Thu, Mar 29, 2012 at 12:57 PM, Daniel Farina > >> wrote: > >> > >> More technical concerns: > >> > * Prot

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Thu, Mar 29, 2012 at 6:37 PM, Dobes Vandermeer wrote: > On Fri, Mar 30, 2012 at 3:59 AM, Daniel Farina wrote: >> >> On Thu, Mar 29, 2012 at 12:57 PM, Daniel Farina >> wrote: >> >> More technical concerns: >> > * Protocol compression -- but a bit of sand in the gears is *which* >> > compressio

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Fri, Mar 30, 2012 at 3:57 AM, Daniel Farina wrote: > On Thu, Mar 29, 2012 at 8:04 AM, Andrew Dunstan > wrote: > > Lastly, a case that can not as easily be fixed without some more > thinking is leveraging caching semantics of HTTP. think people would > really, really like that, if they cou

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Fri, Mar 30, 2012 at 3:59 AM, Daniel Farina wrote: > On Thu, Mar 29, 2012 at 12:57 PM, Daniel Farina > wrote: More technical concerns: > > * Protocol compression -- but a bit of sand in the gears is *which* > > compression -- for database workloads, the performance of zlib can be > > a meani

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Thu, Mar 29, 2012 at 6:25 PM, Dobes Vandermeer wrote: >> 2. You might find htsql interesting. > > > As a reference, or should we just bundle / integrate that with PostgreSQL > somehow? It's a totally different language layer without wide-spread popularity and, as of last ye

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Thu, Mar 29, 2012 at 11:04 PM, Andrew Dunstan wrote: > > On 03/29/2012 10:37 AM, Dobes Vandermeer wrote: > >> Hi guys, >> >> Something from Josh's recent blog post about summer of code clicked with >> me - the HTTP / SQL concept. >> >> > 1. I've been in discussion with some people about addin

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Thu, Mar 29, 2012 at 12:57 PM, Daniel Farina wrote: D'oh, I munged the order. More technical concerns: > * Protocol compression -- but a bit of sand in the gears is *which* > compression -- for database workloads, the performance of zlib can be > a meaningful bottleneck. > * Something similar

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On Thu, Mar 29, 2012 at 8:04 AM, Andrew Dunstan wrote: 1. I've been in discussion with some people about adding simple JSON extract > functions. We already have some (i.e. xpath()) for XML. > > 2. You might find htsql interesting. My colleagues and myself have thought about t

Re: [HACKERS] HTTP Frontend? (and a brief thought on materialized views)

On 03/29/2012 10:37 AM, Dobes Vandermeer wrote: Hi guys, Something from Josh's recent blog post about summer of code clicked with me - the HTTP / SQL concept. It was something I'd been thinking about earlier, how people really like HTTP APIs and this is one of the drivers behind adoption o

[HACKERS] HTTP Frontend? (and a brief thought on materialized views)

Hi guys, Something from Josh's recent blog post about summer of code clicked with me - the HTTP / SQL concept. It was something I'd been thinking about earlier, how people really like HTTP APIs and this is one of the drivers behind adoption of some "NoSQL" databases out there. Some things that