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

Testing MariaDB ColumnStore performance

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

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…

New book - Practical Vaadin: Developing Web Applications in Java

I'm glad to announce the availability of my most recent book, Practical Vaa…

Recent Comments

Contact Me