3 ms·
Seconding simonw: If you implement a REST API with a "page" parameter that renders as OFFSET in its DB queries, I promise you someone will come along and page
by nicwolff 5y ago
Seconding simonw:
If you implement a REST API with a "page" parameter that renders as OFFSET in its DB queries, I promise you someone will come along and page through your entire "not big" table. For reporting, or to update XML sitemaps, or something else vital to their business.
Every 15 minutes.
Now put that API behind a public-facing Web app handling, say, a thousand requests a second.
Now deploy a migration that queues for an exclusive lock on a production table to add a column.
Now write a "post-mortem" report explaining to your boss' boss' bosses why their revenue-generating sites were all down for 15 minutes.