In-memory databases are a common occurrence with unit tests, so let's take a look at how to remotely connect to an instance if you need to, say, debug some data or tests.
Need to query within embedded documents? This example takes us through using Couchbase's N1QL query for objects in a nested array in a single document.
When it comes to the Enterprise, two cloud databases are going after it. Amazon's Aurora is MySQL compatible, whereas Google's CloudSpanner scales out.
When we tried to restore a failed procedure, we got an error saying that the BINLOG statement couldn't be used to apply Query events. The workaround is simple.
Importing CSVs is a great timesaver, but how do you get around the null values lurking within? Fortunately, we can work our way toward a query that handles them in Neo4j.
This comprehensive guide will walk you through every step you need to take to create and configure editable tables in JavaFX, including handling a bug in the code.
Accessing and configuring your MS SQL Server instance is pretty simple if you're using Spring Boot. After a bit of legwork, Spring fills in the defaults for you.
If you want to use SAS SQL for your queries, there are some subtle syntax differences that you might not be ready for. Here's how to use some core joins.
Taking a page from Maslow's Hierarchy of Needs, this effort examines what microservices need from the org, orchestration, and infrastructure — all with a cloud bent.
If you like XML's handy hierarchical style and the familiarity of Java, you're in luck: You can quickly parse your XML data and put it into a MySQL database with ease.
This is the fourth in a series of blog posts examining technologies such as Angular that are driving the development of modern web and mobile applications.
If you care about your data, then I recommend not using Group Replication in production. It looks like it may cause headaches—and it's easy to get inconsistent results.
