# Julia Script running with SQL datas

**URL:** <https://discourse.julialang.org/t/julia-script-running-with-sql-datas/8566>\
**Category:** Web Stack\
**Created:** [January 24, 2018, 4:56pm UTC](https://discourse.julialang.org/t/julia-script-running-with-sql-datas/8566 "2018-01-24T16:56:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![fenosoa](https://avatars.discourse-cdn.com/v4/letter/f/f14d63/32.png) [@fenosoa](https://discourse.julialang.org/u/fenosoa)\
**Post date:** [January 24, 2018, 4:56pm UTC](https://discourse.julialang.org/t/julia-script-running-with-sql-datas/8566/1 "2018-01-24T16:56:37Z")

</div>

Hi,

I’m currently working on a web app for a college. In this app, students have to rank a list of classes (front in React). Datas and rankings are send to a Node.js - MySQL - Sequelize backend, and we found a .jl algorithm that maximize students’ satisfaction.

We want to add a route in the backend and run the algorithm when all the students sent their choices. How can we do that?

Thank you in advance !

---

<div class="post-metadata">

**Author:** ![avik](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/avik/32/17_2.png) [@avik](https://discourse.julialang.org/u/avik)\
**Post date:** [January 24, 2018, 5:10pm UTC](https://discourse.julialang.org/t/julia-script-running-with-sql-datas/8566/2 "2018-01-24T17:10:59Z")

</div>

Write the data out to a csv file, and shell out to julia from your NodeJS application? Might be the simplest way to do this.

---

<div class="post-metadata">

**Author:** ![iblis17](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/iblis17/32/649_2.png) [@iblis17](https://discourse.julialang.org/u/iblis17)\
**Post date:** [January 24, 2018, 6:08pm UTC](https://discourse.julialang.org/t/julia-script-running-with-sql-datas/8566/3 "2018-01-24T18:08:09Z")

</div>

Maybe HTTP.jl can create a algorithm server for you.

---

<div class="post-metadata">

**Author:** ![fenosoa](https://avatars.discourse-cdn.com/v4/letter/f/f14d63/32.png) [@fenosoa](https://discourse.julialang.org/u/fenosoa)\
**Post date:** [January 24, 2018, 10:22pm UTC](https://discourse.julialang.org/t/julia-script-running-with-sql-datas/8566/4 "2018-01-24T22:22:43Z")

</div>

Problem with HTTP.jl is that it’s not ready for production…

---

<div class="post-metadata">

**Author:** ![fenosoa](https://avatars.discourse-cdn.com/v4/letter/f/f14d63/32.png) [@fenosoa](https://discourse.julialang.org/u/fenosoa)\
**Post date:** [January 24, 2018, 10:22pm UTC](https://discourse.julialang.org/t/julia-script-running-with-sql-datas/8566/5 "2018-01-24T22:22:46Z")

</div>

How do you do this? With [shelljs](https://github.com/shelljs/shelljs)?

---

<div class="post-metadata">

**Author:** ![avik](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/avik/32/17_2.png) [@avik](https://discourse.julialang.org/u/avik)\
**Post date:** [January 24, 2018, 10:44pm UTC](https://discourse.julialang.org/t/julia-script-running-with-sql-datas/8566/6 "2018-01-24T22:44:35Z")

</div>

No, [Child process | Node.js v18.8.0 Documentation](https://nodejs.org/api/child_process.html#child_process_child_process)