Introduction This XML overview tutorial will provided a summary of XML and how it can be used as a data interchange between browsers and servers. JavaScript Object Notation and eXtensible Markup Language, most commonly referred to as JSON and XML, are both designed to solve the problem of maintaining computer-code structure while still keeping human … Continued
Introduction If you’d like to conserve server space and keep your data secure, you may want to consider encoding the data in your database. Using encoding and compression methods can help you safeguard data and save space on a server by streamlining redundant data. In this article, we’ll provide an overview of some common encoding … Continued
Introduction to Elasticsearch and Python The Python low-level REST client for Elasticsearch maps closely to the Java API for the Elasticsearch client. This article demonstrates how you can use the client to create a _mapping schema for a document with an encoded bytes string, and then index an encoded dictionary. The article will demonstrate how … Continued
Introduction Deleting data from a database is a critical operation. Delete operations should be performed carefully. There is no margin for error. Mongoose provides two delete methods for deleting documents from a MongoDB collection. They are deleteOne() and deleteMany(). In this article, we will discuss these methods for deleting documents in mongoose. We will delete … Continued
Introduction If you have ever worked with MongoDB, you would have definitely used the insert() method to insert data documents in a collection. This method is the most common method used to insert data into a MongoDB collection. But when using mongoose, the insert() method does not work. Why? simply, because it doesn’t exist in … Continued
Introduction to XML and JSON When data needs to be exchanged between different languages, servers or computers, you need to use a standardized format. For the longest time, XML was the only real choice for data interchange; however, another player came onto the scene in the 2000s. This new competitor was JSON, and the format … Continued
Introduction This JSON overview tutorial will provide examples on how to easily create JSON objects. JSON objects are designed to help package information so it is readable by both humans and computers. It can also serve as an exchange between browsers and servers as well as APIs between various programming languages. A JSON files use … Continued
Introduction PostgreSQL View presents a streamlined way for seasoned or novice developers and DBAs to view the information from one or more base tables differently. Since base tables tend to contain a lot of information, views are especially beneficial for making complex queries to process through those lengthy sources. Views also help manage user access … Continued
Introduction If you’re using PostgreSQL to store and manage your data, you’ll quickly find out that there are many functions available to evaluate and manipulate numerical data. In this article, we’ll focus on the CEILING function in PostgreSQL, which is used to get the nearest value that is greater than or equal to a specified … Continued
Introduction When you query a database, there are times when you might want to limit your results to a certain range of values. In PostgreSQL, it’s easy to accomplish this task with the help of the BETWEEN operator. This article will explain the advantages of this operator and provide examples of using Postgres BETWEEN in … Continued
