Top 10 Databases for Developers Greetings, fellow tech enthusiasts! Today, we embark on a journey to explore the top 10 databases every developer should know about. Whether you’re building a small website or a massive application, having the right database can make all the difference. Let’s dive right in! 1. MySQL Ah, MySQL! The go-to […]
Top 10 Databases for Developers: A Deep Dive into The World of Information Management Databases play a pivotal role in the world of software development. They are like a treasure chest, storing and managing all the valuable data that powers modern applications. This article serves as a guide to the ‘Top 10 Databases for Developers’ […]
A MySQL Cluster in the form of MariaDB Galera Cluster is a multi-master sync or multi-master replication available in a MariaDB cluster. While it is more expensive and harder to maintain than MySQL, the MariaDB Galera cluster can theoretically handle more. It allows higher scalability, especially read scalability, and is more fault-tolerant than other types […]
In this post, you will learn to deploy WordPress on k8s (Kubernetes) managed from DigitalOcean. WordPress is a popular content management system (CMS) for creating websites easily. By using PHP and MySQL to support WordPress in building a content management system, we can create many websites, blogs, and other website-based applications by learning how to […]
Load Balance HA MySQL with HAProxy. HAProxy or High Availability Proxy is a high performance open-source load balancer created to work (load balance) over TCP/HTTP. This is a Software that has several use cases you can chose, but it’s great for a MySQL load balancer. The company who makes HAProxy also develops many more products […]
Today, multiple flavors of SQL databases exist with versatile use cases, like MySQL and Postgres databases. It ends up being a hard choice: which SQL database do you want to use, which SQL database does your organization use; which SQL database is in the most demand? Our post Picking The Right SQL Database For You […]
In this article, we’ll explore the steps of ER modelling for database design. By the end, you will know what database design is and how to create an entity-relationship diagram (ER). In addition, you will also learn how to translate an ER from a case study.
All you need to know Cloud computing has revolutionized the way we do everything. We keep our photos, music files, and other important documents on Cloud storage systems that are globally distributed for easy access anywhere in the world! Cloud computing is a system of storing data on the internet. Instead of storing your files […]
We will be using MySQL for the purposes of this post and connecting it with Python to write CRUD queries– you can use whatever flavor of SQL you are comfortable in (if you’re unsure which to pick, check out our post on How to Pick a SQL Flavor. By the end of this post, you will have found the answer to the question: “How To Write MySQL CRUD Queries In Python”.
A Comparison of SQL Database Flavors: How To Pick The Right SQL Database Flavor For You? SQL, or Structured Query Language, is a database that has widespread uses with many flavors– which we will explore. As such, in our data-driven world, SQL is fast becoming an essential skill. Therefore, in this article, we will look […]
Maintaining a sound understanding of CRUD operations in MySQL, or SQL itself, is one of the most important things you can do as a beginner because this proves fruitful down the road when you have this major concept stored in the back of your heads and don’t get confused on these basic queries that form the foundation of SQL.
This post “MySQL master-slave replication with docker” was updated by Syed Umar Bukhari on August 26, 2021. As you may already know MySQL replication is a process to enable automatic copying of database(s) from one instance of MySQL to the other. Then docker and docker compose are orchestration tools. In this case, we will look […]