Ktorm
SQLDelight
Our great sponsors
- Appwrite - The open-source backend cloud platform
- Onboard AI - Learn any GitHub repo in 59 seconds
- Revelo Payroll - Free Global Payroll designed for tech teams
- SonarQube - Static code analysis for 29 languages.
- InfluxDB - Collect and Analyze Billions of Data Points in Real Time
Ktorm | SQLDelight | |
---|---|---|
5 | 31 | |
1,833 | 5,497 | |
0.8% | 0.9% | |
0.0 | 0.0 | |
23 days ago | 5 days ago | |
Kotlin | Kotlin | |
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Ktorm
- How are you all handling database persistence?
-
Writing to db
I have been ktorm(https://www.ktorm.org) for a long time, and it suit with kotlin's stream operation very well
-
jOOQ 3.17.0 release with client side computed columns, audit columns, pattern matching, reactive transactions and kotlin coroutine support
I mean, I'm looking at this, for example: https://github.com/kotlin-orm/ktorm/tree/master/ktorm-core/src/main/kotlin/org/ktorm/dsl, so I wonder, what would be gained from a matrix?
-
Performance Improvements in .NET 6
First google hit for "Kotlin ORM": https://github.com/kotlin-orm/ktorm
SQLDelight
- I'm creating a REST API using KTOR. What's the best ORM to go with KTOR ?
-
KMM alternatives to Android Datastore & Room DB?
That functionality has existed for almost exactly a year
-
Adopting Kotlin Multiplatform Mobile(KMM) on 9GAG App
Database - SQLDelight
-
Android Starter Template (hilt, ktor, coroutines, flow, modules, gradle.kts, version catalog, compose, MVVM, tests, GitHub CI)
room is a great example but like I said our data is kotlin-only so we tend to use libraries like sqlDelight.
-
Announcing new crate - "hugsqlx": turning SQLx queries into Rust functions
This seems similar to https://cashapp.github.io/sqldelight/ for kotlin, I think this approach is pretty neat, good luck with it!
-
ADVICE WANTED - Typescript PostgreSQL without ORM
Sounds like you want what SQLDelite offers, but for TypeScript. SQLDelite is only for Kotlin and SQLite though.
-
Why We're Moving on from Firebase
SQLDelight had neat built in support for this
-
Flyweight: An ORM for SQLite
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).
-
"ORMs have a special place in my heart, not entirely unlike Brutus and Caesar: a dear friend who betrays you and leaves you to die a slow, painful death." – Taming SQL and ORMs with sqlc
SqlDelight is an equivalent library in the Kotlin/JVM ecosystem that follows the same philosophy (write queries in SQL and generate code from them rather than the opposite approach taken by typical ORMs).
The only reason I haven't tested SQLDelight a lot is because they haven't implemented a way to "rename" a table when generating the classes, so if your table is called players... well, now all of the generated classes will also be named Players, which is super annoying.
What are some alternatives?
Exposed - Kotlin SQL Framework
Realm Asset Helper - A small library to help with Realm.IO integration in Android apps
jOOQ - jOOQ is the best way to write SQL in Java
RoomAsset - A helper library to help using Room with existing pre-populated database [DEPRECATED].
kotlin-jpa-specification-dsl - This library provides a fluent DSL for querying spring data JPA repositories using spring data Specifications (i.e. the JPA Criteria API), without boilerplate code or a generated metamodel.
ObjectBox Java (Kotlin, Android) - Java and Android Database - fast and lightweight without any ORM
MapDB - MapDB provides concurrent Maps, Sets and Queues backed by disk storage or off-heap-memory. It is a fast and easy to use embedded Java database engine.
Realm - Realm is a mobile database: a replacement for Core Data & SQLite
Ebean ORM - Ebean ORM
jasync-sql - Java & Kotlin Async DataBase Driver for MySQL and PostgreSQL written in Kotlin