Find tutorials and articles related to MySQL, MongoDB, MariaDB, NoSQL, and other database management systems. Acquire in-depth knowledge and levitate from being a beginner.
MySQL is the most widely used open-source database engine in Linux and cloud-based platforms. Almost every web hosting service provider offers a basic MySQL instance included in its web hosting plans at no extra cost. The web+database hosting combo is a preferred option for new or low traffic websites since the combo frees the system…
A step-by-step guide to install the latest version of MongoDB Community Edition on CentOS. MongoDB, one of the popular NoSQL database, is available for recently released CentOS 8. Let’s check out how to get it installed. Installing on CentOS/RHEL 8 Support for CentOS 8 is available from MongoDB 4.2.1. This means you can’t install the…
If you lived through the early 90s and 2000s, the chances are that you’re already familiar with the LAMP web development stack. Which, in short, stood for Linux, Apache, MySQL, and PHP/Python/Perl. Most web projects were being built using the specific stack alone. It was (and still is) accessible, relatively easy to maintain, and had…
One of the most frequently asked questions – what database should I use… SQL stands for Structured Query Language. It was first developed in the 1970s by a team of IBM researchers, NoSQL databases, on the other hand, were first used in 1998 by Carlo Strozzi. The most common difference between these two databases (DB)…
Leverage managed Redis cloud hosting platform for better availability, performance, and security. Redis is an open-source in-memory database used heavily as a cache. It is used everywhere, trusted by more than 7000 organizations, including Microsoft, Vodafone, Mastercard, etc. And not just enterprise applications but it’s being used on WordPress sites too. If you are starting…
For most application developers, the database is an altar of demon gods best left unapproached. But it need not be that way! Other things being equal, the level of comfort a developer has with the underlying database defines their seniority level. Little database and little coding experience = junior developer; little database and good coding…
Data is everything. And by extension, so are databases. Here are some fantastic open source options for your next kick-ass project. For a world dominated so long by database suits like Oracle and SQL Server, there seems to be an endless flurry of solutions now. One part of the reason is innovation fueled by Open…
Procedure to disable binary logs in MariaDB A few days back, Geekflare was unavailable, and the reason was simple – no space left on the device. Had hundreds of alerts and emails from the audience about the website being down but I was traveling so couldn’t take action on time. This was logged in Google…
When it comes to (relational) databases, MySQL has been an undisputed winner. But now it has serious competition! Unlike other database comparisons, the MySQL vs. MariaDB one has minimal real, objective merit. They’re almost the same (and a while back, were the same!), have the same directory structures and syntax, and same performance. Yes, after the…
How to scale MongoDB? What are the best sharding practices? While flexible schema is how most people become familiar with MongoDB, it’s also one of the best databases (maybe even the best when it comes to everyday applications) for handling very, very large data sets. While the justification of this argument calls for a whole…
