Backing up and Restoring PostgreSQL Databases Introduction Making regular database backups is an essential maintenance task and fail point recovery strategy for anyone who is responsible for a database. A commo...Learn More

Running SQL on CSV Data: Data Conversion and Extraction A lot of tools output data as comma-separated values (CSV). It is a simple but common tabular data format of plaintext that can easily be processed. Each ...Learn More

Using SQLAlchemy with Flask and PostgreSQL Introduction Databases are a crucial part of modern applications since they store the data used to power them. Generally, we use the Structured Query Language (SQL) to...Learn More

Integrating Elasticsearch with MS SQL, Logstash, and Kibana Introduction MS SQL Server holds the data in relational form or even multi-dimensional form (through SSAS) and proffers several out-of-the-box search ...Learn More

Bookshelf.js: A Node.js ORM One of the most common resources you'll interact with in a language like Node.js (primarily a web-focused language) are databases. And with SQL being the most common of all the diffe...Learn More

**Difference between varchar and varchar2** In this tutorial you will learn about difference between varchar and varchar2. Varchar stands for variable length character string. Both Varchar and Varchar2 are data...Learn More

**Normalization in DBMS – 1NF, 2NF, 3NF and BCNF** Here you will learn about normalization in dbms with examples. What is Normalization in Database? Most of the projects and websites contain lot of information....Learn More

**How to Backup or Restore MySql Database Using SQLyog** This tutorial will guide you how to backup or restore mysql database using sqlyog. It is really important to create regular backups of database on which ...Learn More

**MongoDB vs SQLite – Difference between MongoDB and SQLite** In this article, you will learn about difference between MongoDB and SQLite. MongoDB MongoDB first version was released in 2009. It is the most reli...Learn More

**Why Do You Need to Listen to Your Developer When Choosing Web Hosting?** A web developer is a person who’s responsible for a visual appeal of a website and performs tasks related to the website’s layout, deve...Learn More

**Joins in SQL – Inner, Outer, Left and Right Join** Here you will get detailed information about joins in SQL. Join is a very basic concept in SQL which can be confusing at times. The joins are used when we ne...Learn More

**dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart** dbForge Studio for SQL Server is an integrated environment for managing, administering, accessing, configuring, and developing SQ...Learn More