SQLite plugin for Flutter. Supports iOS, Android and MacOS.
To have web support, https://github.com/kripken/sql.js seems like a great option. Is there any plans to have web support eventually?
Hello,
First, thanks a lot for this library which is working fine for me on Android and Linux.
I'm trying to make a Windows release and I can do it but only if I add in the root folder a .packages file containing sqflite_common_ffi:lib/ (the lib/ folder being as this: lib/src/windows/sqlite3.dll (<=> the sqlite dll found in C:\Users\{USERNAME}\AppData\Roaming\Pub\Cache\hosted\pub.dartlang.org\sqflite_common_ffi-1.1.1+1
You can find an example of my project below:
lib/src/windows/sqlite3.dll path or the .packages file, the application is showing nothingNote that it also works perfectly fine if my release folder in under {FLUTTER_PROJECT}/build/windows/runner/Release/ and without any .packages nor lib/src/windows/sqlite3.dll (I guess the app is searching in 'prefolders' and finds the .packages (and then the sqlite dll file in AppData)
=> To reproduce, you need put the windows executable outside your flutter project !
Here is my pubspec.yaml dependencies:
environment:
sdk: ">=2.1.0 <3.0.0"
dependencies:
flutter:
sdk: flutter
flutter_localizations:
sdk: flutter
# Show HTML content
flutter_html: ^1.1.1
# Icons
cupertino_icons: ^1.0.0
# API requests
http: ^0.12.2
# Internal storage
sqflite: ^1.3.2
path_provider: ^1.6.24
# Share content outside the application
share: ^0.6.5
# Ads
admob_flutter: ^1.0.1
dev_dependencies:
flutter_test:
sdk: flutter
# Internal storage
sqflite_common_ffi: ^1.1.1
# Searchable dropdown list
# TODO: Use official version when this issue will be solved: https://github.com/icemanbsi/searchable_dropdown/issues/117
searchable_dropdown:
git:
url: https://github.com/FunnyLabz/searchable_dropdown.git
ref: master
Here is how I initialized the project:
// Platform
import 'package:flutter/foundation.dart';
// For database handling
import 'package:sqflite_common_ffi/sqflite_ffi.dart';
import 'package:sqflite/sqflite.dart';
void main() {
if ((defaultTargetPlatform == TargetPlatform.windows || defaultTargetPlatform == TargetPlatform.linux) && !kIsWeb) {
// Initialize FFI to be able to use database with Windows/Linux
// We use 'sqflite_ffi' if Linux or Windows, else we can use default sqlite (Android/IOS/Mac)
sqfliteFfiInit();
// Change the default factory
databaseFactory = databaseFactoryFfi;
}
runApp(new MyApp());
}
The error using openDatabase is as follows:MissingPluginException(No implementation found for method openDatabase on channel com.tekartik.sqflite).How should I solve it?
@alextekartik, thanks for your great work with SQFlite!
Do you plan to support Windows desktop and what are the challenges for that?
Hi,
thank you for making sqlite available for Flutter - I need to use sqlite with encryption - do you know how the normal way to use encryption with sqlite could be implemented?
https://www.sqlite.org/see/doc/trunk/www/readme.wiki
Thanks!
The method 'execute' and also the method ".query" is throwing an error:
import 'dart:async';
import 'dart:io';
import 'package:flutter_app/datenbank/Rezepte.dart';
import 'package:path/path.dart';
import 'package:sqflite/sqflite.dart';
import 'package:path_provider/path_provider.dart';
class DatabaseClient{
Database database;
//Datenbank wird erstellt
Future erstellen() async{
Directory pfad = await getApplicationDocumentsDirectory();
String datenbankPfad = join(pfad.path, "rezept_buch.db");
database = await openDatabase(datenbankPfad, version: 1, onCreate: this.erstelleTabellen);
}
//Die Tabellen werden erstellt
Future erstelleTabellen(Database db, int version) async{
await database.execute(""" //The error is on this line
create table rezept (
id integer primary key,
name text not null,
personen_anzahl integer not null,
beschreibung text default null,
favorit integer default 0
)
""");
}
Future setRezept(Rezepte rezepte) async{
var count = Sqflite.firstIntValue(await database.rawQuery("SELECT * FROM rezept WHERE name =?", [rezepte.name]));
if(count == 0){
rezepte.id = await database.insert("rezept", rezepte.toMap());
} else {
await database.update("rezept", rezepte.toMap(), where: "id = ?", whereArgs: [rezepte.id]);
}
return rezepte;
}
//Daten aus Tabellen holen
Future getAllRezepte(int id) async{
List ergebnisse = await database.query("rezept", columns: Rezepte.spalten, where: "id=?",whereArgs: [id]); // error on this line
Rezepte rezepte = Rezepte.fromMap(ergebnisse[0]);
return rezepte;
}
}`
Hello! I need to save a bool variable (true/false) in SQFLite. I've seen that SQFlite does not support creating a bool column even though Dart supports booleans. This means that we need to create an integer column and save a value with zero - > false and one -> true. I don't know, may be it is better to save 1 -> false and 2 -> true. In my program, I use a variable isChecked to refer to a UI control. In my model, I need to define isChecked as the bool variable for the program logic to work properly. I don't think I can convert bool to int. Could you please advise how to save bool to int. Thank You
Hi! I am not a pro flutter developer, so I am unaware if this is correct place to ask.
My project has compiled perfectly in the cloud until Xcode 14.x (I guess?), and it failed with a static link:
After searching for issues regarding libarclite_iphoneos.a and links, it recommeded updating the podfile post install like this
post_install do |installer|
installer.pods_project.targets.each do |target|
flutter_additional_ios_build_settings(target)
target.build_configurations.each do |config| #Added this line
config.build_settings['IPHONEOS_DEPLOYMENT_TARGET'] = '13.0'
end
end
end
When do so the FMDB error was fixed, but it failed on firebase_app_check package, making the Xcloud unable to compile & publish.
Using Xcode locally (Version 14.2 (14C18)) it compile, archive, verify and publish to testflight without any problems.
So is this an sqflite issue, or am I barking up the wrong tree? :)
Hi,
my flutter app runs on a real device with Android 9.
A raw insert insert into users (username,password,enabled) values ('acorn371','my password',true); having a boolean column value (true) fails in the following table while a DB Helper insert works well.
CREATE TABLE IF NOT EXISTS users (
id integer PRIMARY KEY AUTOINCREMENT NOT NULL,
username text NOT NULL,
password text,
enabled boolean NOT NULL
);
The error is:
_Connection : ABORT Transaction: DatabaseException(no such column: true (code 1 SQLITE_ERROR): , while compiling: insert into users (username, password,enabled) values('acorn371','10cbd305e87caa0d6b984f6616dfcd1fa82832b38ee7525f5499d1802d5069a9',true);) sql 'insert into users (username, password,enabled) values('acorn371','10cbd305e87caa0d6b984f6616dfcd1fa82832b38ee7525f5499d1802d5069a9',true);' args []
Hi all,
I'm new on Flutter, but whenever I add sqflite to my pubspec.yaml, I got this message when I try to run it on an iOS simulator:
Launching lib/main.dart on iPhone 14 Pro in debug mode...
Running Xcode build...
Xcode build done. 5.6s
Failed to build iOS app
Lexical or Preprocessor Issue (Xcode): 'Flutter/Flutter.h' file not found
/Users/user/.pub-cache/hosted/pub.dev/sqflite-2.2.5/ios/Classes/SqfliteImport.h:10:8
Could not build the application for the simulator.
Error launching application on iPhone 14 Pro.
I tried to delete the project and recreate it, but everytime it fails.
What could be the problem?
Hi we are getting crash in production. And we don't have reproducible steps. Any help is appriciable. Thanks
com.apple.main-thread 0 libsystem_kernel.dylib 0xda8 mach_msg2_trap + 8 1 libsystem_kernel.dylib 0x13a1c mach_msg2_internal + 80 2 libsystem_kernel.dylib 0x13c5c mach_msg_overwrite + 388 3 libsystem_kernel.dylib 0x12ec mach_msg + 24 4 CoreFoundation 0x7aac4 __CFRunLoopServiceMachPort + 160 5 CoreFoundation 0x7bd08 __CFRunLoopRun + 1232 6 CoreFoundation 0x80eb0 CFRunLoopRunSpecific + 612 7 GraphicsServices 0x1368 GSEventRunModal + 164 8 UIKitCore 0x3a1668 -[UIApplication _run] + 888 9 UIKitCore 0x3a12cc UIApplicationMain + 340 10 TCPApp 0x78b4 main + 39 (UPIPaymentSubStatusView.swift:39) 11 ??? 0x1de93c960 (Missing)
Crashed: fmdb.<FMDatabaseQueue: 0x2810204b0> 0 libsqlite3.dylib 0xb6498 sqlite3_sourceid + 1672 1 libsqlite3.dylib 0x43810 sqlite3_log + 104636 2 libsqlite3.dylib 0x439c sqlite3_vfs_find + 3140 3 libsqlite3.dylib 0xea87c sqlite3_sourceid + 215660 4 libsqlite3.dylib 0x2c22c sqlite3_log + 8920 5 libsqlite3.dylib 0xbfbc sqlite3_exec + 11436 6 libsqlite3.dylib 0xa5bc sqlite3_exec + 4780 7 libsqlite3.dylib 0x9c60 sqlite3_exec + 2384 8 libsqlite3.dylib 0x98d8 sqlite3_exec + 1480 9 FMDB 0x6384 -[FMDatabase executeQuery:withArgumentsInArray:orDictionary:orVAList:] + 835 (FMDatabase.m:835) 10 sqflite 0x86c8 -[SqfliteDatabase dbDoQuery:operation:] + 262 (SqfliteDatabase.m:262) 11 sqflite 0x7db8 -[SqfliteDatabase wrapSqlOperationHandler:operation:handler:] + 97 (SqfliteDatabase.m:97) 12 sqflite 0x85b8 -[SqfliteDatabase dbQuery:operation:] + 248 (SqfliteDatabase.m:248) 13 sqflite 0xb1ac __40-[SqflitePlugin handleQueryCall:result:]_block_invoke + 453 (SqflitePlugin.m:453) 14 FMDB 0xa49c __30-[FMDatabaseQueue inDatabase:]_block_invoke + 196 (FMDatabaseQueue.m:196) 15 libdispatch.dylib 0x3f88 _dispatch_client_callout + 20 16 libdispatch.dylib 0x139a8 _dispatch_sync_invoke_and_complete_recurse + 64 17 libdispatch.dylib 0x13428 _dispatch_sync_f_slow + 172 18 FMDB 0xa420 -[FMDatabaseQueue inDatabase:] + 210 (FMDatabaseQueue.m:210) 19 sqflite 0x7968 __30-[SqfliteDatabase inDatabase:]_block_invoke + 42 (SqfliteDatabase.m:42) 20 libdispatch.dylib 0x2460 _dispatch_call_block_and_release + 32 21 libdispatch.dylib 0x3f88 _dispatch_client_callout + 20 22 libdispatch.dylib 0x15b8c _dispatch_root_queue_drain + 684 23 libdispatch.dylib 0x16284 _dispatch_worker_thread2 + 164 24 libsystem_pthread.dylib 0xdbc _pthread_wqthread + 228 25 libsystem_pthread.dylib 0xb98 start_wqthread + 8
