Managing Indexes in MongoDB

Introduction Do you remember flipping through a textbook or cookbook looking for a certain topic or recipe? If the book had an index in the back, that was usually the first place to start. The index was alphabetized and anything could be found by searching for one main word. It was easier to find something … Continued

Create A Mongodb And PyMongo Webapp Using The Bottle Framework For Python

Introduction If you’re looking to create a scalable, flexible web application, MongoDB and Python offer a winning combination of tools. In this article, we’ll show you how to create a simple MongoDB web application using the PyMongo driver and the Bottle framework. Even if you don’t have much experience developing web applications, it’s easy to … Continued

How to Bulk Index Elasticsearch Documents From A JSON File Using Python

Introduction When you’re managing data in Elasticsearch, it’s important to know how to bulk index documents in an efficient manner. This article will explain how to bulk index Elasticsearch documents from a JSON file using Python. The Python script will index the data as Elasticsearch documents with the help of the Python client library and … Continued

Postgres VARCHAR vs TEXT

Introduction If you’re working with PostgreSQL, it’s important to have a solid understanding of the different data types so that you can choose the correct ones when creating your database tables. Two common character types used in PostgreSQL are the TEXT and VARCHAR types. Although there are many similarities between these two types, there are … Continued

How to Use the Redis WATCH Command

Introduction If you’re using Redis to manage your data, it’s important to understand how to use transactions with this key-value data store. Transactions in Redis bear little resemblance to transactions in a typical relational database management system (RDBMS). Fortunately, Redis has several useful commands to help you manage transactions effectively. In this article, we’ll discuss … Continued

MongoDB findOneAndDelete findOneAndUpdate findOneAndReplace

Introduction In MongoDB, the findOne method is used to get the first matched document from a collection. It is useful to perform operations on a single document. MongoDB provides an easier way for it. There are three methods that are methods combined with the findOne method that can be used effectively to work with databases. … Continued

How to Create a Function in PostgreSQL

Introduction Although PostgreSQL offers a wide variety of built-in functions, there are times you’ll want to create your own function to meet your application’s requirements. It’s easy to accomplish this task with the help of the CREATE FUNCTION statement, which allows you to build a new PostgreSQL function or replace an existing one. In this … Continued

NodeJS MongoDB Remove by Id with Mongoose

Introduction Delete is one of the CRUD operations in MongoDB. Using mongoose with NodeJS and MongoDB provides many methods to remove data from a collection. One of these methods in removeById. It is a simple function that is used to remove a document from a collection using the value of the _id field. This as … Continued

NodeJS MongoDB Populate with Mongoose

Introduction In MongoDB, there are usually various collections with several documents. While working with MongoDB and NodeJS, we may need to link the documents of various collections. For such operations, Mongoose provides a method known as populate. This is similar to a join in relational databases and allows us to consolidate information from various collections … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.