Can I use MySQL from AWS Lambda in Python?

Question

Is the MySQL connector for Python or some equivalent module available in a form I can zip up and included in an AWS Lambda function, or is that just asking for trouble? Apparently Lambda functions written in Node.js can use a builtin library to talk to MySQL on RDS, but I don't see an obvious way to do that in Python.

I wouldn't want to try to install something that takes a long time or requires any assumptions about the underlying operating system. On Windows at least, it's a whole separate installer.

Same question for Java: does this work out of the box, or are there machinations necessary to package a MySQL jar file?

dieend · Accepted Answer · 2016-07-15 05:42:07Z

1

If in some cases you need to uses native library (which mysql should have), you can uses pure python implementation using PyMySQL, and include it in the deployment package of lambda.

More detail on how to create deployment package for python is here https://docs.aws.amazon.com/lambda/latest/dg/lambda-python-how-to-create-deployment-package.html See the advanced version.

For java, I guess it will work out of the box as long as you include all dependency in jar.

answered Jul 15, 2016 at 5:42

dieend

2,3191 gold badge24 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jay Carlton · Accepted Answer · 2015-11-12 22:52:40Z

1

I think I got it. Being on Windows added some steps.

I got Python 2.7.10, which comes with Pip. I then installed mysql-connector-python using the trick here.

answered Nov 12, 2015 at 22:52

Jay Carlton

1,1781 gold badge11 silver badges27 bronze badges

Collectives™ on Stack Overflow

Can I use MySQL from AWS Lambda in Python?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related