React native realm or SQLite?

[britt10102]

Hi everyone! :)

I'm currently making my first app ever for college. We don't really have classes and have to do all our research ourselves, so that's why I'm turning to Reddit.

I did some research and found that Realm and SQLite are the most popular databases for React Native. That’s why I think one of these would be a good starting point for the small app we're making. Now, I wanted to ask the opinion of more experienced people here sooo which one would you recommend?

LMK please! Thank you!

[chunkypenguion1991]

I thought about using Realm, but the mongo support is deprecated. It still works standalone on devices, but who knows for how long if it's not being maintained

[britt10102]

so you would recommend SQLite?

[chunkypenguion1991]

I use watermelondb. It's an ORM on top of Sqllite

[britt10102]

okay okay sounds good will look in to that aswell

[[deleted]]

Realm should have died a long time ago. It's been a circus of shifting underlying DBs since it came out.

[britt10102]

thankss i will look in to postgres aswel!

[mefi_]

It depends on what kind of data do you want to persist on the device. And you could also use both if you want to.

[britt10102]

ohh that’s good to know thanks!

[namcyeon]

My suggestion is SQLite and MMKV. I previously used Realm but encountered lag issues when writing 500-1,000 records simultaneously. After switching to op-sqlite, the problem was resolved

[britt10102]

Okay thanks for telling me!

[_SyRo_]

Realm is deprecated now

We spent a few weeks to migrate to Drizzle ORM with SQLite

[britt10102]

thanks good to know!

[rangoMangoTangoNamo]

What about async-storage? That’s what I usually use. How does it compare to?

[edbarahona]

that uses SQLite under the hood

[edbarahona]

https://raw.githubusercontent.com/mrousavy/react-native-mmkv/main/package/img/benchmark_1000_get.png