What's wrong with this SQL pagination?
What's wrong with this SQL pagination in a busy table. The SQL code uses OFFSET while new rows are inserted, so items shift and get skipped. In SQL APIs this causes missing and duplicated results.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlpaginationbug #sqloffsetpagination...