SQLDelight VS ktor

This seems to be similar to https://github.com/cashapp/sqldelight, and I've always wanted a python equivalent!

In typescript, there are query builders (not talking about ORMs) that can basically do this within the type system, but that would be infeasible in python's type system. This approach (type/code generation is a good alternative, though I like using sqlalchemy / alembic to manage schemas/migrations.

One thing I'm curious about is how it knows the types of columns? I looked quickly at the Readme but didn't see it (probably a parameter somewhere I missed).

That functionality has existed for almost exactly a year

- SQLDelight - great experience overall, the only issue that I found, was when that I made a database migration that worked on Android, but not on iOS (https://github.com/cashapp/sqldelight/issues/3812)

Database - SQLDelight

room is a great example but like I said our data is kotlin-only so we tend to use libraries like sqlDelight.

This seems similar to https://cashapp.github.io/sqldelight/ for kotlin, I think this approach is pretty neat, good luck with it!

Sounds like you want what SQLDelite offers, but for TypeScript. SQLDelite is only for Kotlin and SQLite though.

SQLDelight had neat built in support for this

https://cashapp.github.io/sqldelight/

You would really like sqldelight[1] then. It takes the concept of an ORM and flips it on its head. Instead of mapping function calls to SQL statements, it lets you write SQL statements and then generates classes for you that have methods for those statements.

For instance, you could have a SQL statement like getCardsForFight: select * from fights where cardId = ? and titleFight = ?, and it would generate a class that has a method getCardsForFight(cardId: number, titleFight: number).

[1]: https://github.com/cashapp/sqldelight

Ktor, a powerful web framework built with Kotlin, offers a lightweight and flexible solution for building web applications. In this article, we will guide you through the process of creating a Ktor project manually using Gradle and SDKMAN!. By following the steps below, you'll have a basic Ktor project up and running in no time.

take a look at http4k and ktor for Kotlin specific frameworks Spring has first class support for Kotlin e.g. the following will give you reactive HTTP endpoints when using spring-webflux (this is what is use at work):

Ktor (Microservices framework by JetBrains)

For Android you should use a more mobile friendly framework like Retrofit or if you use Kotlin you can use the multi-platform Ktor library with it's client module

And last but not least, Ktor Client as our HTTP client. https://ktor.io/ It's a pretty amazing http client library and integrates well with Kotlinx serialization and Coroutines.

Kotlin is going to be great with almost every single JVM server. Spring works well with Kotlin, and is directly supported, but spring is also massive, very bloated. I recommend looking at https://github.com/ktorio/ktor which continues to serve all of my needs very well, integrates fantastically with Kotlin coroutines, and has very fast startup time and very good performance.

For the sake of the test, we use Ktor - the easiest way to do so is to use initializer.

I know you are looking for Spring Boot and/or Quarkus, but have you tried ktor. Just curios if you had a particular reason for choosing the other 2. Disclaimer: I haven't used ktor.

Check https://ktor.io it's from JetBrains and amazing.