|7 days ago||4 days ago|
|Apache License 2.0||GNU General Public License v3.0 or later|
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.
Android Starter Template (hilt, ktor, coroutines, flow, modules, gradle.kts, version catalog, compose, MVVM, tests, GitHub CI)
2 projects | reddit.com/r/androiddev | 21 Nov 2022
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
3 projects | reddit.com/r/rust | 30 Oct 2022
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
7 projects | reddit.com/r/typescript | 16 Oct 2022
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
9 projects | news.ycombinator.com | 15 Oct 2022
SQLDelight had neat built in support for this
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
MyBatis VS jOOQ - a user suggested alternative
2 projects | 25 Nov 2022
It's listed here: https://www.libhunt.com/l/java/topic/orm, but not as an alternative
Are there any reasons for not using SQLite as an embedded DB in a Spring Boot web app?
2 projects | reddit.com/r/java | 12 Oct 2022
ORMs have poor support of SQL in general. Personally, I recommend jOOQ instead of ORMs: https://www.jooq.org/ It's faster, easier to use, no magics, and the whole SQL syntax.
what is the most famous java application that you've worked on?
4 projects | reddit.com/r/java | 9 Oct 2022
I made jOOQ
No ORM 1:M Relationship
4 projects | reddit.com/r/golang | 17 Sep 2022
But it’s still worth learning SQL well. Go has a lot of libraries to work with SQL directly, eg sqlc. The Java world has jOOQ.
Ask HN: Anyone joined a company after contributing to their OSS projects?
9 projects | news.ycombinator.com | 15 Sep 2022
I made https://www.jooq.org. Then hired myself in the company I created to maintain jOOQ
The Rise of SQL
2 projects | news.ycombinator.com | 1 Sep 2022
> If you do any kind of dynamic SQL it can get pretty gnarly though
This can be addressed with typesafe SQL-builders like jooq . I got an OLAP application with plenty of gnarly SQL broken up in individual business rules.
The best is that I don't even touch the SQL much. I expose it read-only to the users, hidden under an advanced mode button; and when they want to change things it often comes already written in SQL (mostly filters and projections). New queries come in requests to mix already-existing parts. And it helps technical knowledge be shared. Win-win all around.
Jooq works well with CRUD/OLTP apps as well. And when you have a problem, you don't have to debug both the ORM and SQL.
> Then it's important to learn how to optimize performance.
Starting with IO at the db level, and execution plan in the db. And ending right there without an ORM. Neither you nor your ORM are going to be smarter than the planner. For starters do you even collect statistics about your data? And your ORM doesn't even know what the downstream processing will be.
> Lastly ORMs deal with the issues an application typically has to deal with anyways. Such as mapping to objects,
Hopefully included with the typesafe SQL builder, but not always needed.
> detecting changes,
Plenty of SQL features for an audit trail
Well maybe there. But if read-availability is your problem, reading from replicas gets you very far.
Comes out of the box with MVCC RDBMS; ie good'ol postgres, mysql
I'm not going back to ORMs
How do access sql through java in the real world?
5 projects | reddit.com/r/javahelp | 30 Aug 2022
JOOQ -- http://www.jooq.org
Optimizing Nested Loop joins on YugabyteDB with jOOQ
2 projects | dev.to | 4 Jul 2022
If you use jOOQ, everything about SQL becomes easier to code and the barrier between dynamic and static SQL is small as all are typesafe.
Deepkit – High-Performance TypeScript Framework
13 projects | news.ycombinator.com | 7 Jun 2022
Cool jooq-query-syntax-like ORM! https://deepkit.io/library/orm
It does not seem to have the code-generation (for the db table DTOs) though.
I also like typescript's "string & MinLength<3> & Email" type combining.
A quick edit-test-loop must be a great selling point of this kind of FW compared to FW in more strongly types languages (that have slower edit-test-loops due to compilation) that I usually prefer.
What is a simple way to read from a Oracle DataBase and write to a text file, not using Spring Batch (but using Java)? Too complicated for Spring Batch.
3 projects | reddit.com/r/javahelp | 17 May 2022
There are also attempts to write queries in another DSL than the already commonly known and accepted SQL (or JPQL and Criteria API with the JPA specification/standard). One prominent candidate would be jooq: https://www.jooq.org/
What are some alternatives?
Querydsl - Unified Queries for Java
JDBI - jdbi is designed to provide convenient tabular data access in Java; including templated SQL, parameterized and strongly typed queries, and Streams integration
Exposed - Kotlin SQL Framework
Spring Data JPA - Simplifies the development of creating a JPA-based data access layer.
Realm Asset Helper - A small library to help with Realm.IO integration in Android apps
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
Speedment - Speedment is a Stream ORM Java Toolkit and Runtime
sql2o - sql2o is a small library, which makes it easy to convert the result of your sql-statements into objects. No resultset hacking required. Kind of like an orm, but without the sql-generation capabilities. Supports named parameters.
Presto - The official home of the Presto distributed SQL query engine for big data
RoomAsset - A helper library to help using Room with existing pre-populated database [DEPRECATED].
requery - requery - modern SQL based query & persistence for Java / Kotlin / Android
blaze-persistence - Rich Criteria API for JPA providers