Databases

Thoughts on how MariaDB is incorrectly perceived merely as a fork of MySQL and how MariaDB is independent from MySQL yet highly compatible

How to build keyword and semantic search in MariaDB using Python, LangChain, and AI embeddings.

Concurrency phenomena are anomalies that every software developer should know.

What exactly is a Vector embedding in AI apps and how to use them in RAG architectures?

Learn how to set up and run AI embedding models locally with MariaDB to store and query vector embeddings efficiently.

Explore how to use MariaDB in-memory tables to boost your app’s performance and efficiency.

Explore the new feature of packages for stored routines in MariaDB 11.4 and how it enhances database development.

Learn how to simplify CRUD operations in MariaDB and MySQL using the REPLACE INTO statement.

Learn how to effectively use temporary tables in MariaDB for transient data operations.

Learn how to achieve high availability and resiliency in databases using MariaDB MaxScale with a practical demo.

Discover the essential role of databases and SQL in modern application development.

Discover how MariaDB ColumnStore can speed up your data analytics with a practical guide using Docker.

An introduction to MariaDB, its features, and its unique advantages over MySQL.

A recount of my talk on the evolution of MariaDB at an open-source event in Colombia.

A detailed account of my experience at Cloud Expo Europe 2023 in London.

An overview of database proxies, their advantages, and disadvantages.

A guide on setting up MariaDB replication.

An introduction to Jakarta Persistence API and its usage in Java applications.

An explanation of database connection pools and how to use them in Java applications.

Instructions on executing SQL queries in Java and preventing SQL injections.

Guide on opening and closing JDBC connections in Java.

A guide to testing the performance of MariaDB ColumnStore.

A detailed approach to handling large SQL tables for report generation.