hi all, i was wondering why `room` is not moving ...

# multiplatform

[brabo-hi]

hi all, i was wondering why room is not moving to kmm ?

[CRamsan]

I assume that it is because Room is a Google framework specifically designed to address Android issues. I dont think it is a priority for the Android team to expand it outside of where it is now. If you want multiplatform support, you can look at sqldelight.

[brabo-hi]

we are currently ising sqldelight i think the community could work to port room on KMM it could bring ios team to be interested in it

[jw]

What specifically do you need from Room that SQL Delight does not provide?

Other than the added boilerplate of having to manually maintain the database models rather than having them automatically generated based on your schema. blob grin

[brabo-hi]

we have android app using room, we are evaluating how to start migrating some parts into KMM, so the current choice we have is to use sqldelight

[jw]

Oh based on your statement above it sounded like you were currently using SQL Delight

[brabo-hi]

we have one app that is using sqldelight
and another app using room

[jw]

Sounds like you want an ORM

[jw]

Even room makes you write SQL, an ORM wouldn't

[jw]

Anyway we're never doing your first 1 or 2. 1 isn't something SQL does and we honor SQL first and most.

[Bradleycorn]

Yes, I DO want an ORM! Do you know of a good one for Android and/or KMM 😄

[jw]

No. ORMs are awful

[Bradleycorn]

hehe

[jw]

For your second 1, you don't have to instantiate an adapter for each column but you do supply one. This means you can alter the storage for the same type in different tables or even different columns

[jw]

Since you only configure this once per database and not once per query it's not really worth optimizing for only to make the case where you want different behaviors harder.

[Bradleycorn]

Right. You can do that with Room too (supply an adapter for a single table), but Room also allows you to supply the adapter once at the database level, and any table in the database that has a column of that type will use the adapter. So as you add new tables/columns, you don’t have to remember to “go supply the adapter”.

[Bradleycorn]

Anyway we're never doing your first 1 or 2. 1 isn't something SQL does and we honor SQL first and most.

I understand and respect that. Still, if I could pick one feature to be added, that would be it.