Is node-mysql now defunct post mySQL 8.0?

[David Byrne]

I'm trying to find out whether there's any future in the NodeJS/mySQL combination post version 8.0 of mySQL?

node-mysql doesn't work with the new authentication without hacky workarounds that I'm not prepared to compromise the security of my database for.  (Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client)

I've seen suggestions to use node-mysql2 but TBH that's equally bad as it doesn't work asynchronously in any usable fashion. As an example, I have a PHP program that reads a single config record from a mySQL table and then loops around the rows of a second table. There's about 10k lines of processing code involved, and the callback hell that Node enforces probably means that it's just the wrong tool for the job.

Trying to investigate all options before making a significant investment in new product development, all ideas and suggestions gratefully received.

David

[Douglas Christopher Wilson]

Hi David, sorry to hear that. Can you sharw what version of MySQL 8 you are running and what auth mode is configured on your server?

--
You received this message because you are subscribed to the Google Groups "node-mysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to node-mysql+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/node-mysql/542538ac-df2a-4c21-a4b0-46d21738f5cbn%40googlegroups.com.

[András Székely]

I’m using MongoDB… very efficient and dynamic! I was using it some years ago for some new projects and had fantastic results. Also on speed and effectiveness. I would recommend to you to try this out ! 

--

You received this message because you are subscribed to the Google Groups "node-mysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to node-mysql+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/node-mysql/542538ac-df2a-4c21-a4b0-46d21738f5cbn%40googlegroups.com.

--

A Gmail mobilalkalmazásból elküldve