How to pass dictionary to sqlite database?

Question

Python

Good evening everyone.
Have a dictionary:

inv = {"item1":0,
    "item6":0,
    "item8":4}

how to write this dictionary to the database:

await db.execute("""CREATE TABLE IF NOT EXISTS us (
            us TEXT, 
            id INT,
            invent INT,
            check INT
        )""")
       await db.execute("INSERT INTO us  VALUES (?, ?, ?, 0)", (member.name, member.id, inv))

Answer 1

Dictionary in SQL database, as far as I know, you can not shove, but you can shove a line.

import json
# Например так
a = json.dumps({"a": 1})

This function will create a string from the dictionary, and it can already be stored in the database.
To turn a string back into a dictionary, use json.loads([some string])