Price history storage with SQLite

I've been working on amazon price tracker for a while and wanted to share what I learned.

The problem

Track prices on Amazon products and get notified the instant they drop below your target. Supports wishlists, price history charts, and daily digest emails so you never overpay again.

What I built

Here are the main features I ended up shipping:

• Real-time Amazon price monitoring
• Custom price drop alerts via email and Telegram
• Price history charts and trend analysis
• Wishlist import and bulk product tracking
• Daily digest with biggest price drops

Code sample

# Basic structure
class Bot:
    def __init__(self, config):
        self.config = config

    def run(self):
        while True:
            self.scan()
            self.execute()

If you want the full working version with all the battle-tested edge cases
handled, I packaged it here: Amazon Price Tracker

Happy to answer questions about the architecture in the comments.