SQLite3 library for windows

This package help you bundle SQLite3 library to your apps.

He was originally developed to use with moor but you can use it for others use cases that need SQLite3.

How to use with Moor

Be sure to follow all the steps to migrate from moor_flutter to moor ffi (doc).

Add an override for windows and give it the openSQLiteOnWindows function provided by the package:

import 'dart:ffi';
import 'dart:io';
import 'package:sqlite3/sqlite3.dart';
import 'package:sqlite3/open.dart';
import 'package:sqlite3_library_windows/sqlite3_library_windows.dart';

void main() {
  open.overrideFor(OperatingSystem.windows, openSQLiteOnWindows);

  final db = sqlite3.openInMemory();
  db.dispose();
  
  runApp(MyApp());
}

And... that's it! No need to provide your own sqlite3.dll file🙂

Libraries

sqlite3_library_windows