Flutter LiveData to watch sqlite query result changes

I am trying to show how many row of record in my transaction table. In android, I am able to use livedata to observe the data changes without additional step like retr...

Can I export my sqlite database from Flutter?

There are various articles on how to import data on the internal database from a csv, from another database etc .. but I haven't found anyone explaining how to export...

How to optimize firebase/firestore for a sensible synchronization tool for big online database?

In my app I have a lot of PNGs, about 150 mb. First time my user will download them all, but then the user should only download new/deleted/modified PNGs, not the ones...

Grabbing Primary Key of listed values from sqlite database, dart with flutter

Currently my code is grabbing the order of the listed values by how it is indexed and i'm passing it to my raw sql query. I think i may be going about this the wrong...

How do I use an async method to build a List Object?

I am getting an error that says that the method .length is calling on a null object _genreList. I am using an async method to get data from a local asset sqlit...

showing 1 data from Sqlflite flutter

So i want to make a delete button, so the user could delete those data according to the data they choose to see. Each time the data on the sqflite were added th...

Flutter - Sending SQL data to a ListView

Using the flutter package <a href="https://pub.dartlang.org/packages/sqflite" rel="nofollow noreferrer">sqflite</a> I've managed to save data from a news source to a d...

Why isnt my sql query in sqlite/sqlbrite not working with a second condition/multiple WHERE clauses?

I have a query for my Sqlite/Brite databse that takes two conditions. One to check for a selected quarter, and another to make sure an action attribute isn't del...

FutureBuilder&lt;List&gt; is not displaying any data

I am writing a flutter app that is listing the whole players of a card game. And if no players are inside the database, then there should be a text that is saying, tha...

Display data from sqlite to simpledialog in flutter

I want to display data from sqlite to SimpleDialog widget <pre><code>showDialog( context: context, barrierDismissible: true, builder: (BuildContext contex...

Flutter, local SQLite database and Role based access control

I am new in Flutter and still learn basics and my next step is to create user role-based authorization Flutter desktop app using local database (SQLite). In the web I...

How to select DISTINCT entries in SQLite Flutter with whereArgs?

I want to return Distinct records from a table in SQLITE flutter by giving some condition such as return All the distinct records where ID = x (where x will be taken b...

Flutter - auto complete textfield with suggestions from sqlite database

Auto complete textfield with suggestions from sqlite database. Show one of the data from salute database as title and another as subtitle in the listtile of suggestion...

Flutter - FutureBuilder error on first build

I am trying to build an app, that displays a list after the call to the database. But when I'm launching the app for the first time, there will always be my error mess...

how to flutter convert maps to String

hello i get data in sqlite code : <pre><code>getuserIDPW(String email) async{ final db = await database; var res = await db.query("person",columns: ['emai...