Our great sponsors
|over 5 years ago||3 days ago|
|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.
We haven't tracked posts mentioning kt-postgresql-async yet.
Tracking mentions began in Dec 2020.
Flyweight: An ORM for SQLite
9 projects | news.ycombinator.com | 29 Sep 2022
You would really like sqldelight 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
6 projects | reddit.com/r/programming | 1 May 2022
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).6 projects | reddit.com/r/programming | 1 May 2022
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.
How do you guys go about the persistence layer?
6 projects | reddit.com/r/java | 23 Mar 2022
Something I'll add because it hasn't been mentioned yet is sqldelight.
Getting Started With Kotlin Multiplatform Mobile
7 projects | dev.to | 17 Feb 2022
Some Libraries That Work Really Well SQLDelight as the name implies, this library is for dealing with SQL on all platforms that KMM supports. It's somewhat easy to use and works extremely reliable, plus has a very active community.
What are the most common used (3rd party) libraries and frameworks used in Android development?
30 projects | reddit.com/r/androiddev | 7 Jan 2022
Persistence: Room, SqlDelight
Do you use kotlin/js?
5 projects | reddit.com/r/Kotlin | 4 Jan 2022
Now if you're just writing a crud app (what my hobby project is) and you use compose multiplatform for your UI, SQLDelight for persistence, and one of the many MPP architecture libraries, you don't have to write a wrapper.
Creating a type-safe WHERE clause DSL using Kotlin
4 projects | reddit.com/r/Kotlin | 1 Jan 2022
I did not know about SQLDelight! Thanks for sharing that. I just took a quick look at it. From what I saw, it might not work for my use case. But I'm not 100% sure unless I spend a few hours actually trying it out. I'm building a library where the database tables are already defined by the system. I'm talking about the Contacts Provider. Let me know if you think that it's possible. Otherwise, I'll give it a try when I miraculously get some free time lol.
Odd request - need an ear. Updating to Room from direct SQLite code..
2 projects | reddit.com/r/androiddev | 27 Dec 2021
may i suggest instead: SQLDelight
Do you contribute to open-source android projects?
3 projects | reddit.com/r/androiddev | 22 Nov 2021
i once clarified a getting started doc for SQLDelight (not strictly Android-only, but has Android variant). it's not much, but it's honest work
What are some alternatives?
Exposed - Kotlin SQL Framework
Realm Asset Helper - A small library to help with Realm.IO integration in Android apps
RoomAsset - A helper library to help using Room with existing pre-populated database [DEPRECATED].
jOOQ - jOOQ is the best way to write SQL in Java
Ktorm - A lightweight ORM framework for Kotlin with strong-typed SQL DSL and sequence APIs.
DBFlow - A blazing fast, powerful, and very simple ORM android database library that writes database code for you.
ObjectBox Java (Kotlin, Android) - Java Database for Mobile & IoT - fast and lightweight
Nitrite Database - Java embedded nosql document store
GreeDAO - Android Database Performance Benchmarks
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.
jasync-sql - Java & Kotlin Async DataBase Driver for MySQL and PostgreSQL written in Kotlin