Intermediate Debugging Examples 0 ▲ The Third Bit 1 day ago · 9 min read1884 words · Tech · hide I’m thinking about extending this set of debugging examples with the more complex examples described below. I’d be very grateful for feedback: would they be useful? Would they be useful to you? What other examples could be included, or should be included instead of some of the ones I’ve outlined? Log Ingestion Pipeline A command-line Python tool that reads application log files, normalizes each line, extracts structured fields, and loads them into SQLite for later querying. What it does: walks a directory of log files, parses each line with a regex, converts the timestamp, extracts level/component/message, and inserts a row per line into a logs table. Components: a scanner, a parser/normalizer, a loader, and a query/report module that runs after loading. The bug: the normalizer converts timestamps to UTC and stores them as naive datetimes, while the query layer assumes local time and compares against naive datetime.now(). Reports are shifted by the local UTC offset. Secondarily, the… Commenting on Bubbles has been removed. Why? If you want to talk about this post, write to the author, use the comments on their blog if it has them, or reply with a "RE:" post on your own blog. Suggestions? feedback@bubbles.town