Day 29 – SQL Database with Node js - Learning Node JS In 30 Days [Mini series]

Before coming this part of tutorial, we never talked about the database. Actually it was a basic course so I never tell anything about the database. Just wanted to make pure node js tutorial.

Today we’re going to learn how can we add a sql database with express js.

It’s pretty easy, but we need a npm package for it. Actually multiple package for it.

For the sql connection. There are some packages

• Knex.js
• Sqorn
• squel
• Objection.js and many more I personally used knex.js and objection.js. Objection actually based on knex, it has some extra benefits so I used it some projects.

Knex is good choice, beacause it has an amazing documentation. Which is pretty easy to follow.

Installing is pretty easy. As like others. But you need to install the database too. Like what you are using – mysql or postgresql or sqlite

Connecting is easy too, just changing the credentials will be okay.

You can write RAW sql with the knex too. http://knexjs.org/#Raw-Expressions

which one you want to use ?

You can see the graphical version here

Originally it published on nerdjfpbblog. You can connect with me in twitter or linkedin !

You can read the old posts from this series (below)

Day 1 — Introduction - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 4 '19

#node #javascript #codenewbie

Day 2 - Install and Running Node on Window - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 5 '19

#node #javascript #codenewbie

Day 3 - JavaScript Engine - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 6 '19

#node #javascript #codenewbie

Day 4 - Window === Global ? - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 7 '19

#node #javascript #codenewbie

Day 5 - Function Declarations vs. Function Expressions - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 8 '19

#node #javascript #codenewbie

Day 6 - Require & Module - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 9 '19

#node #javascript #codenewbie #tutorial

Day 7 - More Modules - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 10 '19

#node #javascript #codenewbie

Day 8 – Var vs Let vs Const -Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 11 '19

#node #javascript #codenewbie

Day 9 – Mastering EventEmitter - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 14 '19

#node #javascript #codenewbie

Day 10 – Mastering EventEmitter - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 14 '19

#node #javascript #codenewbie

Day 11 – Creating and Deleting Folders - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 15 '19

#node #javascript #codenewbie

Day 12 – Creating own server - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 15 '19

#node #javascript #codenewbie

Day 13 – Buffer & Stream - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 16 '19

#node #javascript #codenewbie

Day 14 – Serving HTML Pages - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 17 '19

#node #javascript #codenewbie

Day 15 – Sending JSON to Client - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 18 '19

#node #javascript #codenewbie

Day 16 – Routing (Basic) - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 19 '19

#node #javascript #codenewbie

Day 17 – NPM (Node Package Manager) - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 20 '19

#node #javascript #codenewbie

Day 18 – Why Express JS ? - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 21 '19

#node #javascript #codenewbie

Day 19 – Nodemon - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 22 '19

#node #javascript #codenewbie

Day 20 – Express Js Introduction - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 23 '19

#node #javascript #codenewbie

Day 21 – HTTP methods - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 24 '19

#node #javascript #codenewbie

Day 22 – Route Parameters - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 25 '19

#node #javascript #codenewbie

Day 23 – Template Engines - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 28 '19

#node #javascript #codenewbie

Day 24 – Working with EJS (Part 1) - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 29 '19

#node #javascript #codenewbie

Day 25 – Working with EJS (Part 2) - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 29 '19

#node #javascript #codenewbie

Day 26 – Working with EJS (Part 3) - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 30 '19

#node #javascript #codenewbie

Day 26 – Working with EJS (Part 3) - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 30 '19

#node #javascript #codenewbie

Day 27 – Working with Static files - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 30 '19

#node #javascript #codenewbie

Day 28 – Middlewares - Learning Node JS In 30 Days [Mini series]

Muhammad Ali (Nerdjfpb) ・ Dec 31 '19

#node #javascript #codenewbie #tutorial