Am I following best practices for express app with mysql database?

• Knex

  95 18,789 7.9 JavaScript

  A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

  

Also, but that's just me, I would at least use a query builder like Knex to avoid having to write sql in code (if not using an ORM but that might be an overkill depending on what you've got to do).

• Koa

  71 34,875 6.0 JavaScript

  Expressive middleware for node.js using ES2017 async functions

  

Speaking of which... there's a long-standing issue with express when it comes to async route handlers. There's backstory to this is complicated and controversial, but the tl;dr: is that (in my humble, and very controversial, opinion) you can use express-async-errors as a workaround hack for legacy projects, but if you're starting a new project you should avoid Express and switch to Koa instead.

• SurveyJS

  surveyjs.io featured

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

Suggest a related project