News for hackers. Stuff that matters.
Re:PostgREST – REST API from any PostgreSQL database by _yy on Wednesday July 22, 2015 @11:20AM (#9930109)
Web servers usually scale better than (traditional) databases, so it makes sense to not offload computation to the database, even if it means that there's an overhead.
Re:PostgREST – REST API from any PostgreSQL database by brightball on Wednesday July 22, 2015 @01:29PM (#9931017)
That's very situational. Read scaling a database is easy. Write scaling a database is harder and doing computational logic while write scaling a database is harder still. Computational is still a very broad word though and the intensity of those computations is a huge defining factor.

The problem boils down to the "the database" idea described earlier. There are very, very few normalized datasets that I've ever seen that have write scaling concerns on more than 1 or two tables.

Move those to a separate datastore that is built for it and you've largely solved your problem. Postgres can even connect to outside datastores to run queries against them for sake of reporting.

Re:PostgREST – REST API from any PostgreSQL database by scottschulthess on Wednesday July 22, 2015 @12:15PM (#9930508)
Web server codebases are typically also way easier to modify, unit test, with better tools and languages.
Re:PostgREST – REST API from any PostgreSQL database by qaqy on Wednesday July 22, 2015 @01:51PM (#9931158)
there is even pl\brainfuck so as far as choice of langs PG has you covered