SQL Tutorials

Knex.js Tutorial | A Complete Guide

November 5, 2020 by Vithal Reddy

In this titorial, you will learn about knex.js which is a SQL query builder which supports most of the SQL databases such as Mysql, Postgresql, sqlite etc. This Knex.js Tutorial will be beginner friendly with code examples so all users can benefit most from it. Introduction Knex.js is a very popular Node.js SQL query builder … Read more

Creating user, database and adding access on PostgreSQL (and automate the process)

April 23, 2020April 22, 2020 by Vithal Reddy

If you’re a software developer, Postgresql will be the go-to database for most of the developers nowadays. if anyone wondering why so then head over to this comparison https://www.2ndquadrant.com/en/postgresql/postgresql-vs-mysql/ In This Database How-to guide, we will learn, how to create db user, database and grant access to the user for the database created using psql … Read more