serverless-express VS node-mysql2

After building out a GPT powered endpoint, I wanted a low cost way of hosting it. At the time, I came across the serverless-express project https://github.com/vendia/serverless-express/tree/mainline, but no actual starter kits that would allow me to deploy it.

It’s all handled using https://github.com/vendia/serverless-express

Amplify gives an option of using a template and linking the API Endpoint with the Lambda and a connected DynamoDB table. I selected the template, Serverless Espress, which provided a lot of code in the template, though the majority of it felt overly bloated for what was effectively CRUD functionality.

With that in mind, the goal of this library is to be as lightweight as possible. There are other libraries out there that can handle express -> serverless mutation. See Serverless Express for that. If you want to rewrite as little code as possible, that is your best solution. With that being said, if the sole purpose of express is middleware and is only hosting a one-endpoint GraphQL server, I recommend rewriting to utilize this library.

To get Express to run on AWS Lambda the Node http stack needs to be emulated, or a full-blown HTTP/TCP server needs to be started and proxied to. Each of these workarounds require a ton of code from libraries like serverless-express.

Express is a framework/software. Lambda is compute. You can run express in Lambda. Ive done this and it was great. Check out https://github.com/vendia/serverless-express. The cool thing is that it's portable - you can build for one compute environment, and move it to another if it doesnt suit

Yea its fine use https://github.com/vendia/serverless-express since you are using express

Serverless Express - library that makes our "plain" NestJS API play nicely with Serverless

Some people like the Unix philosophy of "Do one thing and do it well" for Lambdas, others would build a monolithic app using a single Lambda with built in "routes". Both designs have pros and cons.

MySQL2, a MySQL driver for Node.js

I have done online searches already but didn't find anything conclusive. This github thread was inconclusive and is riddled with people complaining. This thread is shorter but also inconclusive. I've already increased the max_allowed_packet.

Hi I just found a ticket with this error in the mysql2 repo: https://github.com/sidorares/node-mysql2/issues/1885

You can see everything that is exported from the TypeScript declaration files such as the mysql2's index.d.ts where it lists that in fact, yes there is a export function createConnection

For those who have never used node-mysql2 is a package to integrate MySQL with NodeJS (see here for more information about MySQL and its features).

I've been using https://github.com/sidorares/node-mysql2 in a couple of sites in production, gives me the two main things I need, named parameters and async compatible. Not a big fan of ORMs as invariably you'll have to do a query that doesn't fit into the paradigm and you'll spend fruitless hours trying to coerce it to do what you want.

Looks like you've added an issue to github -- https://github.com/sidorares/node-mysql2/issues/1370 -- getting a simple repro to the package maintainers is probably the best way to approach this.

You should consider using prepared statements which make the issue you’re asking about, as well as much more serious issues with your example, easily resolved: