About the Author
I'm Stephan, a Linux user with a passion for open-source, UI/UX design, and exploring what makes fiction work.
In my spare time, I focus on (and write about):
- Programming (mainly in Python and Rust)
- Retrocomputing (mostly DOS but, as of January 2023, I also own a machine running Mac OS 9.2)
- Reading and Reviewing Fiction
- The odd bit of UI/UX design or literary theory
For notification of significant updates to existing posts, consider following me on Mastodon.
-
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