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.
-
Monthly Archives: December 2009
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
Functional Programming Concepts for the Lay Programmer – Part 1
Update: Part 2 is finally available. Despite the growing interest in functional programming, most people (myself included) seem to have a lot of trouble grasping the core concepts and constructs. (Probably because the early adopters are all, to some extent, … Continue reading
Posted in Geek Stuff
1 Comment