Skip to content
1 min read

SQL

SQL joins explained — inner, left, right and full outer — with examples.

  • Databases
1 min read

Database Migration

Migrating a MySQL database to PostgreSQL with pgloader, step by step.

  • Databases
2 min read

JDBC

JDBC connection pools, driver and DataSource classes per database, and local versus XA transactions.

  • Java & Jakarta EE
  • Databases
5 min read

Persistence

JPA recipes: type mappings, sequence generators, dynamic persistence units, bulk updates and many-to-many with extra columns.

  • Java & Jakarta EE
  • Databases
1 min read

Derby

Apache Derby, the embedded Java database: the ij tool, connection URLs and common SQL tasks.

  • Databases
  • Java & Jakarta EE
1 min read

MSSQL

Running SQL Server in Docker and connecting to it with jTDS and a JDBC connection pool.

  • Databases
4 min read

PostgreSQL

PostgreSQL cheat sheet: installation, import and export, useful psql queries and migrating from MySQL.

  • Databases
7 min read

MySQL

MySQL cheat sheet: upgrading to 8.x, users and privileges, password resets and data migration.

  • Databases

Type to search the whole site.