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.
-
Author Archives: Stephan Sokolow
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
My First Impression of Google Wave
Well, I finally got an invite to Google Wave. I haven’t had much time to play around with it yet, but my first impression is that it could potentially be just the thing I need for collaborative story planning… once … Continue reading
Posted in Web Wandering & Opinion
Leave a comment
Gender-Bending Index Beta 2 Released
After far too long, I finally found time to make some of the planned improvements to my gender-bending index. Beta 2 brings the following improvements: The detail expanders on the tables are now at least as comprehensive as the original … Continue reading
Posted in Otaku Stuff, Site Updates
2 Comments
LCDProc and the PCIDEA 20×4 LCD display
A couple of weeks ago, I got it into my head that the death of Blinkenlights was a bad thing. My primary PC already has a little LCD on the keyboard (I got a deal on a first-generation Logitech G15 … Continue reading
Posted in Geek Stuff
Leave a comment
Fic Reviews Status Update
As most people who read this will probably have noticed, I haven’t had the time or will to post full-fledged fanfiction reviews in quite a while. However, I have been amassing simple out-of-five numerical ratings in a private collection for … Continue reading
Posted in Fanfiction
Leave a comment
Gender-Bending List back up… more or less
Gender-Bending Fiction Index Well, things are looking up. On a whim, I re-implemented most of the old gender-bending list’s functionality on the new database-backed platform I’ve been meaning to write for years. I’m not sure how steadily I’ll work on … Continue reading
Posted in Otaku Stuff, Site Updates
Leave a comment