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 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
Introduction The number one threat to web applications and websites in 2017 and 2013 was SQL injection attacks. That’s according to The Open Web Application Security Project (OWASP) Foundation, a non-profit security community that supports the development of secure web applications. The more DBAs and web application developers know about SQL injections, the better they … Continued
How to drop a collection if exist using mongoose in MongoDB? From the title, it is clear that we are going to add some checks to avoid duplicate collection available in the database. This is a very important concept which almost needs to be used by every developer. This concept is really becoming a required thing … Continued
Introduction In this article, we will be discussing the difference between the “group by” clause and the “order by” clause of the PostgreSQL database. Before getting in the details, let’s just explain briefly what exactly are clauses in the PostgreSQL database. Clauses Clauses in the PostgreSQL are keywords that have definite meaning (similar to their … Continued
Introduction In this article, we will be discussing the difference between “unique” constraint and the “distinct” statement in PostgreSQL. It may not be obvious but we used two different terms to refer to the two because UNIQUE is a constraint while DISTINCT is a statement. Statements might be self-explanatory, but what are constraints? First, we … Continued
Introduction In this article, we will be discussing the difference between the “except” clause and the “not in” operator of the PostgreSQL database. We hope to clear up the difference between the two so you know when to use which. Let’s start off by stating that EXCEPT is a clause and NOT IN is an … Continued
Introduction HAVING and WHERE clauses are used to filter rows resulting from select statement. HAVING clause is used to return the rows that meet a specific condition. Where clause is more of the same as HAVING but while it is used to filter through each row, the having clause filters grouped rows. Syntactically, the difference … Continued
Introduction What’s the difference between a Function vs Stored Procedure in SQL? It’s a question that we hear quite often and we hope we can you provide you with the answer in this Function vs Stored Procedure Functions and procedural statements are sets of sql statements which can be called to execute in a given … Continued
