Database Development Zone

MySQL vs. MariaDB

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

Using Python for Big Data Analysis

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

Introduction to Facebook GraphQL

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:

Container Orchestration with Docker Swarm

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

Backup and Restore Using Amazon S3 API

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

Working with Triangular Joins

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

Stored Procedures Do Not Protect from SQL Injection Attacks

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

MySQL Master Slave Replication

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

Optimize Inserts Using SQLAlchemy

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

No more posts to show