Macos Node Wathc File For Cahnges

In this section you will create three simple Node.js apps. One of them will just connect to the database, the second will perform basic Insert, Update, Delete, and Select, and the third one will make use of Sequelize, one of the most popular Node.js Object-relational mappers, to execute the same operations.

Step 2.1 Create a Node.js app that connects to SQL Server and executes queries

If you read one of my earlier posts on how to install Node.js, you probably noticed there are quite a few ways to install it on your computer.This could be from a package manager, from the source code, or from a pre-compiled binary distribution.

Create a new project directory and initialize Node dependencies.

Create a database that will be used for the rest of this tutorial by connecting to SQL Server using sqlcmd and executing the following statement.

Now you will create a simple Node.js app that connects to SQL Server.

Using your favorite editor, create a file named connect.js in the SqlServerSample folder. Copy and paste the below contents into the file.

Run the application.

Using your favorite text editor, create a file called CreateTestData.sql in the SqlServerSample folder. Copy and paste the following the T-SQL code inside it. This will create a schema, table, and insert a few rows.

Connect to the database using sqlcmd and run the SQL script to create the schema, table, and insert some rows.

Using your favorite text editor, create a new file called crud.js in the SqlServerSample folder. Copy and paste the following code inside it. This will insert, update, delete, and read a few rows.

Run the crud.js app to see the results

Step 2.2 Create a Node.js app that connects to SQL Server using the popular Sequelize ORM

Create the app directory and initialize Node dependencies.

  1. Open your favourite text editor and create the file orm.js in the directory SqlServerSequelizeSample.
  2. Paste the contents below into orm.js
  3. Update the variable for password to use your own password specified in the first module.
  4. Save and close orm.js

Run the orm.js app

Congratulations! You created your first two Node.js apps with SQL Server! Check out the next section to learn about how you can make your Node.js apps faster with SQL Server’s Columnstore feature

JavaScript packaged by npm for the win!

  • Different editions
  • Verify Install
  • Node Versions Installed
  • NVM
  • Install node and .npm-packages without npm
  • Install Node packages
  • Code Node JavaScript
  • Bower Install of GUI apps
  • Node modules

The objective of this tutorial is to spare you the pain and confusionaround installing, updating, and uninstalling the various editions and versions of Node (aka NodeJs, with Js for JavaScript).

Why Node?

Popularity is manifested in the number of new modules being contributed.And Node is fast. It’s portable. What’s not to like?

Different editions

Installing Node has become complex due to the drama behinddifferent editions and versions of Node withdifferent mechanisms for managing updates,each with permissions issues.

For these reasons, many instructions on the internet are outdated, contradictory, or plain wrong.

Node.js was started as an open-source project in 2009 byRyan Dahl.Its second contributor was Isaac Schlueter who now leads the project.The project had a total of 447 core contributors as of 2016. Dahl was employed by Joyent.comduring much of Node’s development, and Joyent continues to sponsor Node. Joyent has raised in the neighborhood of $100 million in venture capital and has an employee headcount in excess of 120.Joyent as a cloud computing company was purchased in 2015 by Samsung (Korea).

Long Term Support

Long Term Support releases, introduced Fall, 2015, are actively developed for 18 months,then maintained for a further 12 months. This means a particular LTS release stays in production for 30 monthswith bug and security fixes.

PROTIP: Odd numbered versions are not destined for active status, unstable development versions.

Macos Node Watch File For Changes 2016

There are two versions active at the same time.

N|Solid

N|Solid from NodeSource is a “fully compatible Node.js runtime enhanced to address the needs of enterprise production support.”

Their disto provides a GUI and a way to pull telemetry for V8 process monitoring.

Again, this is a licensed product. I’ve heard that they provide support at $1,000 per developer per month ($12,000 per year).

StrongLoop to IBM

A VentureBeat article in 2013 writes “Two programmers named Ben Noordhuis and Bert Belder have founded a new company called StrongLoop. And they’re apparently attempting to hijack the Node brand and community for themselves.”Strongloop supports Express and LoopBack frameworks.On 10 Sep 2015, StrongLoop was acquired as IBM API Connect, which focuses on the API lifecycle.

io.js is gone

In 2013 iojs.org, a fork of Node.js was formed by several core committers frustrated by Joyant.

Then on September, 2015, io.js merged with the Node.js project againunder new nodejs.org/en/foundation governance.

Which version of what?

QUESTION: What are the install instructions If you’re an enterprise user paying for LTS?

Instead of using an internet browser to download an installer from
https://nodejs.org/en/download/releases/
consider these:

  • nvm (node version manager) is a shell function that downloads and upgrades versions of node.js. It’s not needed unless you want to keep and upgrade multiple versions of Node.js. But you will eventually will need to.

  • npm (node package manager) installs JavasSript packages such as Express.js.

Ideally, we would have both nvm and npm on the same machine, each configured the way we want for maximum productivity.

However, there is a conflict between the ideal way of installing npm with how nvm works.

The ideal way to install most applications is to NOT need to use the sudo prefix command to temporarily elevate permissions.

On a Mac, by default, npm is installed in the .npm folder.

To make it work, we install it in the .npm-packages folder by placing a configuration setting.

However, nvm does not recognize that configuration setting and thus only works with plugins installed in the default .npm folder.

Yes, why can’t people from nvm and npm get together and work things out?

Thus, a choice needs to be made.

Choose among alternatives

Click on one of the mutually exclusivevariations of installing Node foradditional information and instructions:

  • A: Brew install node WITHOUT npm, then install .npm-packages with no nvm.

    This is what I recommend after hassling with yarn installation.

  • B: “N” from github.com/tj/n

    “Node.js version management: no subshells, no profile setup, no convoluted API, just simple.”

    http://theholmesoffice.com/node-js-fundamentals-how-to-upgrade-the-node-js-version/

  • C: Install NVM, then install Node using NVM.

    Installing Node automatically installs NPM.

    • https://docs.npmjs.com/getting-started/fixing-npm-permissions
  • D: Download LTS (Long Term Support) v4.x from NodeJs website and run the installer manually.

  • E: Download latest version v6.x from NodeJs website and run the installer manually.

  • F: Download latest version of N|Solid.

    CAUTION: Even though pricing for NodeSource is NOT published on the website doesn’t mean it’s free. I’ve heard pricing for both Joyant and NodeSource start at around $1,000 per month per developer.

Verify Install

Macos Node Watch File For Changes 2016

These instructions are used when both verifying a new setup and when obtaining facts when troubleshooting an established setup.

Return here after installation.

PROTIP: Before you speak to someone about this, provide them your operating system facts, obtained using instructions here:

  1. Operating system information:

    uname -a

    On my machine, the response:

  2. Obtain node version:

    node -v

    At time of writing, the response for the most recent version:

  3. Obtain npm version:

    npm -v

    At time of writing, the response (for the Node version obtained above):

  4. Verify:

    echo $NODE_PATH

    The response if installed by NVM or by downloaded installer:

    The response if installed using brew:

    Regardless of how you installed node,before discussing your installation, obtain and present the facts above.

  5. From any folder, for just a simple list of package names:

    ls `npm root -g`

    PROTIP: npm itself is a Node package.

    Alternately, list global npm packages installed as a tree:

    npm list -g --depth=0

    The response is a list with version numbers:

    Note the first line in the response shows the folder.

  6. List what modules are installed in the traditional location for Node:

    ls /usr/local/lib/node_modules

    • bower
    • firebase-tools
    • generator-karma
    • grunt
    • grunt-cli
    • http-server
    • gatsby
    • iothub-explorer
    • mocha
    • yo
    • traceur
    • serverless
    • npm

    QUESTION: When Node is installed using Homebrew,same location?

    Does node REPL work?

  7. Initialize the Node command-line:

    node

    The response is simply a > character.

  8. Type this command:

    console.log(‘Node is running’);

    The response should reflect what is in the command.

  9. From inside REPL, get a list of commands (with a leading dot):

    .help

    PROTIP: Node interactive commands begin with a dot.

    The response:

  10. To get out gracefully:

    .exit

    Alternately, you can (crudely) press control+C to abort the process.

Node Versions Installed

Traditionally, NVM (Node Version Manager) installs multiple versions of Node.

Macos
  1. List what versions of Node are installed:

    nvm ls

    Sample response:

    PROTIP: Most don’t need multiple versions of Node at once.

    PROTIP: Using NVM conflicts with Homebrew.Since many prefer to use Homebrew for everything else,it’s annoying to remember such exceptions.

    NPM Packages

    The installer of Node also installs NPM (Node Package Manager)which manages installation of Node packages.

  2. List what versions of NPM are available for install from the internet:

    nvm ls-remote

    At time of this writing, there were 376 versions.

  3. List what modules are available for install from the internet:

    nvm

  4. List files in the traditional location when NPM installs Node packages:

    ls ~/.npm

    Also:

    ls /usr/local/lib/node_modules/npm/node_modules

    On Windows:

    Examples:

    • semver
    • xml
    • y18n

NVM

NVM (Node Version Manager) downloads and installs multiple versions of Node.js,then enables using a specific version of Node,using a command such as this (after installation and cd to your node app folder):

nvm run 4.5.0 app.js

The above is for the LTS (Long Term Support) version.

If instead you want to run the latest versions of Node:

PROTIP: Remember that there is no “v” to specify a version, unlike the install command:

nvm install v4.5.0

To do the above, you first have to install NVM and Node, described in the steps below.

NVM Install

Installation steps:

  1. PROTIP: Use an iternet browser to read the README.md at https://github.com/creationix/nvm

  2. Note the version of installer:

  3. If you’ve installed another way before,make sure that if you have an ~/.npmrc file, it does not contain any prefix settings (which is not compatible with nvm):

    atom ~/.npmrc

    An example:

    PROTIP: This file is used by “Option A” above, thus the mutually exclusive options.

  4. Install C++ Compiler.

    NVM uses a C++ compiler installedwith Apple’s stand-alone Command Line Tools also within Apple’s XCode application.

    The README at https://github.com/creationix/nvm notes that it uses a C++ compiler installedwith Apple’s stand-alone Command Line Tools also within Apple’s XCode application.

  5. Agree to Apple’s license:

    sudo xcodebuild -license

    Type in your root password, hold down Enter until it stops, then type agree and Enter.

  6. Install NVM using wget:

    wget -qO- https://raw.githubusercontent.com/creationix/nvm/v0.31.6/install.sh | bash

    PROTIP: The instructions say either curl or wget, but I prefer using wget because it is not installed by default,and nvm requires it. So if you don’t have wget, better to know it sooner than later.

    The command installs to hidden folder ~/.nvm andlooks into the ~/.bashrc file used by Linux machines.More on this soon.

    The response:

    If you see this instead:

    CAUTION: NVM does not recognize the PREFIX used in the Alternate folder technique.So we would need to live with just elevated permissions.

    What the above does is equivalent to:

    cd ~
    git clone http://github.com/creationix/nvm.git .nvm

    So the command above is what some recommend to fix issues with nvm install.

  7. Verify:

    nvm --version

    If you get a version code such as the below (25 August 2016), proceed to use NVM.

    TROUBLESHOOTING: If instead of the version code, this message appears:

  8. Edit the file that Mac uses to initiate Terminal,using atom or other editor (vi, nano, etc.)

    subl ~/.bash_profile

    Add to the bottom of the file:

    ## Export the NVM path and run its shell:
    export NVM_DIR=”$HOME/.nvm”
    [ -s “$NVM_DIR/nvm.sh” ] && . “$NVM_DIR/nvm.sh” # This loads nvm

  9. Restart Terminal so it takes:

    source ~/.bash_profile

  10. To verify that nvm has been installed:

    command -v nvm

    NOTE: nvm is a shell script, not an executable, so the usualy where command does not work.

    The response should be:

  11. To verify that nvm has been installed:

    echo $NVM_DIR

    The response should be (where “mac” is substituted with your own user id):

  12. For a list of commands, type nvm by itself:

    nvm

    PROTIP: Widen the screen to avoid text wrapping.

    Upgrade NVM

  13. To download, compile, and install the latest v5.0.x release of node:

    nvm install

    The response:

    Use NVM to install Node

  14. To list what versions of Node.js are installed:

    nvm ls

    The response is like this:

    Available to install

  15. To list what versions of Node.js are available to install:

    nvm ls-remote

    Scroll to “(Latest LTS: Argon)”, such as:

    It’s installed by these instructions.

    The latest version is at the bottom of the list, such as:

    Clear NPM Cache

    Install latest version

  16. Install the latest version of Node.js:

    nvm install node

    The response:

    Notice that there is specific version of npm to support each version of Node.

    TROUBLESHOOTING:If these message also appear:

    As this advises,get rid of those messages on the Mac by going to Terminal > Preferences > Advanced tabto uncheck “Set locale environment variables on startup”:


    Exit Terminal to activate it or you’ll see the message again.

    Uninstall Node version

    Installing does not automatically uninstall previous versions.

  17. To uninstall a version:

    nvm uninstall v6.4.0

    The response:

  18. Install the most recent LTS version of Node according to nvm ls-remote:

    nvm install v4.5.0

  19. Verify install.

Install node and .npm-packages without npm

Ths recommended byAdvice on fixing npm On Mac OS X for Homebrew Users

Uninstall default Brew install

  1. If node was previously installed, uninstall it:

    No damage is done if this command is run even though brew is already uninstalled.

  2. If node was previously installed,these folders have been known to block re-install,so remove them by using the code below:

    Supply your password when prompted.

  3. Remove locations where Node can be installed:

    Create .npm-packages folder

  4. Create the ~/.npm-packages folder:

    mkdir “${HOME}/.npm-packages”

  5. To avoid permission issues:

    Provide your password when prompted.

  6. Indicate to npm where to store globally installed packagesby adding a line at the bottom of the ~/.npmrc file:

    echo prefix=~/.npm-packages » ~/.npmrc

    WARNING: NVM does not support this, which is OK since we are doing this to get awayfrom using it anyway.

  7. Confirm:

    cat ~/.npmrc

  8. Install node without default NPM:

    brew install node --without-npm -g

    Alternately, install npm for global use:

    The response:

  9. If you also get this message:

    Define NODE_PATH

  10. Edit the ~/.bash_profile to insert these lines:

    BTW, ~/.bash_profile on Mac is equivalent to the .bashrc file used in Linux systems.

  11. To ensure npm will find installed binaries and man pages,add a NPM_PACKAGES environment variable containing the path to npm-installed packagesinto the system PATH variable:

    Use of ${HOME} makes the path more generic and less complicatedthan having to substitute your user name such as “mac”:

  12. Save the file and make sure the changes run fine:

    source ~/.bash_profile

  13. Make sure that the Mac’s executable search PATH contains the node executable is in the PATH:

    echo $PATH

    If not add it to the system PATH:

    Verify Node Version

    After install,

  14. verify whether the node program works:

    node --version

    The response should be its version, such as:

  15. To identify where node executables are installed:

    which node

    the response:

  16. See that Node is one among many other programs at:

    ls /usr/local/bin | grep node

BTW, an alternative to NVM is “N” from https://github.com/tj/n.However, I never got it to work for me.

Brew standard install

  1. If you have already followed instructions at my Homebrew installation tutorialto install Homebrew:

    Click here if you want to go straight to the recommended option B.

    WARNING: Homebrew installs Node to a different location than other ways.

  2. Be aware of your present current directory:

    pwd

    CAUTION: Without specifying the -g in the next command, installation is whatever is the current folder.

  3. Install node globally using Homebrew:

    brew install node -g

    The initial response at time of writing (August 2017):

    PROTIP: Homebrew downloads installers to ~/Library/Caches/Homebrew/and looks for installers there to avoid downloading again.

    PROTIP: Notice the bottle is specific to the version on your operating system(such as “sierra”).

    You should now see something like this:

  4. If you get this error message between the two messages above:

    Run the command.

  5. If you get this error message between the two messages above:

    Following the advice above:

    brew link node

    If you see this:

    NOTE: By default, when node is installed, it installsnpm, the Node Package Manager,a node package to install additional packages.

  6. Identify which folder npm is obtained:

    which npm

    The response for default installations:

    Alternatively:

  7. List npm global modules installed on the default global module folder:

    ls /usr/local/lib/node_modules

    The response contains npm plusfirebase-tools, http-server, gatsby, iothub-explorer, serverless

C: Download and Install Manually

  1. Download installer from http://nodejs.org
  2. Use the Mac Finder to navigate to the file in your Downloads folder.
  3. Unzip the file downloaded.
  4. Execute the file.
  5. Respond to the prompts.
  6. Skip to Verify the install

Install Node packages

  1. The current global location:

    npm config get prefix

    The answer (where “mac” is substituted with your user name):

    See https://www.sitepoint.com/beginners-guide-node-package-managerabout global vs. local package install.

  2. The command to install a package without additional parameters is, for example:

pwd
npm install serverless

This installs the node packages locally within whatever folder is the present working directory, revealed by the pwd command.

However, we usually need node packages to be installed globally for access from any present directory by any user on the machine.

This location is one MacOS requires sudo (super user do) permission elevation. For example:

sudo npm install serverless -g

Without sudo, an error would occur from the above command such as:

This is because the default npm folder is managed at the system level, not user level.

To avoid these permission issues, some recommend higher permissions to folders, as in:

sudo chown -R $USER:$GROUP ~/.npm
sudo chown -R $USER:$GROUP ~/.config

This may not be enough to address installation issues when using Homebrew such as when upgrading with command:

npm update npm -g

Alternate folder

We can install the folder under a user’s HOME folder, which is defined by the ${HOME} environment variable:

echo “${HOME}”

The alternative npm folder name established by convention is:

ls ~/.npm-packages

To achieve this, we first need to uninstall the default install:

rm -rf /usr/local/lib/node_modules
brew uninstall node

All of Node needs to be uninstalled because it installed npm which uses the system folder.

To install node for global use, we can invoke

Macos Node Wathc File For Cahnges

Code Node JavaScript

To enable publication on NPM and Bower,packages such as Datatables containextensions and styling options in well defined CommonJS and AMD loaders.This also opens options to use other tools such as Browserify and WebJars.

Others who have blogged about this include:

  • http://quickleft.com/blog/getting-started-with-express-in-node
  1. Make a folder containing Node application files, and go to it:

  2. Install the express package and its dependencies:

    npm install express -g

  3. Use a text editor to create file index.js containing “Hello World” code in JavaScript:

    NOTE: Semicolons and carriage returns serve the same purpose in JavaScript. You only need semicolons if you are concatenating code together in a single line.

    See https://www.airpair.com/javascript/posts/eleven-mistakes-developers-javascript

  4. Start the Node server running the default index.js program:

    node index.js

    The window remains open and accept no other commandsuntil you press control+C to escape the process.

  5. Switch to an internet browser to open the Node Express web server running locally at port 3000:

    If you get “TypeError: res.json is not a function” …

    Nodemon

  6. See https://github.com/remy/nodemon

  7. Install NodeMon:

    npm install nodemon -g # -g installs globally as system command.
    nodemon index.js # watch for changes and kill server when needed

  8. Restart your node server specified in a coffee-script:

    nodemon server.coffee

Bower Install of GUI apps

Bower is similar to NPM, but for front-end GUI applications.

Any frameworks or 3rd-party libraries that need to be accessible in the user’s browserwill be managed by bower.

Similarly to NPM, bower tracks dependencies in a file called bower.json.

Macos Node Wathc File For Cahnges
  1. Install bower globally via npm:

    npm install -g bower

    Running bower install will resolve, download, and install them.

    Project Bower Install

  2. cd to the project’s folder.

  3. Install the project’s bower components using bower:

    bower install

  4. Install http-server using npm:

    npm install -g http-server

  5. Fire up the server at default port 8080:

    http-server client/

    npm ls

    http-server client/

Node modules

A module is a single JavaScript file.

A package is a directory containing modules.

A list of shorthands for the NPM command
https://docs.npmjs.com/misc/config

Famous Node modules are listed below.

Yarn Install

An alternative to NPM is yarn, which uses Node to generate software.

Yarn is used by https://github.com/dancancro/great-big-example-application

To install it on a machine with NPM already installed:

  1. Install using Homebrew:

    brew install yarn --ignore-dependencies -g

    The response:

    PROTIP: Using Brew means that you don’t need to setup path yourself.

    BTW, A search of all files that mention “yarn” yielded this list:

  2. Verify that Yarn is installed by running:

    yarn --version

    At time of writing in 2017, the version was:

  3. There is a more precise version:

    ls /usr/local/Cellar/yarn

    At time of writing in 2017, the output was:

  4. Verify the yarn command works:

    yarn

    At time of writing in 2017, the response was:

Grunt

npm install -g grunt-cli

The response:

Node Watch File Changes

Gulp

LearnNode Programming Tutorial

The classic interactive tutorial introducing Node.Js was created on:

To install it we reference its npm package on npm.org:

  1. Run npm install learnyounode -g

    Notice the -g can go before or after the module being installed.

  2. Run learnyounode

    NOTE: Use keyboard up/down arrows to select option. This is not a GUI interface.

    The tutorial consumes a Terminal window process.

  3. To exit, press control/command + C to close the process.

  4. When you’re done, run npm uninstall learnyounode.

How NPM works

HEADS UP! This article was written for an older version of node. More up-to-date information may be available elsewhere.https://howtonode.org/introduction-to-npm

http://stackoverflow.com/questions/25897908/how-npm-install-works

https://www.npmjs.org/doc/cli/npm-shrinkwrap.html

I use Node.js (via browserify) for each of my web apps, all of which have some dependencies in common and others specific to themselves. Each of these apps has a package.json file that specifies which versions of which modules it needs.

Yes, that is what npm install does. In node.js code, the require algorithm has a particular sequence of places it looks, including walking up the filesystem. However, npm install doesn’t do that. It just installs in place. The algorithms it uses are all constrained to just a single node_modules directory under your current directory and it won’t touch anything above that (except for with -g).

Right now, I have a /node_modules directory in the parent folder of my apps for modules that they all need to reference, and then I put app-specific modules in a node_modules folder in that app’s directory. This works fine in the short term, since my require() statements are able to keep looking upward in the file structure until they find the node_modules directory with the correct app in it.

Where this gets tricky is when I want to go back to an old project and run npm install to make sure it can still find all the dependencies it needs. (Who knows what funny-business has occurred since then at the parent directory level.) I was under the impression that npm install did this:

When I run npm install inside an app folder, however, it appears to install everything locally regardless of where else it may exist upstream. Is that the correct behavior? (It’s possible there’s another reason, like bad version language in my package.json). If this IS the correct behavior, is there a way for me to have npm install behave like the above?

It’s not a big deal to widely replicate the modules inside every app, but it feels messy and prevents me from make small improvements to the common modules and not having to update every old package.json file. Of course, this could be a good thing…

Yeah basically you’re doing it wrong. The regular workflow scales well to the Internet. For your use case it creates some extra tedious work, but you can also just use semantic versioning as intended and specify “mylib”: “^1.0.0” in your package.json for your apps and be OK with automatically getting newer versions next time you npm install.

If installed using homebrew so it’s done on every shell session:Add to ~/.profile

Additional topics

source $(brew –prefix nvm)/nvm.sh

Resources

Several blogs addresses issues related to this topic:

  • https://docs.npmjs.com/getting-started/fixing-npm-permissions
  • Install npm packages globally without sudo on OS X and Linux
    • http://stackoverflow.com/questions/16151018/npm-throws-error-without-sudo/24404451#24404451
    • http://stackoverflow.com/questions/10081293/install-npm-into-home-directory-with-distribution-nodejs-package-ubuntu/13021677#13021677

    https://github.com/isaacs/nave nave is a virtual environment for node, an alternative to nvm. It is invoked by source command rather than run.

  • http://blog.teamtreehouse.com/install-node-js-npm-mac

  • https://github.com/felixrieseberg/npm-windows-upgrade enables upgrade of Node on Windows using elevated PowerShell scripts.

  • http://www.backdrifter.com/2011/02/18/using-nvm-and-npm-to-manage-node-js from 2011 is frequently quoted.

  • Building Web Applications with Node.js and Express 4.0 (UPDATE)released 23 Mar 2018 by Jonathan Mills

More on MacOS

Macos Node Watch File For Changes Online

This is one of a series on MacOS:

Please enable JavaScript to view the comments powered by Disqus.

Macos Node Watch File For Changes Windows 7