sugar VS SQLDelight

sugar

We haven't tracked posts mentioning sugar yet.
Tracking mentions began in Dec 2020.

SQLDelight

• querky – autogenerate Python functions and types for your SQL queries
  2 projects | news.ycombinator.com | 15 Dec 2023

  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).

• I'm creating a REST API using KTOR. What's the best ORM to go with KTOR ?
  2 projects | /r/Kotlin | 28 May 2023
• KMM alternatives to Android Datastore & Room DB?
  2 projects | /r/Kotlin | 24 Mar 2023

  That functionality has existed for almost exactly a year

• What were your negative experiences when adopting KMM?
  1 project | /r/Kotlin | 3 Feb 2023

  - 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)

• Adopting Kotlin Multiplatform Mobile(KMM) on 9GAG App
  4 projects | dev.to | 18 Dec 2022

  Database - SQLDelight

• Android Starter Template (hilt, ktor, coroutines, flow, modules, gradle.kts, version catalog, compose, MVVM, tests, GitHub CI)
  2 projects | /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 | /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 | /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

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

• Flyweight: An ORM for SQLite
  9 projects | news.ycombinator.com | 29 Sep 2022

  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