Hi Everyone, How do I run mysql queries in solid? How do i establish mysql connection? should I have to use pymysql library or any other library?

Hi, I believe one can use SQLAlchemy

@Peter B how can I pass database parameters to establish mysql connection using resource?

Lookup psycopg2, and SQL alchemy, the documentation will help. Or, if you’d like to keep it simple, use Pandas’ ‘to_sql’ method, and use SQL alchemy to create the ‘engine’ off your database connection string first. See how you go, I’ll be on my computer tomorrow I can paste an example. Get Outlook for iOS