Visually manage your Flutter Sqflite database

Related tags

Templates flutter_sqflite_manager
Overview

Flutter Sqflite Manager

To manage your sqflite database in Flutter.

Browse the database's tables, see the rows inside them, empty tables and delete the entire database. Review your tables' columns and the corresponding column type.

This is still an early preview, some behaviors can change or being removed. Every feedback, bug report or feature request is welcome, please send it at the issue tracker

Get started

Wrap your app with SqfliteManager passing the sqflite database as parameter. Usually the database is of Future<Database>, check the example to see a FutureBuilder implementation. Use the enable parameter to switch between testing and production.

SqfliteManager(
    database: _database,
    // Update rowsPerPage parameter to avoid scrolling in different screen sizes
    rowsPerPage: 6
    enable: true,
    child: YourApp()
)
Comments
  • No data displayed

    No data displayed

    Hello sir, I have the problem right now, that I can't see the contents of the local db. However, I get all my databases displayed

    The following error occurs:

    Failed assertion: line 279 pos 15: '!rows.any((DataRow row) => row.cells.length != columns.length)': is not true.

    image

    image

    I guess it's the column PRIMARY. Where i get the assert Exception

    opened by ArtHoffmann 4
  • Refactor and add documentation for _getTables.

    Refactor and add documentation for _getTables.

    Since the sqlite_master is being queried, there is no need to loop over all the results, a where argument can be provided to filter out rows that have type as table.

    opened by gurleensethi 2
  • Primary Key Bug

    Primary Key Bug

    Hello, sir, I have discovered a bug that does not allow displaying the database columns.

    So I create a Pk like this (see below)

    
  final warenkorbSQL = '''
          CREATE TABLE $warenkorbTabelle (
            $bestellAnzahl INTEGER NOT NULL,
            $bestellArtikelBezeichnung TEXT NOT NULL,
            $bestellPreis TEXT NOT NULL,
            $bestellEan TEXT NOT NULL,
            $bestellMatnr TEXT NOT NULL,
            $bestellMeinh TEXT NOT NULL,
            $bestellTisch INTEGER NOT NULL,
            PRIMARY KEY ($bestellMatnr, $bestellMeinh, $bestellTisch)
          )
          ''';
    await db.execute(warenkorbSQL);

    As I have understood so far, the package only allows a simple pk and not multiples ones.

    Also single and multiple foreign keys are not displayed.

    opened by ArtHoffmann 1
  • Problem

    Problem

    I'm having this problem:

    Reassembling main.dart$main-1991835737177151 failed: ext.flutter.reassemble: (-32000) Server error {"exception":"Stack Overflow","stack":"#0 Element.markNeedsBuild.<anonymous closure> (package:flutter/src/widgets/framework.dart:4198:12)\n#1 Element.markNeedsBuild (package:flutter/src/widgets/framework.dart:4237:6)\n#2 Element.reassemble (package:flutter/src/widgets/framework.dart:3033:5)\n#3 StatefulElement.reassemble (package:flutter/src/widgets/framework.dart:4687:11)\n#4 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#5 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#6 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#7 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#8 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#9 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#10 StatefulElement.reassemble (package:flutter/src/widgets/framework.dart:4687:11)\n#11 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#12 SingleChildRenderObjectElement.visitChildren (package:flutter/src/widgets/framework.dart:5872:14)\n#13 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#14 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#15 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#16 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#17 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#18 SingleChildRenderObjectElement.visitChildren (package:flutter/src/widgets/framework.dart:5872:14)\n#19 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#20 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#21 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#22 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#23 StatefulElement.reassemble (package:flutter/src/widgets/framework.dart:4687:11)\n#24 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#25 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#26 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#27 StatefulElement.reassemble (package:flutter/src/widgets/framework.dart:4687:11)\n#28 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#29 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#30 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#31 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#32 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#33 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n...\n...\n#5805 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#5806 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#5807 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#5808 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#5809 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#5810 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#5811 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#5812 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#5813 StatefulElement.reassemble (package:flutter/src/widgets/framework.dart:4687:11)\n#5814 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#5815 ComponentElement.visitChildren (package:flutter/src/widgets/framework.dart:4611:14)\n#5816 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#5817 Element.reassemble.<anonymous closure> (package:flutter/src/widgets/framework.dart:3035:13)\n#5818 RenderObjectToWidgetElement.visitChildren (package:flutter/src/widgets/binding.dart:1174:14)\n#5819 Element.reassemble (package:flutter/src/widgets/framework.dart:3034:5)\n#5820 BuildOwner.reassemble (package:flutter/src/widgets/framework.dart:2861:12)\n#5821 WidgetsBinding.performReassemble (package:flutter/src/widgets/binding.dart:958:18)\n#5822 BindingBase.lockEvents (package:flutter/src/foundation/binding.dart:248:41)\n#5823 BindingBase.reassembleApplication (package:flutter/src/foundation/binding.dart:288:12)\n#5824 BindingBase.registerSignalServiceExtension.<anonymous closure> (package:flutter/src/foundation/binding.dart:325:23)\n#5825 BindingBase.registerSignalServiceExtension.<anonymous closure> (package:flutter/src/foundation/binding.dart:324:17)\n#5826 BindingBase.registerServiceExtension.<anonymous closure> (package:flutter/src/foundation/binding.dart:547:32)\n#5827 _RootZone.runUnary (dart:async/zone.dart:1450:54)\n#5828 _FutureListener.handleValue (dart:async/future_impl.dart:143:18)\n#5829 Future._propagateToListeners.handleValueCallback (dart:async/future_impl.dart:696:45)\n#5830 Future._propagateToListeners (dart:async/future_impl.dart:725:32)\n#5831 Future._complete (dart:async/future_impl.dart:519:7)\n#5832 new Future.delayed.<anonymous closure> (dart:async/future.dart:322:16)\n#5833 Timer._createTimer.<anonymous closure> (dart:async-patch/timer_patch.dart:18:15)\n#5834 _Timer._runTimers (dart:isolate-patch/timer_impl.dart:397:19)\n#5835 _Timer._handleMessage (dart:isolate-patch/timer_impl.dart:428:5)\n#5836 _RawReceivePortImpl._handleMessage (dart:isolate-patch/isolate_patch.dart:168:12)\n","method":"ext.flutter.reassemble"}

    opened by alpceylan 0
  • Moor compatibility

    Moor compatibility

    Please, make this plugin compatible with Moor database instance.

    error: The argument type 'Database (where Database is defined in C:\...\database.dart)' can't be assigned to the parameter type 'Database (where Database is defined in C:\...\Flutter\.pub-cache\hosted\pub.dartlang.org\sqflite-1.1.7+2\lib\sqlite_api.dart)'.

    opened by anisalibegic 0
Owner
Mattia Crovero
Mattia Crovero
GitHub https://pub.dev/packages/flutter_sqflite_manager
Movie App used MVC pattern, Getx for state managment, sqflite for backend database

movie_app A new Flutter application. Getting Started This project used MVC pattern, Getx for state managment, sqflite for backend database, firebase/W

HM Badhon 3 Sep 13, 2022
A Clean looking modren and colorful notes app using a local database with sqflite

A Clean looking modren and colorful notes app using a local database with sqflite

Moaz Talaat 3 Sep 23, 2022
App for visually impaired using Machine Learning, Artificial Intelligence, and Flutter.

Your Eyes ?? Introduction Our Application aims to bridge the gap between them and the visual world by Deep Learning and lucid User-Interface for easy

Jatin Yadav 5 Dec 9, 2022
A flutter app that help the visually/auditory/speech impaired people cope with their surroundings and get assistance

Lumos Introduction ?? Despite the advancement of tools and technologies, mankind

R Adithya Kumar 11 Aug 8, 2022
Create a platform for visually challenged individuals to make use of their smart phones

Lights A project aiming to create a platform for visually challenged individuals

Rohit V 0 Mar 22, 2022
Parallax - A parallax package for touch-based devices, providing a visually appealing user experience

Parallax A parallax package for touch-based devices, providing a visually appeal

MEDAFOX 4 Sep 28, 2022
Presentation-Remote-PC - Manage your presentation from your smart phone - Phone Client

Presentation-Remote-PC Manage your presentation from your smart phone - Phone Cl

Hasan Ragab Eltantawy 1 Jan 25, 2022
Note app flutter sqflite provider - A Note Taking Application written in Flutter

note_app_flutter_sqflite_provider ?? Introduce This is a note taking app made wi

Cool Kid 10 Dec 22, 2022
A starter kit for beginner learns with Bloc pattern, RxDart, sqflite, Fluro and Dio to architect a flutter project. This starter kit build an App Store app as a example

Flutter Starter Kit - App Store Example A starter kit for beginner learns with Bloc pattern, RxDart, sqflite, Fluro and Dio to architect a flutter pro

kw101 678 Jan 8, 2023
sqfEntity ORM for Flutter SQLite (sqflite)

SqfEntity ORM for Flutter/Dart lets you build and execute SQL commands on SQLite database easily and quickly with the help of fluent methods similar to .Net Entity Framework. SqfEntity also generates add/edit forms with validations and special controls (DropDown List, DateTime pickers, Checkboxes.. etc) for your table.

Hüseyin Tokpınar 347 Jan 2, 2023
Polymaker is an application that can create polygon locations dynamically in mobile apps and save the data into SQFlite to be permanent.

Polymaker Polymaker is an application that can create polygon locations dynamically in mobile apps and save the data into SQFlite to be permanent. Ins

Yusril Rapsanjani 15 Apr 17, 2022
Note provider - Note App using Provider state management, Sqflite and Localization for two language Arabic and English.

note_provider Sqflite with provider statemanagement Getting Started This project is a starting point for a Flutter application. A few resources to get

Mohanned Anwar 0 Jan 1, 2022
An app that helps you manage your Postcard Creator orders. Built with Flutter

mailman A new Flutter project. Getting Started This project is a starting point for a Flutter application. A few resources to get you started if this

Dario Breitenstein 0 Jan 10, 2022
Flutter app that helps you manage your payments.

?? PayFlow Screenshots | Tecnologias | Projeto | Licença ?? Screenshots ?? Tecnologias Esse projeto foi desenvolvido com as seguintes tecnologias: Flu

Bruno Lombardi 3 Aug 18, 2022
A simple to-do list built using flutter based on BLoC state management to manage your daily tasks .

?? Table of Contents About ScreenShots from the app Demo vedio Contributors About A to-do list flutter app to manage your daily tasks. it is built bas

Heba Ashraf 6 Oct 12, 2022
A dialog queue for you to manage your dialogs to display on flutter platform

A dialog queue for you to manage your dialogs to display on flutter platform 中文 Features Support pop dialog orderly Support pop dialog by priority Sup

Raymond 4 Nov 1, 2022
A most easily usable cookie management library in Dart. With SweetCookieJar, you can easily manage cookie on your application.

A most easily usable cookie management library in Dart! 1. About 1.1. Introduction 1.1.1. Install Library 1.1.2. Import It 1.1.3. Use SweetCookieJar 1

Kato Shinya 9 Oct 27, 2022
AuthorizationHeader is an open-sourced Dart library. With AuthorizationHeader, you can easily manage authorization header on your application.

A most easily usable authorization header management library in Dart! 1. About 1.1. Supported 1.1.1. Authorization Header 1.1.2. Authorization Type 1.

Kato Shinya 3 Dec 24, 2021
A most easily usable cache management library in Dart. With CacheStorage, you can easily manage cache on your application.

A most easily usable cache management library in Dart! 1. About 1.1. Introduction 1.1.1. Install Library 1.1.2. Import It 1.1.3. Use CacheStorage 1.2.

Kato Shinya 1 Dec 13, 2021