SQLDelight 2.0 with PostgreSQL Sample

A sample project exercising PostgreSQL with SQLDelight 2.0 on JVM

This is an exploration of the official guide at https://cashapp.github.io/sqldelight/2.0.0/jvm_postgresql/ with the intention of filling in missing pieces.

✍️ Blog

See blog post on medium for quick guide and explanation.

🚗 Test Drive

To run the sample app, you need to do the following

1. Git clone the repo
2. Rename/copy sample-local.properties into local.properties
   i. Update all app configurations like db_host, db_password, and so on
3. Create the database with the name that matches db_name config
4. Build the project to generate SQLDelight classes (e.g. PlayerQueries) i. Run ./gradlew build or ./gradlew generateMainDatabaseInterface
5. Run app from Main.kt

📚 Resources

• https://cashapp.github.io/sqldelight
• https://jdbc.postgresql.org/documentation/use/
• https://github.com/brettwooldridge/HikariCP#readme