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.
[ Parent
| on HN ]
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.