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