Databases Resources

The first thing to look at to start optimizing a query is the Query Planner. In this post, we explain how a query gets executed and how to understand the EXPLAIN command.

April 23, 2021

by Everett Berry

· 5,616 Views · 1 Like

Hybrid Multi-Cloud Event Mesh Architectural Design

Building the event mesh with Camel

April 23, 2021

by Christina Lin

CORE

· 11,515 Views · 7 Likes

Building an Angular Bot With AWS Lex

Here's an in-depth guide to building your own Angular chatbot.

Updated April 21, 2021

by Amar Deep Singh

CORE

· 18,831 Views · 6 Likes

Graph-Based Data Science, Machine Learning, and AI

What does graphing have to do with machine learning and data science? A lot, actually — learn more in The Year of the Graph Newsletter's Spring 2021 edition.

April 20, 2021

by George Anadiotis

· 9,304 Views · 5 Likes

Spring Data JPA + QueryDSL: Taking the Best From Both Worlds

An example of combining the two most powerful frameworks for building a maintainable and type-safe persistence layer; from Spring Data JPA we will take only CRUD operations and for all complex queries we will use QueryDSL.

Updated April 18, 2021

by Dmytro Stepanyshchenko

· 27,643 Views · 5 Likes

Data Ingestion From RDBMS: Leveraging Confluent's JDBC Kafka Connector

Kafka Connect assumes a significant part for streaming data between Apache Kafka and other data systems. Importing data from the Database set to Kafka topic.

April 17, 2021

by Gautam Goswami

CORE

· 7,082 Views · 3 Likes

Most Common IaaS Security Issues and Ways To Mitigate Them

IaaS security issues are the most critical concerns for both users and providers alike, which need to be solved for high performance.

Updated April 16, 2021

by Akash Bakshi

· 6,670 Views · 2 Likes

Audit Database Changes With Debezium

In this article, we will explore Debezium to capture data changes. Debezium is a distributed open-source platform for change data capture. Point the Debezium...

Updated April 16, 2021

by Siva Prasad Rao Janapati

· 15,581 Views · 2 Likes

How to Delay Database Connection Acquisition in Hibernate (Spring Data)

In the case of resource-local (a single data source), Hibernate will acquire the database connection of a JDBC transaction right after the transaction starts.

April 16, 2021

by Anghel Leonard

CORE

· 14,509 Views · 5 Likes

Working With dotConnect for Oracle in ASP.NET Core

The article discusses the striking features of dotConnect for Oracle (a fast ORM for Oracle from Devart) and shows how to work with it in ASP.NET Core.

April 15, 2021

by Joydip Kanjilal

CORE

· 9,687 Views · 2 Likes

Working With Stored Procedures Using dotConnect for Oracle

The article discusses the striking features of dotConnect for Oracle and shows how to work with stored procedures and dotConnect for Oracle in ASP.NET Core 5.

April 15, 2021

by Joydip Kanjilal

CORE

· 7,753 Views · 2 Likes

Python Memo 2: Dictionary vs. Set

A software architect takes a deep dive into the Python language by exploring dictionaries and sets and how these two elements of the language work.

April 15, 2021

by Eason YIN

· 16,090 Views · 2 Likes

Building Event-Driven Microservices That Scale

Event driven microservices are a rage since they provide teams with insane agility at scale. Here’s how you can set it up yourself.

April 14, 2021

by Noorain Panjwani

· 13,642 Views · 2 Likes

Nebula Flink Connector: Implementation and Practices

This post introduces Nebula Flink Connector. Like the pre-defined Flink connectors, it enables Flink to read data from and write data to Nebula Graph.

April 14, 2021

by Nicole Wang

· 5,758 Views · 1 Like

Can a Shift-Left Reduce OpEx Cloud Expenditures?

The cloud has moved from CapEX to OpEX, shifting cloud cost management left by empowering developers and giving them the tools to correlate cloud costs.

April 14, 2021

by Ohad Maislish

· 5,725 Views · 2 Likes

Busy or Lazy?: Design API in Anypoint Studio

Using Anypoint Studio 7.7 and later, we can create API specifications and fragments directly in our Anypoint Studio, or create API Specs in Design Center to be imported.

April 13, 2021

by Ruchi Saini

CORE

· 12,187 Views · 2 Likes

The Magic of Apache Spark in Java

An experience software architect runs through the concepts behind Apache Spark and gives a tutorial on how to use Spark to better analyze your data sets.

April 13, 2021

by Reza Ganji

CORE

· 39,192 Views · 21 Likes

Resolving SQL Connection Errors Due to SSL Certificate Issues

SSL certificates are very important for authenticating websites and ensuring connections are encrypted. However, there are some scenarios when they can create headaches.

Updated April 13, 2021

by Ryan Kh

· 23,424 Views · 4 Likes

Extended Events: Avoid the XML

I ditched the XML, and so can you!

April 11, 2021

by Grant Fritchey

· 6,459 Views · 3 Likes

SQLiteOpenHelper and Database Inspector in Android

Let's dive into using SQLite and Database Inspector for your next Android app.

April 11, 2021

by Thomas Plathanath Mathew

· 13,144 Views · 3 Likes

The Latest Databases Topics