Category: Databases

Database Sharding

Good day software developers and engineers. Today is Wednesday and it seems it is going to be a sunny day in the Twin Cities of Minneapolis and St. Paul. Hope the weather cooperates in your neck of the woods.

I continue to read and experiment with the contents presented in the on-line course Introduction to Python Fundamentals: Lesson 02 by Paul Deitel published by Pearson Education, Inc. As a matter of fact, tomorrow I will start with lesson 03. So far I am pleased to be reviewing and learning new things during the process. Continue reading “Database Sharding”

MongoDB Text Search

Yesterday was a warm and humid day in the Twin Cities of Minneapolis and St. Paul.

Last week a software developer mentioned that he was interested in using MongoDB Atlas and needed to do some text searches. I have used text searches in a project a couple years ago. I have also experimented with it using the Community version currently installed in one of my Windows machines. I decided to test it to make sure searching for text in MongoDB is working as advertised.

I could have used an existing MongoDB database and collection but for simplicity I decided to use the example illustrated in the MongoDB documentation for Text Search. I would like to note that in my opinion MongoDB has done a very good job with their documentation. Continue reading “MongoDB Text Search”

Securing MongoDB

Today is a summer Saturday morning in the Twin Cities of Minneapolis and St. Paul. It is not as bright as usual, it appears to be cloudy but it is relatively early. I woke up around 04:30 AM and decided to get up, read the news for a few minutes, and then decided to write this posts. My motivation is twofold. The first and most important is due to the fact that I am officially starting a new project at work using MongoDB. I will be using a local version of MongoDB which later will be moved to use Atlas on the cloud. The database will contain sensitive patient data. The second is the number of recent posts regarding data leaks on NoSQL bases. This morning I just read “MongoDB Leak Exposed Millions of Medical Insurance Records” which seems to illustrate the fact that people forgets to secure their MongoDB instance. Continue reading “Securing MongoDB”

DynamoDB

I do not like to live of past memories but this morning I spent a few minutes updating the About me … section in this blog. I included the fact that since my early 20’s I started dabbling with starting my own businesses. At the time I got together with a couple friends and opened a liquor store. I was able to secure beer distribution of one of the largest breweries in Peru. The rules are that breweries sell only via distributors and distributors only sell to liquor stores. About a year after, I sold the business due to the fact that I received a scholarship to attend Cornell University and permanently move to the USA.

Continue reading “DynamoDB”

CRUD Minus R on Mongo DB

20,000 American Flags are displayed for every resident of Massachusetts who died in a war over the past 100 years, Boston Common, Boston, MA, Memorial Day, 2011

It is a beautiful day in the Twin Cities of Minneapolis and St. Paul part of the Memorial Day 2018 weekend. The forecast calls for very warm days. On Monday the temperature will be reaching 95F. My wife and I decided to go for a walk first thing in the morning. Today Saturday we got up at our usual time (05:30 AM CDT), had breakfast (yogurt, granola, blueberries, strawberries, bananas and a cup of milk with a shot of espresso) and headed out. As the walk progressed, we ran into several people getting their daily walk out of the way in order to avoid the high temperatures. Showered and sat in front of my computer. I will be working for the next four hours or so. This afternoon my wife and I will attempt a walk around one of the lakes in Minneapolis. Will be very hot but we are planning on a stroll and a stop for ice cream and water. Continue reading “CRUD Minus R on Mongo DB”

Using the MongoDB Shell

I believe it was Albert Einstein who said “Any man who reads too much and uses his own brain too little falls into lazy habits of thinking”. I like to read in order to learn about different subjects, mostly associated with computer science and technology. I also like to experiment with what I am reading in order to verify that I understand the material. Continue reading “Using the MongoDB Shell”

Running MySQL on Windows 10

In my previous post I mentioned that I was going to be spending some time experimenting with MongoDB. So why would I be dealing with MySQL at this time? Good question! The reason for it is that I want to store, among different things, Java objects in MongoDB. I am interested in comparing how the same Java object may be stored and retrieved using a SQL and a NoSQL databases. I could have used a different SQL database (e.g., SQL Server), but decided on MySQL. It happens that I have a few databases installed on my Windows 10 computer. With that out of the way; let’s experiment with MySQL. Continue reading “Running MySQL on Windows 10”

Installing MongoDB on Windows

As mentioned in a previous post, I will be spending some time learning, experimenting and working with the MongoDB NoSQL database.

MongoDB is a FOSS (Free of the Shelf Software) document-oriented database engine. It is one of the most popular engines in its classification. MongoDB Inc offers many free resources for developers to learn how to use their database. There are many books that offer from introduction to advanced information and examples on how to use this tool. I have been reading and experimenting with it for some years. Continue reading “Installing MongoDB on Windows”

Why Apache Cassandra?

cassandra_logoThe following question came up a couple weeks ago: Why would I use Apache Cassandra? First of all let’s get a definition for Apache Cassandra. Edited from Wikipedia (https://en.wikipedia.org/wiki/Apache_Cassandra):

“Apache Cassandra is a free and open-source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers robust support for clusters spanning multiple datacenters, with asynchronous master less replication allowing low latency operations for all clients. Continue reading “Why Apache Cassandra?”