
If you haven’t played around with Aurora Serverless yet, check out my post Aurora Serverless: The Good, the Bad and the Scalable. Virginia), US East (Ohio), US West (Oregon), Asia Pacific (Tokyo), and Europe (Ireland) Regions.
#Nodejs api aws postgresql update
Update May 31, 2019: Data API is available in US East (N. NOTE: The Data API only works with Aurora Serverless clusters AND it is only available in the us-east-1 region. Update May 31, 2019: The documentation has gotten much better and can walk you through the set up. The guide is pretty thin right now, so I’ll give you basics.
#Nodejs api aws postgresql how to
There is an AWS guide that tells you how to switch on the Data API. Enabling the Data APIīefore we dive into performance (honestly I want to avoid telling you about it for as long as possible), let’s look at the set up. I can see this being a complete #gamechanger once they iron out the kinks, so they definitely can benefit from constructive feedback from the community. And finally, I am a huge AWS fan (and I think they know that 😉), but this first version is really rough, so I’m not going to pull any punches here.

Second, AWS has a great track record with things like this, so I’m betting that this will get a heck of lot better before it reaches GA. First, the Data API is (still) in BETA, so this is definitely not the final product. Update May 31, 2019: The Data API is now GA (see here)īefore I go any further, I want to make sure that I clarify a few things.
#Nodejs api aws postgresql full
So AWS’s RDS via HTTP seems like the perfect solution, right? Well, not so fast. 😞 ( Update May 31, 2019: There have been a ton of improvements, so read the full post.) I even wrote an NPM package to help deal with the max_connections issue and the inevitable zombies 🧟♂️ roaming around your RDS cluster. Plus, connection management with serverless and RDBMS has been quite tricky. Think about all those cold start savings. The prospect of not needing to use VPCs with Lambda functions to access an RDS database is pretty compelling. Ya'll been waiting eagerly for this one! Access an Aurora Serverless database via HTTPS API: still in beta, but will change the way you think about #awsLambda and relational databases! #serverless As you can imagine, there was quite a bit of fanfare over this on Twitter. This has been a long awaited feature and has been at the top of many a person’s #awswishlist.

On Tuesday, November 20, 2018, AWS announced the release of the new Aurora Serverless Data API. I’ve updated this post to reflect the new changes/improvements. There have been a number of improvements (especially to the speed, security, and transaction handling). Update May 31, 2019: AWS has released an updated version of the Data API (see here). I call it the “ Data API Client“, and it’s available now on GitHub and NPM. I ended up writing a full-blown client library for it. Update June 4, 2019: After playing around with the updated Data API, I found myself writing a few wrappers to handle parameter formation, transaction management, and response formatting.

Any unused type fields will be removed, which makes the response size 80+% smaller. I am trying to connect to my postgresql DB I am using the pg library, my code looks like this const dbcreds = require("./dbconfig.json")Īwait pool.Update June 5, 2019: The Data API team has released another update that adds improvements to the JSON serialization of the responses.
