SQLite UPSERT Implementation Task

SQLite UPSERT Implementation Task: a task in Terminal-Lego-15k (Harbor dataset). You need to implement a visit counter system using SQLite that tracks IP addresses and their hit counts. The system should support "UPSERT" functionality - inserting a new record if the IP doesn't exist, or updating…

The task

You need to implement a visit counter system using SQLite that tracks IP addresses and their hit counts. The system should support "UPSERT" functionality - inserting a new record if the IP doesn't exist, or updating (incrementing) the hit count if it does.

Part of PrimeIntellect/Terminal-Lego-15k.