You can try using jOOQ, a data access technology, and experience Spring development with Kotlin.
You can learn Spring development with Kotlin.
You can try using jOOQ as a data access technology.
Try using a MySQL database.
Experience Spring with Kotlin and use jOOQ as a data access technology
When using JPA, there are times when you need to use complex queries, and in such cases, you need to use jdbc template or respond with native query. In doing so, there is a risk of using an incorrect query, and you may accidentally write code that causes errors at runtime. That is why I pursued type safety and became interested in a data access technology called jOOQ.
Key features of jOOQ
Type safety
Detect SQL query errors at compile time
Avoid referencing non-existent tables/columns
Preventing incorrect type mappings
Generate database schema code
Powerful query builder DSL
Database independence
Automatic query optimization
This is not a conceptual lecture on jOOQ.
This is a lecture that practices basic CRUD using jOOQ.
Therefore, it is not suitable for those who want to study the concept.
jOOQ lets you write SQL in code rather than strings.
You can write type-safe SQL queries.
SQL written in code
Practice requesting data from a client and sending data.
You can use convenient features such as Kotlin's extension functions.
Some of GlobalExceptionHanlder
Flyway is a database schema version management tool.
Manage database changes by version
Track and manage change history like Git
flyway schema history
Operating System and Version (OS): Windows, macOS,
Tools used: The lecture uses the paid version of IntelliJ IDEA, so you may not be able to participate when using some functions. DB connection and HTTP API requests are made using IntelliJ IDEA functions. Those who can use terminal or POSTMAN instead are fine.
The database uses MySQL. MySQL runs on Docker, and if you have MySQL in your local environment, you can follow the lecture with that DB.
PC specifications: Any normal computer should be able to keep up.
The required learning materials, such as the docker-compose script, are listed at the bottom of the lecture, and we will consider making them into lecture materials upon request and provide them.
jOOQ makes you write code similar to SQL queries, so it is recommended to know SQL. Basic SELECT, INSERT, UPDATE, DELETE SQL is enough.
Please take into consideration that the video and audio quality of the lecture is not very good.
Who is this course right for?
Someone curious about how to use Spring with Kotlin
Anyone who wants to quickly try out jOOQ
Anyone who wants to write type-safe SQL
Need to know before starting?
Java
Kotlin
MySQL
sql
Career Verified
Hello
I am KotlinJava, a full-stack developer.
My main language is Kotlin,
these days, I am developing in various languages.
All
36 lectures ∙ (5hr 33min)
All
2 reviews
4.5
2 reviews
Reviews 27
∙
Average Rating 5.0
5
The way you manage schemas with Flyway was particularly impressive, and it resolved a lot of the frustrations I felt while using JPA or MyBatis! Since it was Kotlin-based, I enjoyed the lectures even more, and I was able to apply it to my work immediately. Thank you! 👍🏻
I've been so busy with work that I didn't see the review. Thank you so much for writing such a great review!!!
Reviews 17
∙
Average Rating 4.6
Explore other courses in the same field!
25% off for new members
$24.10
25%
$34.10
![[Beginner] Let's Eat! Create Membership with Kotlin and Spring Security + JWTCourse Thumbnail](https://cdn.inflearn.com/public/courses/331379/cover/4208402d-5885-44b1-865f-c88cb84a57e3/331379-eng.png?w=420)
.png?w=420)
![[Beginner] Let's tear it apart! Everything about KotlinCourse Thumbnail](https://cdn.inflearn.com/public/courses/332581/cover/05f06c6b-d021-4979-8b08-2aaa3a9367eb/332581-eng.png?w=420)
