That fact is the reason why I’ve never followed through on using jooq for a real project.

It's easy enough to automate with docker and a sql file. And since only one person on the project has to do it if the generated files are checked into source control the value you gain from jooq's typed API far exceeds the trouble of generating the code once the db's schema changes.

I would prefer if it generated it from sql.

It was too much hassle to have to set up all these little pieces to get code gen to work. The tooling turned me away. The concepts espoused by jooq I find attractive, the tooling they created keeps me at bay.

Run H2 in memory, apply schema scripts, run codegen?

You skipped a major step: setup codegen (which I found confusing when I was doing it)

another approach if you don't want to check in generated source code, is to treat the generated db sources as a separate module dependency: generate every time the schema changes, build a new jar artifact and then import into your projects as a dependency

How do you validate your classes? Using kotlins stdlib's check and validate or is there something else? How do you accuomulate errors?

@dh44t thanks!! Is there a sample app that i can see a "real life" use of it?

Im trying to figure out the best way to do the following: I have a Users rest controller with a mapping to update a user. User has name, email and phone number. I have 3 validation functions to validate each field. what will be the best way to validate the user before updating it? In case 2 of the properties are invalid i would expect to get an error on both

could just have a list of predicates

List<(User) -> ErrorMessage?>

you run against the user

it's kinda what that funktionale code is doing but with the unfortunate naming decision of

Disjunction

😄

Hello! I want to try way with safe sql and there are 2 libs: Exposed and Squash written by @orangy. Squash is used in fullstack sample, but last commit was 2 month ago and build failed 😞 What would you recommend me this way?

Build failed because some misconfig with Postgres. Haven’t had time to investigate it 😞

If there is any interest in using it, I can resume my work on it. I didn’t need it recently, hence suspended

I'm just trying it on my pet project with 20+ tables somehow linked with each other. Just want to understand if it is possible to use it in production and if can it be really useful. I like Squash architecture more than Exposed, so I will probably use Squash.

Feel free to ask questions 🙂

Hi Everyone - I'm wanting to mess around with making some Rest API's in Kotlin just out of curiosity. What are the most mature/popular frameworks I should be having a look at?

Spring Boot is extremely well-known and well-supported: https://projects.spring.io/spring-boot/

For something more lightweight, there is Spark: http://sparkjava.com/

Both of which have first-party Kotlin support

There is also #ktor, our own async web framework, entirely written in Kotlin 🙂

and Kovert (https://github.com/kohesive/kovert) which you can bolt into vert.x. Vert.x also has Kotlin support now.

And I might finish bolting Kovert onto Ktor soon, I finally have vacation time and it's high on my list.

@apatrida your feedback is always welcome!

does

anyQueryParamEmpty(vararg keys: String)

sound like a useful feature for a webserver?

anyQueryParamEmptyOrMoreThanOne

🙂