Moor is just a Room spelled backward. Moor is a library allowing us to work with Flutter’s SQLite database fluently and in pure Dart. Moor also uses SQLite package. In flutter, it becomes very easy to create a database without writing code for SQL tables. Moor itself uses SQL as its backend so in flutter we can directly create a Table using Dart

Table of content

1. Why Moor?
2. Adding the dependency
3. Creating a Table
4. The Database class
5. Queries
6. User Interface

Why Moor?

• Moor enables us to write queries in dart and SQL.
• Provide us APIs in dart as well.
• Moor provides Tables, queries, migration, IDE for SQL, complex filters.
• Moor helps you keep your database code simple and easy to understand.
• Identify or catches the error and provides the solution
• Moor is fast like FLUTTER.
• Moor works on Android, iOS, macOS, Windows, Linux, and the web.
• Moor is stable and well tested with a wide range of unit and integration tests. It powers the production of Flutter apps.

Adding the dependency

1. moor_flutter:

This is the core package that provides APIs.

2. moor_generator:

Generate query code based on the Table defined by the user.

3. build_runner:

Tool for database code generation.

4. pubspec.yaml

dependencies:
  moor_flutter: 

dev_dependencies:
  moor_generator: 
  build_runner:

Creating a Table

A Table in dart is made by just extending our dart class to Table. Moor uses this Table and database class to create a Database.

1. SQL Table in dart

import 'package:moor_flutter/moor_flutter.dart';
part 'moor_database.g.dart';

class Orders extends Table {
  TextColumn get price => text()();
  IntColumn get id => integer().autoIncrement()();
  TextColumn get productName => text()();

}
@UseMoor(tables: [Orders])
class AppDatabase{
}

Here IntColumn, TextColumn are the Table datatypes that are used to define the type of data that will the column of Table carries.

part 'moor_database.g.dart';

This is the file name that will contain the code generated using the Table. The id for each item in a column is id since it is autoIncrement().

2. Custom key

We can also provide our custom id to the table by just overriding the primaryKey.

@override
Set<Column> get primaryKey => {id, productName};

The Database class

@UseMoor(tables: [Orders])
class AppDatabase extends _$AppDatabase {
  AppDatabase()
      : super(FlutterQueryExecutor.inDatabaseFolder(
            path: "db.sqlite", logStatements: true));
  int get schemaVersion => 1;
}

After creating this Database class we need to generate the moor_Database.g.dart file. So we have to run the below command in the terminal.

flutter packages pub run build_runner build

Here we are defining the path inside the Database folder and we are setting the logStatements to true. It will help in debugging.

Queries

These queries are given inside the AppDatabase class.

1. Queries in pure Dart with moor

Future<List<Order>> getAllOrder() => select(orders).get();
  Stream<List<Order>> watchAllOrder() => select(orders).watch();
  Future insertNewOrder(Order order) => into(orders).insert(order);
  Future deleteOrder(Order order) => delete(orders).delete(order);

select()

You can create select statements by starting them with select(tableName), where the table name is a field generated for you by the moor. Each table used in a database will have a matching field to run queries against. Any query can be run once with get() or be turned into an auto-updating stream using watch().

Future<List<Order>> getAllOrder() => select(orders).get();
Stream<List<Order>> watchAllTask() => select(orders).watch();

insert() & delete()

We can also insert any object into the Table.

insert and delete statement take a Tables, in this case, we have Order as our Table.

Future insertNewOrder(Order order) => into(orders).insert(order);
Future deleteOrder(Order order) => delete(orders).delete(order);

update()

This statement also uses the Table to update the targeted attribute using the constructor of the Table.

Future updateOrder(Order order) => update(orders).relpace(order);

2. Full Code for moor_database.dart file

import 'package:moor_flutter/moor_flutter.dart';
part 'moor_database.g.dart';

class Orders extends Table {
  TextColumn get price => text()();
  IntColumn get id => integer().autoIncrement()();
  TextColumn get productName => text()();

}

@UseMoor(tables: [Orders])
class AppDatabase extends _$AppDatabase {
  AppDatabase()
      : super(FlutterQueryExecutor.inDatabaseFolder(
            path: "db.sqlite", logStatements: true));
  int get schemaVersion => 1;
  Future<List<Order>> getAllOrder() => select(orders).get();
  Stream<List<Order>> watchAllOrder() => select(orders).watch();
  Future insertNewOrder(Order order) => into(orders).insert(order);
  Future deleteOrder(Order order) => delete(orders).delete(order);
}

3. Generated file code

https://gist.github.com/anmolseth06/8115030632c51f498a4cd393e777d192#file-moor_database-g-dart

User Interface

1. User Input Widget

TextField(
  decoration: InputDecoration(hintText: 'Product Name'),
  keyboardType: TextInputType.text,
  controller: productNameController,
),
TextField(
  decoration: InputDecoration(hintText: 'Product Price'),
  keyboardType: TextInputType.number,
  controller: priceController,
),
RaisedButton(
  onPressed: () {
    setState(() {
      AppDatabase().insertNewOrder(Order(
        price: priceController.text,
        productName: productNameController.text,
      ));

      priceController.clear();
      productNameController.clear();
    });
  },
  color: Colors.green,
  child: Text("Place Order"),
),

We are using setState state management to control the state of the widgets.Onpressing the Raised Button price and productName are made equals to the priceConroller and productNameController.

.text converts the TextEditingController() to text

2. ListView of Orders

This widget contains the list of all the orders that the user provides using the UserInput widget.

StreamBuilder is used to listen to the stream watchAllOrder().

ListTile contains a CircleAvatar, title, subtitle, and trailing.

snapshot.data is the list of all the Orders that are fetched from the local database.

StreamBuilder(
  stream: AppDatabase().watchAllOrder(),
  builder: (context, AsyncSnapshot<List<Order>> snapshot) {
    return ListView.builder(
      itemBuilder: (_, index) {
        return Card(
          color: Colors.orangeAccent,
          child: ListTile(
              leading: CircleAvatar(
                child: Text('${index + 1}'),
                radius: 20,
              ),
              title: Text(snapshot.data[index].productName),
              subtitle: Text("Rs. ${snapshot.data[index].price}"),
              trailing: IconButton(
                icon: Icon(Icons.delete_outline),
                onPressed: () {
                  setState(() {
                    AppDatabase().deleteOrder(snapshot.data[index]);
                  });
                },
                color: Colors.red,
              )),
        );
      },
      itemCount: snapshot.data.length,
    );
  },
),

Full Project

flutter-devs/moor_database_example
A new Flutter application. This project is a starting point for a Flutter application. A few resources to get you…github.com

Thanks for reading this article ❤

If I got something wrong? Let me know in the comments. I would love to improve.

Clap 👏 If this article helps you.

If we got something wrong? Let me know in the comments. we would love to improve.

From Our Parent Company Aeologic

Aeologic Technologies is a leading AI-driven digital transformation company in India, helping businesses unlock growth with AI automation, IoT solutions, and custom web & mobile app development. We also specialize in AIDC solutions and technical manpower augmentation, offering end-to-end support from strategy and design to deployment and optimization.

Trusted across industries like manufacturing, healthcare, logistics, BFSI, and smart cities, Aeologic combines innovation with deep industry expertise to deliver future-ready solutions.

Feel free to connect with us:
And read more articles from FlutterDevs.com

FlutterDevs team of Flutter developers to build high-quality and functionally-rich apps. Hire flutter developer for your cross-platform Flutter mobile app project on an hourly or full-time basis as per your requirement! You can connect with us on Facebook, GitHub, and Twitter for any flutter related queries.

We welcome feedback, and hope that you share what you’re working on using #Flutter. We truly enjoy seeing how you use Flutter to build beautiful, interactive web experiences!

Thank you for reading. 🌸

These days approaches for code delivery are gradually changing when writing quality code and the fine product delivery is a need of the time and in this situation, developers find themselves in the dilemma to manage both things at the same time but now this is not a big deal because of CI/CD(Continuous Integration/Continuous Delivery). So let’s first know about CI/CD.

What is CI/CD

It can be easily understood by its name Continuous Integration/Continuous Delivery and it is the process to directly merge your product version(code) into the main branch of your code and also helps to get builds of the product on the daily basis and also look after the integration problems, CI helps to trigger the build whenever code is pushed and integration tests make sure that the new part which has been added to the application does not break the previous build of the application and if the test or the build fails then ensure that the app remains stable, While CD is Continuous Deployment or Continuous Delivery is the automatic deployment of an app (to production).

Now let’s understand how to implement it

There are various ways to implement CI/CD and we are going to get it done by using Code Magic. It was launched at Flutter Live in December 2018 in cooperation with Google, Code Magic provides various options to implement CI/CD.

You can log in with any mentioned account, and now I am going to implement it by using GitHub.

But you should remember one thing your GitHub/Bitbucket/GitLab should have a repository in which you want to implement CI/CD.

After login with any particular account, You will navigate to the home page of code magic.

You will find this kind of screen now you have to choose in which repo you want to implement CI/CD. So here in every repository, you can see a setting icon and “start new build” options so before going to build option first we need to set up our repository for different workflows and many more options are there.

So at first, we click on that icon right before the “start new build” option and you will navigate to this screen.

Here you need to set up different workflows for a different kind of delivery and testing like Default workflow, Dev workflow, QA workflow, so create it by clicking “Duplicate workflow” in ton right side of the screen.

After creating duplicate workflows you can choose which workflow you need which type of customization (as shown in the above screen).

You also need to implement the same branches in your repo and that could be master, QA, dev.

So every time you need to push your code from dev (it is your choice) and then you need to merge changes into different branches in your GitHub.

After that, you need to select different workflows one by one and customize the setting according to your need, and I started the customization from Dev workflow and the first option I found to customize is “Build triggers”.

Here I have clicked on triggered on push, so every time we push over code over GitHub we will get a new build, you can choose different options according to your need for different workflows.

After that, we move to the next option below it where we would make some changes and this is “Test”.

As you can understand by seeing it, if the test fails, it automatically stops build.

Next option is “Build”

In this, you can select the flutter version, platforms, in which mode you want to release your app,

and the next part is ‘Publish’,

here you can select you to publish options like where you want to share your build or changes, even you can update your app in play store and apple app store directly and for this, you only need to fill some info by clicking on Android code signing and iOS code signing, you can share your build over email by providing mail addresses directly.

After all these customizations you need to click on “start new Build” top of the page and you will navigate to this page

here you can select your branch your workflow and by clicking on which type of build you want you can move forward. when you click any of the options you will find that it started creating a new build for every platform you selected during customization

and after completing its build you will receive builds on all platforms you selected. So here is the image of my mail inbox where I received a mail of new build now I can download Apk and test if the new changes are working fine or not.

So this was the small introduction of CI/CD through code magic.

Thanks for reading this article if you find anything that could be improved please let me know, I would love to improve.

From Our Parent Company Aeologic

Aeologic Technologies is a leading AI-driven digital transformation company in India, helping businesses unlock growth with AI automation, IoT solutions, and custom web & mobile app development. We also specialize in AIDC solutions and technical manpower augmentation, offering end-to-end support from strategy and design to deployment and optimization.

Trusted across industries like manufacturing, healthcare, logistics, BFSI, and smart cities, Aeologic combines innovation with deep industry expertise to deliver future-ready solutions.

Feel free to connect with us
And read more articles from FlutterDevs.com

FlutterDevs team of Flutter developers to build high-quality and functionally-rich apps. Hire flutter developer for your cross-platform Flutter mobile app project on an hourly or full-time basis as per your requirement! You can connect with us on Facebook, GitHub, and Twitter for any flutter related queries.

For those who don’t know about NoSql?

NoSQL, which stands for “not only SQL,” which is an alternative of traditional relational databases in which data is placed in tables and data schema is carefully designed before the database is built. NoSQL databases are especially useful for working with large sets of distributed data.

What is Hive?

Hive is a lightweight, NoSQL database, easy to implement and also having high benchmark on the devices and written in the pure dart. Until and unless you need to model your data with many relationships, in that case it recommended to use SQLite.It has no native dependencies (it runs on Flutter Web!) can be the best option. Hive supports all platforms supported by Flutter.

Hive having the concept of boxes(which store data). A Box has to be opened before use. In addition to the plain-flavoured Boxes, there are also options which support lazy-loading of values and encryption.

What are Boxes?

All data stored in Hive is organized in boxes. A box can be compared to a table in SQL, but it does not have a structure and can contain anything. For a small app, a single box might be enough. For more advanced problems, boxes are a great way to organize your data. Boxes can also be encrypted to store sensitive data.

Before you can use a box, you have to open it. For regular boxes, this loads all of its data from the local storage into memory for immediate access.

var box = await Hive.openBox<E>('testBox');

To get an already opened instance, you can call Hive.box('testBox') instead. It doesn’t matter though if you try to call openBox multiple times. Hive is smart, and it will return an already opened box with the given name if you’ve previously called that method.

To prevent holding unnecessary data in memory, you can close the box when you are done with your box. Don’t worry if you forget to close the boxes . Smarty Hive do it for you. Its also has a handy method for closing all the box.

Hive supports all primitive types, List, Map, DateTime, BigInt and Uint8List. Any object can be can stored using TypeAdapters.

In this, we are covering how to save a custom object(Employee)showing Basic CRUD operations:

Adding Dependencies:

dependencies:
  flutter:
    sdk: flutter

  # The following adds the Cupertino Icons font to your application.
  # Use with the CupertinoIcons class for iOS style icons.
  cupertino_icons:
  hive: latest version
  hive_flutter: latest version
  path_provider:

dev_dependencies:

 flutter_test:
    sdk: flutter
  hive_generator:
  build_runner:

Initializing and Registering Adapter:

Box _employeeBox;

  @override
  void initState() {
   super.initState();
   Hive.registerAdapter(EmployeeAdapter());
   _openBox();
  }


  void _openBox() async{
     var dir = await getApplicationDocumentsDirectory();
    Hive.init(dir.path);
    _employeeBox = await Hive.openBox('employeeBox');
  }

Under the hood, Hive works with binary data. It cannot recognise it

Box boxObject = await Hive.openBox('employee');
boxObject.add(Employee("paras" ,62));

its throws exception. or we save this by making it TypeAdapter.

import 'package:hive/hive.dart';
part 'employee.g.dart';

@HiveType(typeId: 1)
class Employee {

  @HiveField(0)
  final String name;

  @HiveField(1)
  final int id;

  Employee(this.name, this.id);

}

And in Terminal type :

flutter pub run build_runner build part ’employee.g.dart’

and you are done. This will generate you a TypeAdapter.

Save (Add)

We open the Box at the time of Initialization.

_employeeBox.add(Employee(employeeNameController.text, employeeHobbyController.text));

To show saved data in List (READ)

ListView.builder(shrinkWrap: true,
  itemCount:  _employeeBox.length,
  itemBuilder: (context ,index)
  {
    final employee = _employeeBox.get(index) as Employee;

    return Container(
      margin: EdgeInsets.symmetric(vertical: 8),
      child: Row(
        mainAxisAlignment: MainAxisAlignment.spaceAround,
        children: <Widget>[
          Text("${employee.name}",style: TextStyle(fontWeight: FontWeight.w400 ,fontSize: 15),),  Text("${employee.hobby} ",style: TextStyle(fontWeight: FontWeight.w400 ,fontSize: 15),),
        ],
      ),
    );
  },)

For Updating and Deleting we use putAt() and deleteAt().

Link for repository:

https://github.com/parasarorahere/Hive-Database.git

Thanks for reading this article if you find anything that could be improved please let me know, I would love to improve.

From Our Parent Company Aeologic

Aeologic Technologies is a leading AI-driven digital transformation company in India, helping businesses unlock growth with AI automation, IoT solutions, and custom web & mobile app development. We also specialize in AIDC solutions and technical manpower augmentation, offering end-to-end support from strategy and design to deployment and optimization.

Trusted across industries like manufacturing, healthcare, logistics, BFSI, and smart cities, Aeologic combines innovation with deep industry expertise to deliver future-ready solutions.

Feel free to connect with us
And read more articles from FlutterDevs.com

FlutterDevs team of Flutter developers to build high-quality and functionally-rich apps. Hire flutter developer for your cross-platform Flutter mobile app project on an hourly or full-time basis as per your requirement! You can connect with us on Facebook, GitHub, and Twitter for any flutter related queries.