Introduction This tutorial will explain how to perform Redis set-up persistence and how to set up the append-only file. The Redis database backup, or RDB, are backup snapshots taken at predetermined intervals to prevent data loss in the event of an outage. Redis persistence uses an append-only file as a mode of data persistence that … 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 If you’re storing documents in Elasticsearch, it’s important to know how to index large numbers of documents at a time. Fortunately, it’s easy to accomplish this task using the Bulk() API method to index Elasticsearch documents with the help of the Olivere Golang driver. In this article, we’ll provide step-by-step instructions for performing a … Continued
Introduction Redis is an open source, data-structure store that can be used as a caching layer, database or messaging agent. Redis can resolve complex programming issues and reduce latency and coding time. Java is a programming language typically used to create application modules for web pages. This tutorial will cover how to use the Redis … 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
Introduction In this article we’ll jump straight to the point in discussing delete vs truncate in Postgres SQL, what the differences are, and when each is used. Delete vs Truncate Delete and truncate operations are useful when managing data in both small and large tables. Delete is often used when you want to clear data … Continued
Introduction Postgresql supports a wide variety of native data types. Among them are text data types, numeric data types, date and times, Boolean data type etc. Creation of data types in Postgresql is easily done using the CREATE TYPE command. In this article we will focus on two types of data; the decimal and the … Continued
