Moor (Room for Flutter) #1 – Tables & Queries – Fluent SQLite Database

📗 Learn from the written tutorial & get the project files 👇👇

👨‍💻 Do you write good code? Find out now 👇

Mobile apps and local databases go well together. If you want to take the relational database route, SQLite is the winner. However, the problem with bare bones SQL databases of any kind is writing queries and then integrating them with your other code.

Android solves this with the beloved ROOM library, on Flutter though, you are stuck with the low-level SQFLite package... Not anymore! MOOR is a library allowing you to work with the Flutter's SQLite database fluently and in pure Dart. Behind the scenes, it uses the SQFLite package. Oh, and if you're wondering, MOOR is just ROOM spelled backwards.

Go to the website for more information, code examples, and articles:

Follow me on social media:

[KhatibFX]

I don't normally write comments in Youtube or any other social media in general, but I just wanted to thank you for you hard work and continuous effort in creating invaluable content with just the right amount of detail. Your videos have helped me since I was applying for companies with 0 knowledge of Kotlin, into writing a Kotlin app that earned me my job, beating 60 other applicants who have 3+ more years of experience over me, and now helping me with the transition to flutter -again with 0 experience- and getting credited for delivering the best output at my workplace. Thank you so much.

[GianMarcosAguilar]

2020 UPDATE: The Provider wrapper no longer uses the 'builder' property but instead uses 'create'. So the code builder: (_) => AppDatabase(), changes to create: (_) => AppDatabase(),

[jpeg]

from the bottom of my heart, thank you.

[josephcobbinah]

This is one of the best software engineering channels on Youtube!

[alamin]

one of the best tutorial, thank you very much sir!

[RIAJULISLAMI]

Thanks a lot, Moor is more easy, less code writing than Room Android Library!. Thinking to do all my future mobile projects in Flutter rather than Native(Kotlin) way fully.

[EddyCaffrey]

Great video 👍🏽. Moor is a very useful package. I do like the Floor package also. It is exactly like the Room library

[mattsillett]

This tutorial is most likely the best i have ever seen for Moor Database in Flutter. Thank you very much for your awesome clear explanations and demo's! There are very few tutorials on Moor Database available in youtube and the documentation for the plugin is difficult to follow if you are new to coding etc.
Would it be possible to have a tutorial demonstrating how to obtain data from Moor database into a chart/graph in flutter? That would be awesome to have a tutorial on that to follow on from learning Moor.

Thanks again for your amazing contribution and i would think that many novices out there will really appreciate this tutorial.

[jonathan]

Great video about setting up the EASIEST database in Flutter! Thanks!

[dalestewart]

Excellent Introductory Tutorial with Moor

[sudesh]

😍😍....why r u so awesome... Thanks for relating ur tutorials to native android development, it's the best motivation to learn👏

[josephcobbinah]

I'm in love with Moor.. Thanks man!!

[easazade]

keep doing the flutter stuff. some awsome job you're doing there

[shabeenabarde]

Hi. When In 21:49, i am trying to keep the builder as is like in your tutorial but i am getting the error:
The argument type 'Widget Function(BuildContext)' cant be assigned to the parameter type 'Widget Function(BuildContext, Widget);
Some one please assist me as to how i can fix this. What did i do wrong?

[sanjivkumar-xuyo]

It was awesome. Thanks for the great work you did.

[moyadark]

thanks for the great work man, just what i needed
!

[kameikojirou]

How similar is this to the Drift update? Would I be able to use this same tutorial or would it be a lot different?

[earthrelated]

Thank you very much man! Can you please share your opinion on how much should one know Flutter in order to get a job.Like the areas that are a MUST! Thank you again!

[jpgotopo]

Your tutorials seem great to me! Can you teach about how to do with several tables with SQLite and Flutter?

[JamesBond-mqpd]

21:35 You don't recommend Redux because of overengineering and boilerplate?