A complete guide to MySQL in Kotlin — connecting with JDBC, HikariCP connection pooling, CRUD with PreparedStatement, transactions, the Exposed ORM with its DSL and DAO APIs, Flyway migrations, and good repository patterns.
A complete guide to Microsoft SQL Server in Kotlin — JDBC connections with the SQL Server driver, HikariCP, CRUD with PreparedStatement, distinctive T-SQL features, the Exposed ORM with MSSQL, Windows Authentication, stored procedures, and the differences from MySQL.
A complete guide to Oracle Database in Kotlin — JDBC connections with ojdbc, HikariCP, Oracle SQL differences from MySQL, SEQUENCE for auto-increment, DUAL, ROWNUM and FETCH pagination, CLOB, PL/SQL stored procedures, the Exposed ORM with Oracle, and Flyway.
A complete guide to PostgreSQL in Kotlin — JDBC connections with PgJDBC, HikariCP, distinctive PostgreSQL data types, JSONB, arrays, enums, CRUD with PreparedStatement, ON CONFLICT upserts, the Exposed ORM, full-text search, Flyway migrations, and performance tips.