How can I use alongside an ORM?

Question

How can I use alongside an ORM?

daybson opened this issue 4 years ago · 4 comments

daybson commented 4 years ago

Hi, I use this package in production for 1 year.

I was looking for some orm compatible with sqflite, but I don't know how could I make it works along sqlcipher.

Do you have any idea to help me?

Thank you!

Answer 1 · 2021-04-13T06:24:00.000Z

I've been using Moor for quite some time already and it is great. It supports encryption, which uses this library under the hood.

There are other ORMs for Sqlite but I haven't tried them out.

Answer 2 · 2021-04-23T20:21:14.000Z

I have been using this with "sqfEntity" plugin and works great. for my apps, MOOR is like cutting the butter by sword.

Answer 3 · 2021-04-23T21:23:36.000Z

sqfEntity

Could you give an example of how you do you open your encripted database using the orm?

Answer 4 · 2021-05-30T18:32:27.000Z

@daybson --> I used sqfEntity, added "sqflite_sqlcipher" to pubspec (as documented here) and it just worked. Just had to specify the password why creating database model (as per sqfenity documentation)