SQL

General Resources

Vlad Mihalcea (Hibernate)

• Vlad Mihalcea on all things Java Persistence (MySQL, PostgreSQL, Hibernate, etc.)
• SQL Tutorials
• TSID – Time-Sorted Unique Identifiers much more efficient than using UUIDs
  • TSID Generator a Java library for generating TSIDs
• Audit logging using triggers With MySQL record all changes to a table in a “history”/”audit” table

MySQL

Table Partitioning

• Table partitioning in MySQL 8: A Practical Guide
• Table partitioning with Spring and Hibernate

Java / Kotlin / JDBC

• HikaryCP lightweight JDBC connection pool.
• JetBrains Exposed ORM for Kotlin