In this article, you will learn when you should consider adding JSON data types to your tables and when you should avoid it. Most relational database technologies can now store JSON data and perform queries on it. The introduction of the JSON data type to relational databases represented a turning point and opened up many […]
This is part of a series of articles about database-as-code (GitOps): Database as Code: The Good, the Bad, and the Ugly Database Version Control: State-based or Migration-based? What Is Database Schema Drift? The Database as Code Landscape (this one) The idea of codifying database schema changes (aka schema migration) is not new. Many engineering teams […]
Introduction In this article, we’re going to show you how to use the cURL library in PHP to make a non-traditional HTTP POST request. A Quick Look at Application A customer recently brought to me a unique challenge. My customer wants information requests from data to be collected in a database. Nothing new, right? Well, […]
Released back in 2012, Neo4j 1.8.M03 introduced the RELATE clause, a two-step dance of MATCH or CREATE. Also, new Transaction support in the shell lets you call for a do-over in case you misstep. RELATE, a Subgraph Match-Maker A RELATE clause looks a lot like a MATCH clause — the ASCII-art of graph traversals — but […]
I really like Maven, and I really like the declarative build style, but recently I finally came to understand why Gradle is better. For small projects that produce a common library JAR, you can still use Maven, but real-life, complex software projects always contain a lot of support scripts for deployment, copying artifacts, and so […]
The Emerging Value of Enterprise Cloud Backup There is no question that data is king when it comes to what companies need to manage and how they can do so. In fact, there are many companies that put a lot of effort into keeping their data safe and secure at all times, and that is […]
Kubernetes is a container orchestration platform today adopted by many companies. Its implementation requires a certain understanding of its ecosystem in order to deploy a cluster ready for production. Implementing working principles or tools is therefore essential and requires the work of all teams (operations, development, security, etc.) to promote the detection of anomalies as soon […]
Kubernetes cannot natively manage stateful applications like databases, especially when it comes to day-2 operations. It needs a specific network configuration, persistent storage, and dedicated computing capacity. All of this is done by Kubernetes operators. In this talk, Percona Product Manager Sergey Pronin explains why operators are needed to run MongoDB on Kubernetes and how […]
A microservice application is a group of distributed programs that communicate over networks, occasionally interfacing with third-party services and databases. Microservices, by their networked nature, provide more points of failure than a traditional monolith. As a result of this, we need a different, broader approach to testing. So, how do we test a microservice application? […]
With the release of 7.1, Couchbase N1QL adds support for JavaScript user-defined functions. Originally as seen in Part2: Views and UDFs and Part3: Stored Procedures, we used N1QL UDFs to map the MySQL UDFs and stored procedures. With N1QL UDFs, we can do only a single query or operation per function. This meant our translation […]