Showing posts with the label Databases
What is MariaDB?

What is MariaDB?

MariaDB is an open-source relational database management system that uses the Structured Query Language (or SQL) to manage and manipulate da...
My experience in Latin America presenting the evolution of MariaDB

My experience in Latin America presenting the evolution of MariaDB

Last week, I had the pleasure of giving a talk at the open source event organized by our partner Imagunet in Colombia. The talk, titled &qu...
My experience at Cloud Expo Europe - London 2023

My experience at Cloud Expo Europe - London 2023

I recently had the opportunity to attend the Cloud Expo Europe in London with our team at MariaDB , where we promoted SkySQL , our cloud da...
What is a Database Proxy?

What is a Database Proxy?

A proxy is a server software, typically installed in a separate machine, that forwards requests to servers on behalf of clients. When the p...
MariaDB replication demo

MariaDB replication demo

Database replication is a process that copies data from one database (primary) to another (replica). This process can happen as data is inse...
What is JPA?

What is JPA?

JPA stands for Jakarta Persistence API (previously, Java Persistence API). It's an API specification for database connectivity in Java a...
What is a database connection pool?

What is a database connection pool?

A database connection pool stores ready-to-use database connections that threads can borrow when they need them, and return when they fin...
How to execute SQL queries from Java (and prevent SQL injections)

How to execute SQL queries from Java (and prevent SQL injections)

You need a Connection object. See the previous post to learn how to get one. With this object, simply build a new PreparedStatement , set ...
How to open and close JDBC connections

How to open and close JDBC connections

Get a JDBC driver for your database. For example, in the case of MariaDB databases, you can add the following to the pom.xml file (or down...
Testing MariaDB ColumnStore performance

Testing MariaDB ColumnStore performance

MariaDB 's ColumnStore is an engine that stores data in a columnar fashion. Although it shines in distributed architectures where you h...

A strategy to manage large SQL tables

Some months ago, I got involved in a project where I needed to generate quite big reports (more than 1 million rows) extracted mainly from a...

Search

Popular Posts

What is a Database Proxy?

A proxy is a server software, typically installed in a separate machine, that …

ChatGPT as a MariaDB database

ChatGPT is truly impressive. You can instruct it to do all sorts of things whe…

Building a Kubernetes cluster on Raspberry Pi (with automation)

Some months ago, I was lucky enough to get a bunch of Raspberry Pi minicompute…

Recent Comments

Contact Me