Tag: JSON

Feed: Cloud Data Transformation Software | Matillion. Author: Veronica Kupetz, Solution Architect; What’s it like to be a Solution Architect at Matillion? For one thing, you get asked lots of questions. Many of them are interesting, and many are common enough that we want to share the answers here. Hence, our first installment of “Ask a Solution Architect.” This week, Solution Architect Veronica Kupetz explains how to execute jobs from the Matillion API. Read on. Q: I just started using Matillion and want to run jobs outside of the built-in scheduler. Does Matillion provide an API and if so, can ... Read More

Feed: Planet MySQL; Author: Severalnines; Deployment and management your database environment can be a tedious task. It's very common nowadays to use tools for automating your deployment to make these tasks easier. Automation solutions such as Chef, Puppet, Ansible, or SaltStack are just some of the ways to achieve these goals. This blog will show you how to use Puppet to deploy a Galera Cluster (specifically Percona XtraDB Cluster or PXC) utilizing ClusterControl Puppet Modules. This module makes the deployment, setup, and configuration easier than coding yourself from scratch. You may also want to check out one of our previous ... Read More

Feed: Planet MySQL; Author: Dave Stokes; Multi-Valued Indexes are going to change the way you think about using JSON data and the way you architect your data. Before MySQL 8.0.17 you could store data in JSON arrays but trying to search on that data in those embedded arrays was tricky and usually required a full table scan.  But now it is easy and very quick to search and to access the data in JSON arrays. Multi-Valued Indexes A Multi-Valued Index (MVI) is a secondary index defined on a column made up of an array of values.  We are all used ... Read More

Feed: R-bloggers. Author: lortie. messy data can be your friend (or frenemy)Many if not most data clean up, tidying, wrangling, and joining can be done directly in R. There are many advantages to this approach – i.e. read in data in whatever format (from excel to json to zip) and then do your tidying – including transparency, a record of what you did, reproducibility (if you ever have to do it again for another experiment or someone else does), and reproducibility again if your data get updated and you must rinse and repeat! Additionally, an all-R workflow forces you to ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. If you’ve ever had a web application freeze while it was calculating something, chances are that performing that computation in a JavaScript Web Worker would help. In this blog post, MemSQL’s David Gomes shows how to create a fully client-side application, using the JavaScript libraries React for the view layer and Redux for the application state layer. Introduction In this article, we’re going to explore how we leverage Web Workers, together with React & Redux, to build a fully client-side web application here at MemSQL. My goal with this article is to highlight a ... Read More

Feed: Planet MySQL; Author: Marco Tusa; To set correct system variable values is the essential step to get the correct server behavior against the workload. In MySQL, we have many System variables that can be changed at runtime, and most of them can be set at the session or global level.To change the value of a system variable at the global level in the past, users needed to have SUPER privileges. Once the system variable value is modified as global, the server will change this behavior for the session, and obviously as global scope.For instance, one of the most commonly ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; (Last Updated On: August 13, 2019) Introduction In this article, we are going to see how we can limit the SQL query result set to the Top-N rows only. Limiting the SQL result set is very important when the underlying query could end up fetching a very large number of records, which can have a significant impact on application performance. Why limit the number of rows of a SQL query? Fetching more data than necessary is the number one cause of data access performance issues. When a given business use case is developed, the ... Read More

Feed: Planet MySQL; Author: Marco; To set correct system variable values is the essential step to get the correct server behavior against the workload.  In MySQL we have many System variables that can be changed at runtime, most of them can be set at session or at global scope.  To change the value of a system variable at global level in the past user need to have SUPER privileges. Once the system variable value is modified as global, the server will change his behavior for the session, and obviously as global scope. For instance, one of the most commonly adjusted ... Read More

Feed: Redis Labs. Author: Chris Cheung. Successful applications tend to become complex over time. A microservices architecture offers the ability to decompose your app into many loosely-coupled services organized around business capabilities, thereby alleviating some of the complexities. Of course, microservices are not a free lunch, but for most large, complex apps, they allow teams to deploy new features faster, scale more easily, and pick the best technology stacks. But what about distributed data? Each microservice is able to select the right database for the right job by employing a data model based on key-value, graph, hierarchical, JSON, streams, search, and ... Read More

Feed: CronJ. Author: Pavan Kalyan; Before diving deep in the comparison of SQL vs NoSQL databases, let us first know about both the types in brief. SQL or Structured Query Language is a programming language that is typically used to manage data in relational databases. Relational databases use tables to store data and then develop insights from that data by using common characteristics within the dataset. A relational database uses SQL to create both data and the schema for that data, which describes fields in columns. Every record in this is called a row. On the other side NoSQL, is ... Read More