How to Query RDS MySQL From AWS Lambda in Python | Step by Step Tutorial

    46
    22



    Trying to connect to RDS from a Lambda function but having Trouble? This is the video for you.

    Part 1 – Create a RDS MySQL Database – https://youtu.be/Ng_zi11N4_c

    02:11 Installing Pymysql
    03:00 Writing our Lambda Handler Function with Python
    07:45 Preparing your handler and dependencies for Lambda
    08:26 Creating our Lambda Function
    10:43 Testing our Function

    🎉 SUPPORT BE A BETTER DEV 🎉
    Become a Patron: https://www.patreon.com/beabetterdev

    📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚
    Clean Code – https://amzn.to/37T7xdP
    Clean Architecture – https://amzn.to/3sCEGCe
    Head First Design Patterns – https://amzn.to/37WXAMy
    Domain Driver Design – https://amzn.to/3aWSW2W
    Code Complete – https://amzn.to/3ksQDrB
    The Pragmatic Programmer – https://amzn.to/3uH4kaQ
    Algorithms – https://amzn.to/3syvyP5
    Working Effectively with Legacy Code – https://amzn.to/3kvMza7
    Refactoring – https://amzn.to/3r6FQ8U

    🎙 MY RECORDING EQUIPMENT 🎙
    Shure SM58 Microphone – https://amzn.to/3r5Hrf9
    Behringer UM2 Audio Interface – https://amzn.to/2MuEllM
    XLR Cable – https://amzn.to/3uGyZFx
    Acoustic Sound Absorbing Foam Panels – https://amzn.to/3ktIrY6
    Desk Microphone Mount – https://amzn.to/3qXMVIO
    Logitech C920s Webcam – https://amzn.to/303zGu9
    Fujilm XS10 Camera – https://amzn.to/3uGa30E
    Fujifilm XF 35mm F2 Lens – https://amzn.to/3rentPe
    Neewer 2 Piece Studio Lights – https://amzn.to/3uyoa8p

    💻 MY DESKTOP EQUIPMENT 💻
    Dell 34 inch Ultrawide Monitor – https://amzn.to/2NJwph6
    Autonomous ErgoChair 2 – https://bit.ly/2YzomEm
    Autonomous SmartDesk 2 Standing Desk – https://bit.ly/2YzomEm
    MX Master 3 Productivity Mouse – https://amzn.to/3aYwKVZ
    Das Keyboard Prime 13 MX Brown Mechanical- https://amzn.to/3uH6VBF
    Veikk A15 Drawing Tablet – https://amzn.to/3uBRWsN

    📚 References:
    Part 1 – How to connect to AWS RDS MySQL: https://youtu.be/Ng_zi11N4_c
    Getting started with AWS: https://youtu.be/lTyqzyk86f8
    Code: https://pastebin.com/X0Yq9t0S

    ☁Topics covered include:
    RDS MySQL Connection
    Lambda RDS IAM Permissions
    Pymysql for Querying RDS MySQL

    🌎 Find me here:
    Twitter – https://twitter.com/BeABetterDevv
    Instagram – https://www.instagram.com/beabetterdevv/
    Patreon – Donations help fund additional content – https://www.patreon.com/beabetterdev

    #AWS
    #Serverless
    #RDS
    #MySQL

    source

    Previous articleEvery Millionaire Knows These Simple Things… Do You? RSD Maze
    Next articleAWS Lambda Tutorial | Beginners to Advanced | Lambda Functions Tutorial