I'm trying to store app data of my flutter application in the database, but the complier keeps showing "Future isn't a type" for async func and underlines in red. I've tried removing .ana...

I followed the following tutorial on the official site for sqflite: https://pub.dev/packages/sqflite But on this line var databasesPath = await getDatabasesPath(); I get the following error: Exce...

I have a file a function fetchPosts() which is in charge of getting new Posts from a server and store them in a local sqlite database. As recommended on the sqflite doc, I store a single ref to m...

I'm trying to use floor database but when i want to build database i got below error : E/flutter (26007): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: MissingPluginException(No...

lets say I have a todo app that stores the data in sqflite database(locally on the phone) when the app goes online I want the data to be synced with my online database say mongodb or firestore.I do...

How to insert quickly multiple records in sqflite? The standard quickly method is: await database.insert(table, object.toMap()) But I don't think that insert record one to one with a cycle is a ...

I am integrating a Database into my flutter app with sqflite. Since I am a visual understander in terms of problems, I would like to be able to see table contents for debugging. Is there a possibil...

I'm trying to insert a lot of rows (about 12k or more) in a sqlite memory database using flutter. I get data from the API and use a compute function in order to process data from Json. Now I need ...

I am trying to load SQLite DB in Flutter for Windows (it's working on Android), but I receive an exception, my code is : // Copy from asset ByteData data = await rootBundle.load(join("assets&q...

I am using flutter SQflite to store data in flutter and I have no problem with it so far. Now I want to update my app and the database with it. Until now I was simply replacing the old database wit...

I need to create new tables and delete others in my local database, however changing only the database version, it does not work it is not creating the new tables that I need. In the same way I al...

Im building and app with flutter that uses SQLite database. I have created first table using this piece of code: void _createDb(Database db, int newVersion) async { await db.execute('''CREATE TA...

I have a fully functional app created in Flutter. It uses sqflite plugin for storing data. I want to have a data change listener, which will update or refresh the data when new data is added or upd...

I need to add a new column name id INTEGER AUTOINCREMENT and a new table for the current database for my existing table. How to use 'onUpgrade'? Is it need to change the version number? initDb() a...

So I have a class DBProvider, which is creating a new instance whenever it hasn't been initialized yet. The database currently contains 8 tables that are created in 1 query (the same thing happens ...

I am using flutter to make a Windows app and while using the sqflite and making a database, this error pops up I don't know how to really fix this. import 'dart:io'; import 'package:path_provider/...

I am using sqlflite flutter package to manage a small database for my app, there is a table where I have some urls for few images from the internet , but I need to save them and use the files inste...

I'm using sqflite for my flutter project and now, I want to backup and then restore it. I searched for this issue but can't find a result. Is there any way to do it?

How do I get the row count of a database table in Flutter. I am using the SQFlite plugin. I assume that it is similar to Android, but Android has DatabaseUtils.queryNumEntries(db, TABLE_NAME). Doe...

Unhandled Exception: DatabaseException(table UsernameTable has no column named rememberMe (Sqlite code 1): , while compiling: INSERT OR REPLACE INTO UsernameTable (username, rememberMe) VALUES ...

How do you update data in a table row in Flutter using the SQFlite plugin? There are a number of problem solving questions out there (see this and this) but none that I could find to add a canonic...

I am looking at this (https://github.com/tekartik/sqflite/blob/master/doc/opening_asset_db.md) for populating data that is already formatted and need for the app, for read functionality only. So my...

I have tried to find my Database Inspector in Android Studio in multiple ways, but to no avail: View → Tool Windows → Database Inspector is not there Help → Find Action → Database Inspector cannot...

I am using sqflite and I am getting rows count of specific record via below code: Future<int> getNumberOfUsers() async { Database db = await database; final count = Sqflite.firstIntValue(...

I'm trying to query a Companies table using the companyName, I want to get the companies whose companyName(s) contains a query string, not only the companies whose companyName are exact matches of ...