SQL
SQL joins explained — inner, left, right and full outer — with examples.
- Databases
Blog
8 articles on databases.
SQL joins explained — inner, left, right and full outer — with examples.
Migrating a MySQL database to PostgreSQL with pgloader, step by step.
JDBC connection pools, driver and DataSource classes per database, and local versus XA transactions.
JPA recipes: type mappings, sequence generators, dynamic persistence units, bulk updates and many-to-many with extra columns.
Apache Derby, the embedded Java database: the ij tool, connection URLs and common SQL tasks.
Running SQL Server in Docker and connecting to it with jTDS and a JDBC connection pool.
PostgreSQL cheat sheet: installation, import and export, useful psql queries and migrating from MySQL.
MySQL cheat sheet: upgrading to 8.x, users and privileges, password resets and data migration.