Alejandro Duarte articles - 33 total
Keyword vs. semantic search with AI
When building search for an application, you typically face two broad approaches: Traditional...
What can go wrong when using database transactions?
Note: This is an excerpt from an unedited version of my book MariaDB for Developers. To this point,...
Disaster Recovery and AI Vectors in MariaDB Kubernetes Operator 25.08.0
The latest MariaDB Kubernetes Operator release, version 25.08.0, is now available. This ships with...
Can You Run a MariaDB Cluster on a $150 Kubernetes Lab? I Gave It a Shot
If you're like me, learning how to run databases inside Kubernetes sounds better when it's hands-on,...
Vector Storage, Indexing, and Search With MariaDB
When you develop generative AI applications, you typically introduce three additional components to...
Supercharge Your App: MariaDB In-Memory Tables as a Cache
Redis is mainly used as an application cache or a quick-response database. But wait, you can always...
Packages for Store Routines in MariaDB 11.4
MariaDB 11.4 introduced many advanced features. One that grabbed my attention is the general support...
Using Temporary Tables in MariaDB
Let's explore how temporary tables work in MariaDB. First, we have to connect to the server. For...
Why do We Need Databases and SQL?
SQL has a long and proven history. It has survived the fuss around NoSQL. And even if not perfect, it...
Fast Analytics with MariaDB ColumnStore
Slow query times in large datasets are a common headache in database management. MariaDB ColumnStore...
MariaDB, MySQL, and Node.js: Why Using the Right Connector Matters
MariaDB was born as a fork of MySQL, one of the most used open-source relational databases out there....
Scaling Databases: A Developer's Journey
In the vast world of software development, navigating the world of databases is quite an adventure....
Getting started with SkySQL using Java, JavaScript, and Python
Unless you have a single server running on-prem with quick physical access to it and no need for high...
Building a 32-Core Raspberry Pi Cluster From Scratch
A Raspberry Pi is a mini-computer board to which you can connect a monitor, mouse, and keyboard, and...
Your Old Laptop Is Your New Database Server
A couple of weeks ago I almost accidentally found in my apartment an old laptop that was only...
How to Configure VS Code for Java in 2022
I recently shifted from IntelliJ IDEA Ultimate to Visual Studio Code (VS Code) and I have no regrets!...
Getting Started With JPA/Hibernate
JPA was born as the acronym for Java Persistence API. When Java EE was donated to the Eclipse...
JDBC Tutorial Part 3: Using Database Connection Pools
In part 3 of this tutorial series, you’ll learn what a database connection pool is and how to use it....
JDBC Tutorial Part 2: Running SQL Queries
In Part 2 of this tutorial series, you’ll learn how to execute SELECT, INSERT, UPDATE, and DELETE...
JDBC Tutorial Part 1: Connecting to a Database
In this series of articles (and videos), you’ll learn the basics of Java Database Connectivity, most...
How to Check if a Java Project Depends on A Vulnerable Version of Log4j
The Log4j vulnerability tracked as CVE-2021-44228 (also known as Log4Shell) allows an attacker to...
Is the MariaDB JDBC driver affected by the Log4j vulnerability?
Is the MariaDB Java connector affected by the security vulnerability recently discovered in Log4? By...
Improving Backend Performance, Part 3/3: Fast Analytics
Analytics involves the computation of data to find patterns. From simple calculations - such as the...
Improving Backend Performance Part 2/3: Using Database Indexes
Database indexes are a concern of the developers. They have the potential to improve the performance...
Improving Backend Performance Part 1/3: Lazy Loading in Vaadin Apps
If you have a table or data grid with, say, more than a few hundred rows in it, you should be using...
Testing MariaDB ColumnStore performance
MariaDB's ColumnStore is an engine that stores data in a columnar fashion. Although it shines in...
Realistic Test Data Generation for Java Apps
The closer your test or demo data is to the real world the better you can test the application for...
Learn How To Implement Web GUIs in Java
The world of JavaScript offers useful and fun-to-use web frameworks, there's no doubt about it. For...
Packaging and deploying Spring Boot applications as WAR files
This guide explains how to: Package a Maven-based Spring Boot application as a WAR file Deploy a...
Visually Designing Views for Java Web Apps
In this article, I'll show you how to visually design GUIs by dragging and dropping UI components...