A Flutter package that allows you to view/ filter/ search your moor database in-app

  Database, Packages, Search

moor_db_viewer

This package allows us to view our database in our development app without the need of exporting your database file. Filtering is done at database level

Example

Example

Setup

Add dependency to pubspec

pub package
dependencies:
  moor_db_viewer: <latest-version>

Use it

Push a new route. The child will be the MoorDbViewer and pass your database to this screen.

final db = MyDatabase(); //This should be a singleton
Navigator.of(context).push(MaterialPageRoute(builder: (context) => MoorDbViewer(db)));

Moor Config

Using named columns

When using named columns you should add a @JsonKey to the column otherwise we won’t be able to hide this table

class Todos extends Table {
  IntColumn get id => integer().autoIncrement()();

  TextColumn get title => text().withLength(min: 6, max: 32)();

  @JsonKey('body') //This is required for the moor_db_viewer. 
  TextColumn get content => text().named('body')();

  IntColumn get category => integer().nullable()();
}

Download moor db viewer source code on GitHub

https://github.com/vanlooverenkoen/moor_db_viewer