sqlite

Overview

Provides an adapter for using the package database with SQLite. The implementation uses the package sqflite.

Links

• Issue tracker in Github
• Source code in Github
• API reference

Getting started

1.Add dependency

dependencies:
  database: any
  database_adapter_sqlite: any

2.Configure

import 'package:database/database.dart';
import 'package:database/sql.dart';
import 'package:database_adapter_sqlite/database_adapter_sqlite.dart';

Future main() async {
  final config = SQLite(
    path: 'path/to/database.db',
  );

  final sqlClient = config.database().sqlClient;

  final result = await database.querySql('SELECT name FROM employee').toRows();
  for (var row in result.rows) {
    print('Name: ${row[0]}');
  }
}