Tuesday, September 05, 2017

Bootstrapping Spring Cloud Config Server MongoDB

DZone Database Zone
Bootstrapping Spring Cloud Config Server MongoDB

Spring Cloud Config Server MongoDB enables the seamless integration of the regular Spring Cloud Config Server with MongoDB to manage external properties for applications across all environments.

A Simple Config Server

Bootstrapping a configuration server with Spring Cloud Config Server MongoDB is just a matter of the following three steps.

Monday, September 04, 2017

Languages and timelines in Power BI and previews

Data Videos
#Data -Languages and timelines in Power BI and previews

DevOps and the Database: What's Going On?

DZone Database Zone
DevOps and the Database: What's Going On?

When DevOps was first talked about in Flickr's seminal 10 Deploys per Day Velocity presentation in 2009, it was regarded by some as strange and alien to corporate culture. It was the antithesis of the accepted way of doing things, a threat to established and proven processes — it was downright dangerous.

Times have changed. Unicorns like Uber, Airbnb, Spotify, and GitHub couldn't live without it. Microsoft has embraced it and actively promotes it. It's become the key to gaining competitive advantage in a technology marketplace that is moving faster and changing quicker than it ever has before.

AWS Knowledge Center Videos: Is it possible to run the CodeDeploy agent as a non-root user?

Data Videos
#Data -AWS Knowledge Center Videos: Is it possible to run the CodeDeploy agent as a non-root user?

August in Database: Graph Theory, Async Modules, and Talking to Databases

DZone Database Zone
August in Database: Graph Theory, Async Modules, and Talking to Databases

Welcome to the third edition of This Month in Database! Can you believe we've already come this far?! If you missed out, you can check out June's update here and July's update here. This time around, we've got a whole new slew of fun stuff to talk about. 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!

You Know We're All About Database (No Treble)

Build a Rotten Tomatoes Clone With GraphQL and Auth0 by Prosper Otemuyiwa. Rotten Tomatoes may be harsh in the way it rates movies, but building a clone of it doesn't have to be!

Sunday, September 03, 2017

Analyzing Financial Time Series Data Using MariaDB ColumnStore

DZone Database Zone
Analyzing Financial Time Series Data Using MariaDB ColumnStore

MariaDB ColumnStore is a GPLv2 open-source columnar database built on MariaDB Server. It is a fork and evolution of the former InfiniDB. It can be deployed in the cloud (optimized for Amazon Web Services) or on a local cluster of Linux servers using either local or networked storage. In this blog post, I will show some examples of analysis of financial time series data using MariaDB ColumnStore.

Free Forex Historical Data at HistData.com

First of all, we will download Forex historical data (GBPUSD M1 Full 2016 Year Data), which is freely available on HistData.com. HistData.com forex historical data look like:

Nested Data Structures in ClickHouse

DZone Database Zone
Nested Data Structures in ClickHouse

In this blog post, we’ll look at nested data structures in ClickHouse for MySQL and how they can be used with PMM to look at queries.

Nested structures are not common in Relational Database Management Systems. Usually, it’s just flat tables. Sometimes, it would be convenient to store unstructured information in structured databases.

Saturday, September 02, 2017

Paging Data Queries With N1QL

DZone Database Zone
Paging Data Queries With N1QL

For this tutorial, we'll be using the beer-sample dataset that comes with Couchbase so it will be easy to follow along. If you don't yet have Couchbase installed, you can get going very quickly by having Docker and following the easy instructions on the Couchbase Docker image page to set up a quick instance of Couchbase for testing. Simply running the command with Couchbase installed gets us started:

docker run -d -name db -p 8091-8094:8091-8094 -p 11210:11210 Couchbase

After following a few setup prompts described on that page, we're ready to roll with some data.

MySQL Database and JMeter: How to Test Your Connection

DZone Database Zone
MySQL Database and JMeter: How to Test Your Connection

When testing your APIs, web service, or other system parts, you might need to record or retrieve data from a database. The purpose of this interaction is to check the correct record of specific data in the database or to prepare test data for the tests by adding specific records to the database. This article will show you how to check, update, and add entries to your database by using Apache JMeter. Based on these examples, each tester can then perform the appropriate interaction with the database, during their further testing.

In this blog post, we will use JMeter 3.2, the database MySQL 5.7.18 Community Edition (which is free and can be installed on your PC) and Java 8.

Friday, September 01, 2017

How Globe Telecom does Primary Backups via StorReduce to the AWS Cloud

Data Videos
#Data -How Globe Telecom does Primary Backups via StorReduce to the AWS Cloud

Moving Forward Faster: How Monash University Automated Data on AWS with Commvault

Data Videos
#Data -Moving Forward Faster: How Monash University Automated Data on AWS with Commvault

Deploying PostgreSQL Clusters Using Kubernetes StatefulSets

DZone Database Zone
Deploying PostgreSQL Clusters Using Kubernetes StatefulSets

This blog provides guidance on how to build a PostgreSQL cluster using the new Kubernetes feature, StatefulSet. Using this StatefulSet capability provides a very simple Kubernetes-native mechanism to make clustering decisions when deploying a PostgreSQL cluster.

The Crunchy PostgreSQL Container Suite is a set of containers that can be used to deploy, monitor, and administer the open-source PostgreSQL database. More details can be found in the crunchy containers GitHub repository here.

Deploying and Running MySQL on Kubernetes With Statefulsets and Kops

DZone Database Zone
Deploying and Running MySQL on Kubernetes With Statefulsets and Kops

This MySQL Kubernetes guide will show you how to run MySQL in containers on Kubernetes using statefulsets and kops.

Background

Our engineers (especially Harsh Desai) have been working closely with Kubernetes engineers to improve the installation path of Portworx onto a Kubernetes cluster.

Gnocchi vs. Prometheus

DZone Database Zone
Gnocchi vs. Prometheus

The realm of the time series database has been expanding the past few years. Now and then, a new contender appears from the fog. People keep asking me about the difference between Gnocchi and Prometheus. It's time to compare them!

Gnocchi and Prometheus are two open-source projects evolving in the same expertise area: time series handling. They both are licensed under the Apache 2.0 license (see the Gnocchi license file and Prometheus license file. And that's a good thing!

Async Validation in WPF

DZone Database Zone
Async Validation in WPF

Quite often, validation requires web requests, database calls, or some other kind of actions that require a significant amount of time. In this case, UI should be responsible throughout the validation, but saving/submitting data should be disabled until the validations complete.

This article provides a solution for this problem.

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...