Realm VS SQLDelight

Presumably realm in Element for Android. https://realm.io/ "Realm by MongoDB"

See also https://github.com/vector-im/element-android/issues/1025

Looks really cool, I like to make very minimalistic dependency choices for the web apps I work on. Web Components look interesting and it's great to see frameworks that build upon it and provide features that are currently missing from it.

When I landed on the page I remembered another Realm framework I used a lot long time ago. https://realm.io has the same name and the logo looks very similar too. Not sure if it's a problem, just wanted to share. :)

Realm (Open Source but Sync is SaaS)

Realm is a fast, scalable alternative to SQLite with mobile to cloud data sync that makes building real-time, reactive mobile apps easy.

I would focus on Kotlin instead of Java, there's really no point in sticking to Java at this point. And when it comes to databases, some local ones that are pretty easy to get into are Realm and ObjectBox, SQLite can definitely be a bit overwhelming at the beginning.

So yeah, if you don't have a server with API which will store data for you - you should really look into CoreData and Realm

Try Realm.

Just to add to this, there's also Realm and ObjectBox as alternatives.

There is some crossover between the BaaS of Firebase and what MongoDB Atlas is offering if you are developing using Atlas Sync and Realm. Even so, there is a whole lot more you can find in terms of tutorials and community support for Firebase so it is hard to know how many of the Mongo claims are just future bugs for your project vs what people are currently doing with Firebase.

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

That functionality has existed for almost exactly a year

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

Database - SQLDelight

room is a great example but like I said our data is kotlin-only so we tend to use libraries like sqlDelight.

This seems similar to https://cashapp.github.io/sqldelight/ for kotlin, I think this approach is pretty neat, good luck with it!

Sounds like you want what SQLDelite offers, but for TypeScript. SQLDelite is only for Kotlin and SQLite though.

SQLDelight had neat built in support for this

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

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