News for hackers. Stuff that matters.
Re:PostgREST – REST API from any PostgreSQL database by sergiosgc on Wednesday July 22, 2015 @09:09AM (#9929358)
> The problem is scaling your database, keeping your data secure, and iterating to meet business goals with a growing codebase and infrastructure. A mess of stored procedures would restrain you from doing all three.

Your argument has a non sequitur right here. A mess of [foo] is a mess; the layer it is in does not matter; the language it is in does not matter. A mess of application layer code is equally effective in preventing scale, security and effectiveness.

The original post is right. Web developers treat their databases poorly[1]. A database is an interface to your data that maintains integrity. Maintaining integrity almost always means stored procedures, as some validation is not expressible as relational integrity and basic type validation.

Now, if you are at the point where your database fully guarantees integrity of data going in and coming out, a REST interface is a small step away. This project is very welcome.

[1] The typical web developer treats a database as a data store. It is also a data store, but a well designed database is much more than than.

Re:PostgREST – REST API from any PostgreSQL database by bkeroack on Wednesday July 22, 2015 @09:40AM (#9929552)
A mess is a mess, true, but some are easier to clean up than others.

GP is correct. Methods for scaling/optimizing the application layer are clear and well-known. Scaling the data layer is a huge challenge. This is why the market is filled with snake oil databases promising linear scalability and perfect consistency/reliability, etc.

Re:PostgREST – REST API from any PostgreSQL database by threeseed on Wednesday July 22, 2015 @10:41AM (#9929896)
Scaling the data layer is a huge challenge. No doubt. But calling databases that are designed for solving these problems "snake oil" undermines the huge amount of work that serious engineers have invested in this. No one has ever promised linear scalability and perfect consistency/reliability. No one.

Cassandra, HBase, CouchDB etc even MongoDB have built in scalability as a first order priority from day one and have been largely successful at it e.g. iCloud, EA Online, PSN. Databases like this are a nightmare to work with for smaller datasets but work incredibly well with larger ones.

It's always a shame to see HN act like you scale vertically and magically every problem is solved.

Re:PostgREST – REST API from any PostgreSQL database by AlisdairO on Wednesday July 22, 2015 @01:21PM (#9930967)
> It's always a shame to see HN act like you scale vertically and magically every problem is solved.

When this is seen (and IME it's a pretty minority opinion) I think it's there as a reaction to the massive overuse and hype regarding a lot of newer-gen DBs. There's absolutely no doubt that there are good uses for them, but those cases are pretty niche compared to the level of their uptake.

Re:PostgREST – REST API from any PostgreSQL database by volaski on Wednesday July 22, 2015 @01:45PM (#9931117)
You should read "innovator's dilemma"
Re:PostgREST – REST API from any PostgreSQL database by AlisdairO on Wednesday July 22, 2015 @04:30PM (#9932111)
Is that comment intended to imply that companies will go under if they fail to deploy new technology that doesn't target their business needs?
Re:PostgREST – REST API from any PostgreSQL database by fweespeech on Wednesday July 22, 2015 @12:49PM (#9930755)
MongoDB heavily implied the linear scalability, consistency, reliability bit in its early material [particularly in their marketing].

Its only in the past couple years they really started mentioning the fact it was "tunable consistency" blatantly rather rather than burying it in a couple places in the manual.

Re:PostgREST – REST API from any PostgreSQL database by 3pt14159 on Wednesday July 22, 2015 @10:59AM (#9929987)
I purposely chose a non sequitur in the interests of speeding up the prose. It is an acceptable method frequently utilized in language. It roughly translates to:

"Than (what will certainly be given the expressiveness and level of abstraction they provide) a mess of stored procedures."