Re: Proper relational database? - Mailing list pgsql-general

From Guyren Howe
Subject Re: Proper relational database?
Date
Msg-id DAC4ED5C-B3CC-4F26-9604-8C5C223BA46B@gmail.com
Whole thread Raw
In response to Re: Proper relational database?  (<david@andl.org>)
Responses Re: Proper relational database?
Re: Proper relational database?
List pgsql-general
On Apr 22, 2016, at 18:56 , <david@andl.org> <david@andl.org> wrote:

Why schema-on-demand? Can you explain what you mean by that?

Something that is attractive, for beginners or perhaps when prototyping is that you don't have to declare a table. You can just insert tuples into a predicate whose name you provide and they go in and you've defined a relation just by using it.

Much of my point in raising this discussion is that there are features that the NoSQL folks are implementing that are useful in some cases. Things they are doing like eventually consistent distributed stores are really required at sufficient scale, but there are other great ideas. SQL's storage model is not the only way, nor should it be. We shouldn't have to abandon the relational model to get such features, but we *do* have to abandon SQL to get them. And good riddance.

I would like to have relational stores providing such features before some monstrosity like Mongo or CouchDB becomes so entrenched we'll never be rid of it.

pgsql-general by date:

Previous
From: Manuel Gómez
Date:
Subject: Re: Proper relational database?
Next
From: Kevin Grittner
Date:
Subject: Re: Proper relational database?