cursor.execute(
    """
    CREATE TABLE ip_address_associations (
        ip_address INTEGER PRIMARY KEY, 
        value TEXT
    )
"""
    )
How to convert an IP address to something 32 bit you can use as a dict key