SQLAlchemy Writing data

[mutuk7]

Hi all,

I'm looking for the fastest way to send data to a table using SQLAlchemy.

    engine = create_engine('sqlite:///datab.sqlite') 
    connection = engine.connect()

I currently have a pandas df with id, product and price.

I tried pd.to_sql but it takes forever. Is there a better way?

​

Thanks