HNHacker News
TopNewBestAskShowJobs

_w3e8

935 karma · joined July 31, 2015

submissionscomments
_w3e8··on PostgreSQL Scalability: Towards Millions TPS
Postgres has been my DB of choice for nearly a decade. The only times I wind up working with another db are because:

(1 it is a better technical fit for a very specific problem

(2 there is already a legacy db in place

I have been voted down at a couple of startups that wanted to run a "MEAN" stack, invariably all of those startups moved from MongoDB or shutdown.

The only time I will advocate for anything other than Postgres is when Wordpress is involved. If the data model is simple enough then MySQL is more than up for the task, and it avoids an additional database dependency.

Thankfully all the ORM's that are worth using support MySQL and Postgres, so using both is very doable.

### Useful Postgres (or SQL in general) tools/libraries :

Bookshelf ORM http://bookshelfjs.org/

PostgREST automated REST API https://github.com/begriffs/postgrest

Sqitch git style migration management http://sqitch.org/

_w3e8··on Dear AWS please eliminate startup time
You should really do some research into why your startup times are so long instead of blaming your service provider.
_w3e8··on Ask HN: Why web frameworks are becoming so complex?
"It doesn't force any particular way of doing things onto you."

Might as well be

"Your app is spaghetti 1 year after you leave the company."