Welcome Guest, Not a member yet? Register   Sign In
nodejs tips and tricks
#25

(09-20-2018, 10:26 AM)skunkbad Wrote:
(09-20-2018, 09:25 AM)ignitedcms Wrote: Mysql findings

Holy crap guys, you don't know how complicated it is to return a full mysql result string to a view file!

Because nodejs / hapijs is asynchronous (meaning it does not necessarily execute in order e.g mysql fetches and file reading) you can't easily return the result of a mysql query save it into a variable and dump it to a view. This is a complete mind f*** for anyone not used to asynchronous coding. I will investigate this further. Woah this is difficult.

I believe the answer is to use async and await. . . Arrrgh.

Or use promises and Promise.all()

Interesting, I came across these two and it looks good, I'm going to run a few tests today.

https://github.com/Will-I4M/node-mysql-libmysqlclient

https://www.npmjs.com/package/promise-mysql

I'll let you know my findings.
Practical guide to IgnitedCMS - Book coming soon, www.ignitedcms.com
Reply


Messages In This Thread
nodejs tips and tricks - by ignitedcms - 09-10-2018, 12:42 PM
RE: nodejs tips and tricks - by ciadmin - 09-10-2018, 12:52 PM
RE: nodejs tips and tricks - by ignitedcms - 09-10-2018, 12:55 PM
RE: nodejs tips and tricks - by ciadmin - 09-10-2018, 01:03 PM
RE: nodejs tips and tricks - by ignitedcms - 09-10-2018, 01:05 PM
RE: nodejs tips and tricks - by ignitedcms - 09-10-2018, 01:13 PM
RE: nodejs tips and tricks - by donpwinston - 09-10-2018, 05:42 PM
RE: nodejs tips and tricks - by ignitedcms - 09-10-2018, 10:39 PM
RE: nodejs tips and tricks - by skunkbad - 09-12-2018, 01:08 AM
RE: nodejs tips and tricks - by ignitedcms - 09-12-2018, 03:04 AM
RE: nodejs tips and tricks - by skunkbad - 09-12-2018, 07:54 AM
RE: nodejs tips and tricks - by ignitedcms - 09-12-2018, 10:40 AM
RE: nodejs tips and tricks - by ignitedcms - 09-12-2018, 10:45 AM
RE: nodejs tips and tricks - by ignitedcms - 09-17-2018, 02:20 PM
RE: nodejs tips and tricks - by skunkbad - 09-17-2018, 03:44 PM
RE: nodejs tips and tricks - by ignitedcms - 09-17-2018, 08:52 PM
RE: nodejs tips and tricks - by ignitedcms - 09-18-2018, 06:38 AM
RE: nodejs tips and tricks - by ignitedcms - 09-18-2018, 11:42 AM
RE: nodejs tips and tricks - by skunkbad - 09-18-2018, 02:05 PM
RE: nodejs tips and tricks - by ignitedcms - 09-18-2018, 10:14 PM
RE: nodejs tips and tricks - by ignitedcms - 09-19-2018, 11:55 AM
RE: nodejs tips and tricks - by ignitedcms - 09-20-2018, 03:48 AM
RE: nodejs tips and tricks - by ignitedcms - 09-20-2018, 09:25 AM
RE: nodejs tips and tricks - by skunkbad - 09-20-2018, 10:26 AM
RE: nodejs tips and tricks - by ignitedcms - 09-20-2018, 11:07 AM
RE: nodejs tips and tricks - by ignitedcms - 09-20-2018, 11:45 AM
RE: nodejs tips and tricks - by ignitedcms - 09-21-2018, 09:21 AM
RE: nodejs tips and tricks - by ignitedcms - 09-21-2018, 03:55 PM
RE: nodejs tips and tricks - by ignitedcms - 09-21-2018, 06:37 PM
RE: nodejs tips and tricks - by skunkbad - 09-21-2018, 11:07 PM
RE: nodejs tips and tricks - by ignitedcms - 09-21-2018, 11:31 PM
RE: nodejs tips and tricks - by skunkbad - 09-22-2018, 07:00 AM
RE: nodejs tips and tricks - by ignitedcms - 09-23-2018, 10:17 AM
RE: nodejs tips and tricks - by ignitedcms - 09-24-2018, 10:44 AM
RE: nodejs tips and tricks - by ignitedcms - 09-25-2018, 05:09 AM
RE: nodejs tips and tricks - by ignitedcms - 09-25-2018, 05:18 AM
RE: nodejs tips and tricks - by ignitedcms - 09-25-2018, 12:38 PM
RE: nodejs tips and tricks - by ignitedcms - 09-26-2018, 11:58 AM
RE: nodejs tips and tricks - by dave friend - 09-27-2018, 07:37 AM
RE: nodejs tips and tricks - by ignitedcms - 09-27-2018, 09:16 AM
RE: nodejs tips and tricks - by ignitedcms - 09-28-2018, 10:09 AM
RE: nodejs tips and tricks - by ignitedcms - 09-28-2018, 11:48 PM
RE: nodejs tips and tricks - by ignitedcms - 09-30-2018, 08:52 PM



Theme © iAndrew 2016 - Forum software by © MyBB