What is JPA?
JPA stands for Jakarta Persistence API (previously, Java Persistence API). It's an API specification for database connectivity in Java a...
Showing posts with the label Databases
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)
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
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
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...
Load More
No More Posts!
