Skip to content
Basic MySQL CRUD app with Node.js
HTML JavaScript
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
public/assets
routes
views
.foreverignore
.gitignore
LICENSE
README.md
app.js
latelist.sql.zip
package-lock.json
package.json

README.md

LateList

An simple example MySQL + Node.js CRUD app. Hopefully, this sample app can help people trying to learn Node.js with simple MySQL integration.

Includes a list page, /add page, /edit page and /delete function.

Installation

Go to / and run the following commands.

npm build
npm install

Add the data from latelist.sql.zip to your database for the three sample listings.

Notes

Make sure you update app.js with your local MySQL settings. The settings in the repo for MySQL are default settings for XAMPP/MAMP/WAMP, etc.

Execution

I like to use forever to run my server with the following command.

forever start -w ./app.js

I usually refrain from installing anything with -g but forever is so useful. You can install forever globally with npm using the following command.

npm install -g forever

Alternatively, if you just want to run the server alone, issue the following command.

node ./app.js

Credits

  1. Atauba Prince @achowba > github
  2. Inspiration Project Code
  3. Bootstrap
  4. npm@body-parser
  5. npm@ejs
  6. npm@express
  7. npm@express-fileupload
  8. npm@mysql
  9. npm@req-flash
  10. npm@forever
  11. favicon.cc
You can’t perform that action at this time.