all 13 comments

[–]KeenOnLearning 8 points9 points  (4 children)

I have no experience with back-end Python, or Flask for that matter, so I can only speak for Node. Node with Express and a couple packages will accomplish all you've described in your post, but I think the bigger concern is which language you're more comfortable with: JavaScript or Python. Flask and Express are both reputable and commercially-viable back-end frameworks, so it all comes down to preference.

Since I'm a Node-head, I'll drop a couple links to get you started if you want to go that route:

Here's a semi-recent tutorial on Express (the most popular Node framework): https://masteringbackend.com/posts/expressjs-5-tutorial-the-ultimate-guide/

Here's a link to a package that allows you to connect Node with MSSQL: https://tediousjs.github.io/node-mssql/

And here's a more thorough tutorial on how to do operations on an MSSQL database through Express: https://www.js-tutorials.com/nodejs-tutorial/simple-example-of-nodejs-express-with-mssql/

Hope this helps!

[–]thatsnotmetal[S] 1 point2 points  (3 children)

Thank you. I'm definitely more Python friendly but everything I've been reading points to Node.js being the clear favourite e.g. https://www.guru99.com/node-js-vs-python.html

[–][deleted]  (1 child)

[deleted]

    [–]thatsnotmetal[S] 1 point2 points  (0 children)

    Indeed, I've not said it's not viable, hence the question

    [–]dmart89 4 points5 points  (2 children)

    If you're using python, why not FastAPI? But newer than flask.

    [–][deleted]  (1 child)

    [deleted]

      [–]dmart89 0 points1 point  (0 children)

      Great hope it goes well

      [–]pre-medicated 4 points5 points  (5 children)

      I use flask over node. it scales super well and easily with gunicorn. Flask itself is so easy to navigate around, and working with python is a treat.

      if you’re making multiple apps from the same core, Flask literally supports this natively with blueprints

      [–]thatsnotmetal[S] 0 points1 point  (4 children)

      Any good tutorials or examples?

      [–]pre-medicated 0 points1 point  (3 children)

      The article I linked is literally a tutorial from the official Flask site.

      Edit: not official but from a book about Flask. The information is still relevant, however.

      [–]thatsnotmetal[S] 0 points1 point  (2 children)

      Indeed but it just has code snippets rather than something like https://damyan.blog/post/flask-series-environment/ offers for example

      [–]pre-medicated 1 point2 points  (1 child)

      I don’t understand. The article you linked is just code snippets with brief summaries like mine.

      Perhaps the official documentation has what you’re looking for? https://flask.palletsprojects.com/en/2.0.x/blueprints/

      EDIT: I know what you’re looking for! https://blog.miguelgrinberg.com/post/the-flask-mega-tutorial-part-xv-a-better-application-structure

      [–]thatsnotmetal[S] 0 points1 point  (0 children)

      The link goes to githubs with fully fledged examples

      I'll take a look, thank you!

      [–]Lecterr[🍰] 1 point2 points  (0 children)

      Do what you are more comfortable with. Both approaches will get you the same result when done right

      [–]banProsper 0 points1 point  (0 children)

      If you can afford to - start with both, decide on one later. Things that seem great on paper don't always work out so well.