0.12.2 #

• add Database.isOpen which becomes false once the database is closed

0.11.1 #

• add Sqlflite.hex to allow querying on blob fields

0.11.0 #

• add getDatabasesPath to use as the base location to create a database
• Warning: database are now single instance by default (based on path), to use the old behavior use singleInstance = false when opening a database
• dart2 stable support

0.10.0 #

• Preparing for 1.0
• Remove deprecated methods (re-entrant transactions)
• Add Transaction.batch
• Show developer warning to prevent deadlock

0.9.0 #

• Support for in-memory database (:memory: path)
• Support for single instance
• new database factory for handling the new options

0.8.9 #

• Upgrade to sdk 27

0.8.8 #

• Allow testing for constraint exception

0.8.6 #

• better sql error report
• catch android native errors
• no longer print an error when deleting a database fails

0.8.4 #

• Add read-only support using openReadOnlyDatabase

0.8.3 #

• Allow running a batch during a transaction using Transaction.applyBatch
• Restore Batch.commit to use outside a transaction

0.8.2 #

• Although already in a transaction, allow creating nested transactions during open

0.8.1 #

• New Transaction mechanism not using Zone (old one still supported for now)
• Start using Batch.apply instead of Batch.commit
• Deprecate Database.inTransaction and Database.synchronized so that Zones are not used anymore

0.7.1 #

• add Batch.query, Batch.rawQuery and Batch.execute
• pack query result as colums/rows instead of List<Map>

0.7.0 #

• Add support for --preview-dart-2

0.6.2+1 #

• Add longer description to pubspec.yaml

0.6.2 #

• Fix travis warning

0.6.1 #

• Add Flutter SDK constraint to pubspec.yaml

0.6.0 #

• add support for onConfigure to allow for database configuration

0.5.0 #

• Escape table and column name when needed in insert/update/query/delete
• Export ConflictAlgorithm, escapeName, unescapeName in new sql.dart

0.4.0 #

• Add support for Batch (insert/update/delete)

0.3.1 #

• Remove temp concurrency experiment

0.3.0 #

2018/01/04

• Breaking change. Upgraded to Gradle 4.1 and Android Studio Gradle plugin 3.0.1. Older Flutter projects need to upgrade their Gradle setup as well in order to use this version of the plugin. Instructions can be found here.

0.2.4 #

• Dependency on synchronized updated to >=1.1.0

0.2.3 #

• Make Android sends the reponse in the same thread then the caller to prevent unexpected behavior when an error occured

0.2.2 #

• Fix unchecked warning on Android

0.2.0 #

• Use NSOperationQueue for all db operation on iOS
• Use ThreadHandler for all db operation on Android

0.0.3 #

• Add exception handling

0.0.2 #

• Add sqlite helpers based on Razvan Lung suggestions

0.0.1 #

• Initial experimentation

example/lib/main.dart

import 'package:flutter/material.dart';
import 'package:flutter/services.dart';
import 'package:sqflite/sqflite.dart';
import 'package:sqflite_example/exp_test_page.dart';
import 'package:sqflite_example/deprecated_test_page.dart';
import 'model/main_item.dart';
import 'open_test_page.dart';
import 'package:sqflite_example/exception_test_page.dart';
import 'raw_test_page.dart';
import 'slow_test_page.dart';
import 'src/main_item_widget.dart';
import 'type_test_page.dart';
import 'todo_test_page.dart';

void main() {
  runApp(new MyApp());
}

class MyApp extends StatefulWidget {
  // This widget is the root of your application.

  @override
  _MyAppState createState() => new _MyAppState();
}

const String testRawRoute = "/test/simple";
const String testOpenRoute = "/test/open";
const String testSlowRoute = "/test/slow";
const String testThreadRoute = "/test/thread";
const String testTodoRoute = "/test/todo";
const String testExceptionRoute = "/test/exception";
const String testExpRoute = "/test/exp";
const String testDeprecatedRoute = "/test/deprecated";

class _MyAppState extends State<MyApp> {
  var routes = <String, WidgetBuilder>{
    '/test': (BuildContext context) => new MyHomePage(),
    testRawRoute: (BuildContext context) => new SimpleTestPage(),
    testOpenRoute: (BuildContext context) => new OpenTestPage(),
    testSlowRoute: (BuildContext context) => new SlowTestPage(),
    testTodoRoute: (BuildContext context) => new TodoTestPage(),
    testThreadRoute: (BuildContext context) => new TypeTestPage(),
    testExceptionRoute: (BuildContext context) => new ExceptionTestPage(),
    testExpRoute: (BuildContext context) => new ExpTestPage(),
    testDeprecatedRoute: (BuildContext context) => new DeprecatedTestPage(),
  };
  @override
  Widget build(BuildContext context) {
    return new MaterialApp(
        title: 'Sqflite Demo',
        theme: new ThemeData(
          // This is the theme of your application.
          //
          // Try running your application with "flutter run". You'll see
          // the application has a blue toolbar. Then, without quitting
          // the app, try changing the primarySwatch below to Colors.green
          // and then invoke "hot reload" (press "r" in the console where
          // you ran "flutter run", or press Run > Hot Reload App in IntelliJ).
          // Notice that the counter didn't reset back to zero -- the application
          // is not restarted.
          primarySwatch: Colors.blue,
        ),
        home: new MyHomePage(title: 'Sqflite Demo Home Page'),
        routes: routes);
  }
}

class MyHomePage extends StatefulWidget {
  final List<MainItem> items = [];

  MyHomePage({Key key, this.title}) : super(key: key) {
    items.add(new MainItem("Raw tests", "Raw SQLite operations",
        route: testRawRoute));
    items.add(new MainItem("Open tests", "Open onCreate/onUpgrade/onDowngrade",
        route: testOpenRoute));
    items.add(
        new MainItem("Type tests", "Test value types", route: testThreadRoute));
    items.add(
        new MainItem("Slow tests", "Lengthy operations", route: testSlowRoute));
    items.add(new MainItem(
        "Todo database example", "Simple Todo-like database usage example",
        route: testTodoRoute));
    items.add(new MainItem("Exp tests", "Experimental and various tests",
        route: testExpRoute));
    items.add(new MainItem("Exception tests", "Tests that trigger exceptions",
        route: testExceptionRoute));
    items.add(new MainItem("Deprecated test",
        "Keeping some old tests for deprecated functionalities",
        route: testDeprecatedRoute));

    // Uncomment to view all logs
    //Sqflite.devSetDebugModeOn(true);
  }

  // This widget is the home page of your application. It is stateful,
  // meaning that it has a State object (defined below) that contains
  // fields that affect how it looks.

  // This class is the configuration for the state. It holds the
  // values (in this case the title) provided by the parent (in this
  // case the App widget) and used by the build method of the State.
  // Fields in a Widget subclass are always marked "final".

  final String title;

  @override
  _MyHomePageState createState() => new _MyHomePageState();
}

class _MyHomePageState extends State<MyHomePage> {
  String _platformVersion = 'Unknown';

  int get _itemCount => widget.items.length;

  @override
  initState() {
    super.initState();
    initPlatformState();
  }

  // Platform messages are asynchronous, so we initialize in an async method.
  initPlatformState() async {
    String platformVersion;
    // Platform messages may fail, so we use a try/catch PlatformException.
    try {
      platformVersion = await Sqflite.platformVersion;
    } on PlatformException {
      platformVersion = "Failed to get platform version";
    }

    // If the widget was removed from the tree while the asynchronous platform
    // message was in flight, we want to discard the reply rather than calling
    // setState to update our non-existent appearance.
    if (!mounted) return;

    setState(() {
      _platformVersion = platformVersion;
    });

    print("running on: " + _platformVersion);
  }

  @override
  Widget build(BuildContext context) {
    return new Scaffold(
        appBar: new AppBar(
          title: new Center(
              child: new Text('Sqflite demo', textAlign: TextAlign.center)),
        ),
        body: new ListView.builder(
            itemBuilder: _itemBuilder, itemCount: _itemCount));
  }

  //new Center(child: new Text('Running on: $_platformVersion\n')),

  Widget _itemBuilder(BuildContext context, int index) {
    return new MainItemWidget(widget.items[index], (MainItem item) {
      Navigator.of(context).pushNamed(item.route);
    });
  }
}