Showing posts with the label Databases
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

How to call a Java method from a JavaScript function in the browser

In this video I demonstrate how to call a Java method that runs in the server f…

Building a Kubernetes cluster on Raspberry Pi (with automation)

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

Testing MariaDB ColumnStore performance

MariaDB 's ColumnStore is an engine that stores data in a columnar fashion…

Recent Comments

Contact Me