Introduction In this article, we will be discussing the COUNT function in SQL. Before getting in the details, let’s just explain briefly what exactly are functions in an SQL database. Functions Functions in SQL are used to perform certain operations on the result returned from the SELECT statement. Functions are performed on some attribute values. … Continued
Introduction In today’s article, we are going to use Mongoose for sorting elements in MongoDB. But before I move on to the code, let me give you some real-life examples about sorting and how it might be used in a real world application. The best real-life example of sorting is and e-commerce like Amazon or … Continued
Introduction Before I show you how to do a partial text search in code let’s discuss a real-world example. We’re going to give you a real-life example from the web development industry. If you have visited any kind of the e-commerce like Amazon or AirBnb. If you use the search form and start typing then … Continued
Introduction In this tutorial, we drop will learn how to drop a database using the Mongoose library for MongoDB. The Mongoose library is not the native NodeJS library for MongoDB but is a third party library which allows you to create and store data using data models. Deleting an entire database programmatically is not a … Continued
Introduction In the last tutorial, we created a database using the command line and also showed that database, collection, and documents using MongoDB compass. We also covered the basics of mongoose. First With Compass – The Easy Way In this tutorial, we are going to drop a collection using mongoose but first we will show … Continued
Introduction When working with databases you’ll need to manage the data in the database by defining the state of the specific data in a given column. There are several constraint put in data when using PostgreSQL. They include the PRIMARY KEY constraints, FOREIGN KEY constraint, CHECK constraint, UNIQUE constraint and the NOT NULL constraint. Some … Continued
Introduction In this article, we will be discussing the difference between “except” clause and the “minus” clause in an SQL database. Clauses Clauses in the SQL are keywords that have definite meaning (similar to their English language counterpart) and purpose. The purpose is self-explanatory by the name of the clause. For example, the WHERE clause … Continued
Introduction This tutorial is Part 3 of the series “How to Connect PHP with PostgreSQL using the PDO Driver.” Before we get started, let’s remind ourselves of four of PostgreSQL’s object-relational database management system (ORDBMS) notables. It’s open-source, reliably accurate, compatible with popular operating systems, and well respected in terms of adhering to database standards. … Continued
Introduction This tutorial will cover two methods used to delete MongoDB documents with the Golang driver. These two methods used to delete MongoDB documents with the Golang driver include the DeleteOne()method and DeleteMany() API calls method. These two methods are used to delete just a single record or a number of documents, respectively. Prerequisites Needed … Continued
Introduction This is part two of the tutorial “How to Connect PHP with PostgreSQL using the PDO Driver.” Part one of the tutorial explained how to create a database and connect PostgreSQL in PHP using the PDO driver. This part will explain how to connect PHP PostgreSQL with the PDO driver and how to interact … Continued
