Adding neighbor navigation

2026-01-08 9:17 PM

#code #sqlite

I did a little work on the site tonight and got neighbor post navigation added to the bottom of each individual post. I learned in the process that SQLite doesn't allow parentheses in SQL UNION statements, so I can't get the previous and next posts in one call using SQLAlchemy.

My database is tiny, so it doesn't really matter, but it was a struggle because the error wasn't clear about where the problem was coming from and it took a while to get everything working.