Hi there :wave: I recently got the (wild) idea of ...

# server

[Skaldebane]

Hi there 👋
I recently got the (wild) idea of using Room as an ORM over SQLite on the server with Ktor.
Particularly with Room now becoming multiplatform, it can be run on any JVM target (as well as native Linux).

Maybe this is not the right place to ask, but are there any particular drawbacks to this? (aside from the maturity of the multiplatform version)

It's enjoyable to use on Android, and could probably make dealing with the DB a little easier server-side as well.

[jw]

This is not even remotely wild as far as ideas go. Sqlite works great from JVMs and natively. I've used it with millions of rows in tens of tables myself, and it has order of magnitudes more capability than that.

[Skaldebane]

Thanks for the response! I do know that SQLite is quite capable for server workloads (given it's properly configured), but my concern is more about using Room as an ORM.

[Skaldebane]

It (currently) has some restrictions made with mobile/app usage in mind (e.g. references between entities), but I don't mind them much and is otherwise pretty nice to work with.

[hfhbd]

What limitations do you have in mind, automatic entity fetching?

[hfhbd]

Regarding Ktor/server usage, we heavily use Sqldelight at work with different dbms (DB2 and Oracle).

[jw]

Yeah SQLDelight automatically code generates the stuff Room makes you write manually, so it could be worth a try. It's what I've used with sqlite on the server.

[Skaldebane]

@hfhbd Yeah that's what I was referring to.

[Skaldebane]

Thanks for the recommendation! I'm more familiar with Room, but I'll give SQLDelight a shot, looks pretty solid.

[dave08]

If youre jvm only theres also #C03JF82SDHA