This is just a short look at the popularity of MongoDB, Redis and Apache Cassandra. Recently I was a bit surprised by the Google Trend image posted at KDnuggers in...

The following article provides a high-level overview of NoSQL databases and the various associated data store types related to these kinds of databases. A particular section of the article is...

Recently I came across a statement that said: “MongoDB (btw. that’s MongoDB) uses the BSON format which extends the JSON model to provide additional data types” and I think this...

This post is a placeholder for a future venture into commercial benefits of Shared-Nothing (SN) distributed database architecture. A term ‘shared nothing’ was first coined by Michael Stonebraker (University of...

In this article, we’ll analyze the situations in which it is more appropriate to implement a distributed database instead of a centralized (local) database. But before we do so, let’s...

HeidiSQL allows exporting any MySQL database in JSON format. Read more... Highlight any data in the DATA tab, or in the query result set... then right click and select Export...

This post outlines how to configure MariaDB or MySQL on Centos 7 in order to store a specific database outside of the typical /var/lib/mysql/DBNAME directory. Or in other words, how...

This article describes how to fix MySQL connection error: ("Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]"), experienced during MySQL or MariaDB authentication (typically during establishing...

I get this asked quite often, so here is a simple example of using MySQL command for replacing one string with another in multiple rows: This command will replace a...

This article illustrates how to create MySQL database containing entire Wikipedia out of downloaded Wikipedia XML dump (enwiki-latest-pages-articles-multistream.xml) Prerequisite: - Make sure you have at least 100GB of free space...