sqflite_helper 0.1.1

  • Readme
  • Changelog
  • Installing
  • 48

sqflite_helper #

A small library to properly open a sqflite DB and handle the migrations.


  • Uses transactions for all schema changes.
  • Almost identical interface to sqflite.openDatabase()

Example usage #

import 'package:sqflite_helper/sqflite_helper.dart';
import 'package:sqflite/sqflite.dart';

Database db = openMigratedDatabase("path/to/db.db", 
    """CREATE TABLE mytable (name varchar);""",
    """ALTER TABLE mytable RENAME TO users;""",

Changelog #

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[0.1.0] - 2019-08-3

Added #

  • openMigratedDatabase wrapper.

Use this package as a library

1. Depend on it

Add this to your package's pubspec.yaml file:

  sqflite_helper: ^0.1.1

2. Install it

You can install packages from the command line:

with Flutter:

$ flutter pub get

Alternatively, your editor might support flutter pub get. Check the docs for your editor to learn more.

3. Import it

Now in your Dart code, you can use:

import 'package:sqflite_helper/sqflite_helper.dart';
Describes how popular the package is relative to other packages. [more]
Code health derived from static analysis. [more]
Reflects how tidy and up-to-date the package is. [more]
Weighted score of the above. [more]
Learn more about scoring.

We analyzed this package on Jan 27, 2020, and provided a score, details, and suggestions below. Analysis was completed with status completed using:

  • Dart: 2.7.0
  • pana: 0.13.4
  • Flutter: 1.12.13+hotfix.5

Health issues and suggestions

Document public APIs. (-1 points)

2 out of 2 API elements have no dartdoc comment.Providing good documentation for libraries, classes, functions, and other API elements improves code readability and helps developers find and use your API.

Format lib/sqflite_helper.dart.

Run flutter format to format lib/sqflite_helper.dart.

Maintenance suggestions

Maintain an example. (-10 points)

Create a short demo in the example/ directory to show how to use this package.

Common filename patterns include main.dart, example.dart, and sqflite_helper.dart. Packages with multiple examples should provide example/README.md.

For more information see the pub package layout conventions.


Package Constraint Resolved Available
Direct dependencies
Dart SDK >= 2.1.0 < 3.0.0
flutter 0.0.0
sqflite ^1.1.6 1.2.0
Transitive dependencies
collection 1.14.11 1.14.12
meta 1.1.8
path 1.6.4
sky_engine 0.0.99
synchronized 2.2.0
typed_data 1.1.6
vector_math 2.0.8
Dev dependencies