Many developers have used MySQL, while they have only heard of MariaDB. Let’s explore the differences between these two database management systems. History MySQL and MariaDB share common history. MySQL was created in 1995 by a Fino-Swedish company MySQL AB, which was founded by David Axmark, Allan Larsson and Michael
It’s no surprise that big data?is becoming an integral part of any business conversation. Desktop and mobile search are providing data to marketers and companies around the world on an unprecedented scale, and with the advent of the Internet of Things, the already large amount of data on consumers will
GraphQL is a data query language used by Facebook since 2012 that was recently open sourced. It was designed to expose hierarchical data and make it easier for front-end developers to access it. What does Facebook GraphQL look like? Before diving in let’s see an example of GraphQL: { user(id:
Containers eat the DevOps world. Docker is leading the pack with the ubiquitous Docker engine runtime and a plethora of related tools. In this article, I provided some basic information about Docker. A single container is, however, not very useful. Even a collection of containers on the same machine has
In terms of data security, it is a good practice to backup your server’s files to an external location. At a rate of $3 per 100 GB of storage, Amazon S3 is both a cost-effective and reliable choice. To completely automate the backup process, you will have to integrate Amazon
Set-based solutions are always faster than loops in SQL, right? Usually?that is true but not always. A good example would be if you wanted to create a running total of sales values. Let’s say we have a table called Sale that has a SaleDate (DateTime) field that records the date
I often hear people say that using stored procedures protects you against SQL injection attacks. This is incorrect. The vulnerability to SQL Injection comes from concatenating values into SQL Strings and then executing them, whether that is done in client side code or through the use of dynamic SQL. For
In high-traffic Web applications, a master-slave database architecture is used to optimize performance by separating read and write operations and to prevent loss of data in case of a server failure. Let’s see how to set it up in a MySQL database management system. How Does it Work? The main
SQLAlchemy is a very sophisticated toolkit for databases in Python. It has many layers that have different levels of control and ease-of-use. SQLAlchemy is designed to provide superb performance, but it is sometimes too difficult to harness all the power. In this article I’ll explore what’s possible and demonstrate some