Experimenting – Node.js and MySQL
Working with Node has been different though and npm is the biggest reason. Third party code dependency is a balancing act. Typically I avoid them, opting to use them as examples instead of forcing a peg into a square. But the idea of this was to get a prototype up with the least amount of effort, so I gave npm a shot and grabbed two frameworks…
I was up and running with my Express server in under 10 minutes. I would have expected much more effort.
My alpha prototype just needed a SQL backend. I’ve done enough with SQLite on mobile devices so I used it for my first go.
Once I downloaded MySQL Workbench, it was an easy decision to build on MySQL instead of SQLite.
I love stored procedures. Mixing SQL statements into other language code files has always made me cringe. Let the separation of layers work for you.
SQL is so powerful and database engines like SQLServer and MySQL use of Store Procedures allow you to encapsulate the syntax to exploit that power away from your C based algorithmic code.
I’m sure I’ll hit pitfalls, but this feels like a pretty solid technology stack.