Integrate Cloud Firestore with mssql server

[Luis Cabrera]

I'm working with a client who has a CRM application with a mssql server database as the backend. We're building a mobile app using cloud firestore taking advantage of authentication, notifications, firestore database, storage etc. 

All the data for the app will be stored in firebase, however, we have a need to pull some data out of the mssql server database and display it on the app. I read about tedious js (https://github.com/tediousjs/tedious) and the possibility to access mssql server via node js. 

My question is: Is this doable in Firebase if I integrate Tediousjs as part of Firebase functions? Would it work?

Thanks,

Luis

[Samuel Stern]

If someone has more experience with that lib, please chime in.  From reading the README I think it would work because it says "Tedious is a pure-Javascript implementation of the TDS protocol".  Any 'pure javascript' library should work in Cloud Functions, so you should be able to pull the data from MySQL.  The only constraint here would be that even a maxed-out function can only run for 540s and use 2GB of RAM so make sure your workload fits those constraints.

- Sam

--
You received this message because you are subscribed to the Google Groups "Firebase Google Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebase-tal...@googlegroups.com.
To post to this group, send email to fireba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/firebase-talk/d38a9647-a300-4c86-a1a9-12d3de0c3837%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.