Moor (Room for Flutter) #3 –  Foreign Keys, Joins & Migrations – Fluent SQLite Database @ResoCoder
Moor (Room for Flutter) #3 –  Foreign Keys, Joins & Migrations – Fluent SQLite Database  @ResoCoder
Uploaded July 2019 | Updated November 2026, 3 hours ago
📗 Learn from the written tutorial & get the project files 👇👇
resocoder.com/flutter-moor-ep3

👨‍💻 Do you write good code? Find out now 👇
resocoder.com/good-code-quiz

Your app's database will probably have more than one table. You want to store tasks together with their tags, or maybe recipes and their authors. No matter what you store, it's usually the case that some of the tables are quite interconnected and it would be perfect to get just the right data from both tables at the same time. That's what SQL joins are for.

To make joins safe, it's a good idea to use foreign keys. Otherwise you might end up trying to get a tag or a recipe which doesn't exist... and that's not all that good.

Finally, adding new columns or whole tables requires you to provide a migration to let the previous versions of the database upgrade themselves.

We're building a task list application in this series, so we will add tags to the mix. They will be stored inside a separate table. Every task can have a tag and to get the tasks together with tags, we will utilize foreign keys and table joins. The user interface will also change a bit.

Go to the website for more information, code examples, and articles:
● resocoder.com

Follow me on social media:
● instagram.com/resocoder
● facebook.com/resocoder
● twitter.com/resocoder
● gab.ai/resocoder
Moor (Room for Flutter) #3 –  Foreign Keys, Joins & Migrations – Fluent SQLite DatabaseBloc Test Tutorial – Easier Way to Test Blocs in Dart & FlutterAndroid Kotlin: Forecast App 03 - Local Database (Room Entity & Dao) - MVVM Tutorial CourseMaterial Design 2 Overview (Design Support Library 28) - Android Kotlin TutorialData Binding with LiveData (Two-way & One-way) - Android Kotlin TutorialFlutter Sailor Navigation Tutorial – The Simplest Navigator Library?Flutter TDD Clean Architecture Course [10] – Bloc Scaffolding & Input ConversionVS Code Extensions Every FLUTTER Developer Should Have + Bonus Theme & FontsChopper (Retrofit for Flutter) - #2 Interceptors - Dart HTTP Client Generator TutorialMake a Timer App: Countdown Timer (Ep 2) - Android Kotlin TutorialFlutter Firebase & DDD Course [12] - Note Value ObjectsFlutter: YouTube Search 04 - Search BLoC - BLoC Tutorial Course
Reso Coder |

Moor (Room for Flutter) #3 – Foreign Keys, Joins & Migrations – Fluent SQLite Database

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER