Tuesday, July 04, 2017

Updated GraphQL Sync in ArangoDB 3.2

DZone Database Zone
Updated GraphQL Sync in ArangoDB 3.2

Just in time for the upcoming 3.2.0 release, we have updated the graphql-sync module for compatibility with graphql-js versions 0.7.2, 0.8.2, 0.9.6 and 0.10.1. The graphql-sync module allows developers to implement GraphQL backends and schemas in strictly synchronous JavaScript environments like the ArangoDB Foxx framework by providing a thin wrapper around the official GraphQL implementation for JavaScript.

As a long-term database solution, ArangoDB is committed to API stability and avoids upgrades to third-party dependencies that would result in breaking changes. This means ArangoDB will continue to bundle the graphql-js 0.6.2 compatibility version of graphql-sync.

Monday, July 03, 2017

Live Coding with AWS: Recognizing Celebrities with Rekognition

Data Videos
#Data -Live Coding with AWS: Recognizing Celebrities with Rekognition

We Won't Be Fixing This Database Condition

DZone Database Zone
We Won't Be Fixing This Database Condition

During the work on restoring a backup, the developer in charge came up with the following problematic scenario.

Start restoring the backup of database Northwind on node A, which can take quite some time for a large database. Create a database named Northwind on node B while the restore is taking place.

The problem is that during the restore, the database doesn’t exist in a proper form in the cluster until it is done restoring. During that time, if an administrator is attempting to create a database, it will look like it is working, but it will actually create a new database on all the other nodes and fail on the node where the restore is going on.

Where are we? July & August 2017

Data Videos
#Data -Where are we? July & August 2017

June in Database: Migration, Deployment, and Fraud

DZone Database Zone
June in Database: Migration, Deployment, and Fraud

Welcome to the first-ever edition of This Month in Database! In this article, we'll cover everything you need to know about databases from the past month, including the top database-related articles on DZone that you should check out, the top news that happened in the world of database, database jobs that you might be interested in, and more. Let's get started!

Delightful Database Dojiggers on DZone

Overcoming Database Migration Fear by Jay Gordon. Data loss or an outage in the process of a migration are big concerns. It's an uncommon fear but one that the author has actually created a scientific term for: deebeephobia. 

The 5-Minute Interview: Neo4j and IBM Power Systems

DZone Database Zone
The 5-Minute Interview: Neo4j and IBM Power Systems
“As the relationship really started to take shape, we realized what the two technologies could solve much more effectively when they worked together,” said Keshav Ranganathan, Senior Offering Manager at IBM Power Systems.

The Neo4j partnership with IBM Power Systems is one of many that have been formed over the last several years, making the native graph database an even more effective enterprise solution for companies that span industries and continents.

In this week’s five-minute interview (conducted at GraphConnect San Francisco), we discuss the ways in which the IBM Power Systems and Neo4j partnership came to fruition, and the powerful benefits both companies are able to provide to customers because of it.

Store a Function to Delete All Databases in MongoDB [Code Snippet]

DZone Database Zone
Store a Function to Delete All Databases in MongoDB [Code Snippet]

Deleting everything in a test MongoDB is a common operation for test and dev machines. It's a relatively simple operation that I have described here. After a little while, I got really tired of searching for the little script that deletes everything every time I needed it. Thus, I decided to store it inside the admin database.

The solution is really simple. Just connect to the admin database and register a server-side function to delete all databases.

Sunday, July 02, 2017

Introduction to AWS GovCloud (US)

Data Videos
#Data -Introduction to AWS GovCloud (US)

How to Run Multiple Cassandra Nodes on the Same Hosts

DZone Database Zone
How to Run Multiple Cassandra Nodes on the Same Hosts

Cassandra is well-known for its ability to handle some of the world’s largest database workloads. It was developed at Facebook and is now used by other web-scale companies like Instagram, Reddit, and Netflix. But Cassandra is also a beast to run, taking considerable resources to function at peak performance.

The cost of operating a Cassandra cluster can be quantified by:

Let's talk about Power BI Premium - Adam and Patrick Unplugged [EP4]

Data Videos
#Data -Let's talk about Power BI Premium - Adam and Patrick Unplugged [EP4]

Flex Up and Flex Down Database Capacity

DZone Database Zone
Flex Up and Flex Down Database Capacity

We’ve explored scaling up and out. Then, we talked about scaling in and down. MySQL is a very popular RDBMS, but challenges arise when your workload hits the limits of the largest node you can provision. But this third article isn’t about adding scale — it’s about removing it. From the technical/DevOps perspective, it’s hard enough to have sufficient resources deployed, so why would you ever want to consider removing them?

Everyone’s seen the “wall of shame” of tweets about major e-commerce sites suffering site slowdowns and outages during Black Friday and Cyber Monday. Here’s a brief recap just from the last decade:

Saturday, July 01, 2017

Introduction to AWS GovCloud (US)

Data Videos
#Data -Introduction to AWS GovCloud (US)

Let's talk about Power BI Premium - Adam and Patrick Unplugged [EP4]

Data Videos
#Data -Let's talk about Power BI Premium - Adam and Patrick Unplugged [EP4]

Achieving High Availability in MySQL

DZone Database Zone
Achieving High Availability in MySQL

We've already discussed hitting capacity in MySQL, sharding complications and complexities, and flexing database capacity up and down. This time, we'll be discussing achieving high availability in MySQL.

When discussing high availability, the following questions usually come up first: Do you need it? Why?

Sharding Complications and Complexities

DZone Database Zone
Sharding Complications and Complexities

Recently, I presented a Tech Talk on sharding, its complications, and complexity.

There are many pros and (even more) cons to sharding, which can be summarized with these two questions:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...