Daily Archives: 2009-12-23

SQL Pagination Without OFFSET

Just thought I’d look up how people paginate efficiently in SQLite since, apparently, OFFSET is just an alias for “discard N first results”. The recommended solution is to use a WHERE clause to mimic offset using the same column index … Continue reading

Posted in Web Wandering & Opinion | Leave a comment