How to encrypt the SQLite database in Flutter?

Question

I am creating a database in Flutter by the following code, is there any way we can encrypt the database?

Is there any library available for Flutter?

initDb() async {
    io.Directory documentsDirectory = await getApplicationDocumentsDirectory();
    String path = join(documentsDirectory.path, "test.db");
    var theDb = await openDatabase(path, version: 1, onCreate: _onCreate);
    return theDb;
  }

score 6 · Answer 1 · answered May 08 '18 at 18:11

6

Pointy Castle seems to be the encryption library of choice at the moment.

answered May 08 '18 at 18:11

Randal Schwartz

39,428
4
43
70

3

Do we have anything exactly like SQLCipher ?? – Raja Jawahar May 10 '18 at 04:08
@RajaJawahar Yes. See https://pub.dartlang.org/packages/flutter_sqlcipher – Arto Bendiken Dec 04 '18 at 20:23
1

FYI - As of March16, 2020, Pointy Castle is no longer being maintained. – eimmer Mar 16 '20 at 06:54
1

@eimmer PointyCastle has been moved here: https://github.com/bcgit/pc-dart – MatPag Apr 29 '20 at 07:39
What are the advantages of using SQLChieper rather than Pointy Castle? – AlexPad Nov 06 '20 at 16:41

score 1 · Answer 2 · answered Nov 29 '18 at 08:21

1

Current sqflite uses whatever sqlite version the platform provides. There is a discussion about that here that you could follow here: https://github.com/tekartik/sqflite/issues/32

The only solution I am aware now is this one https://github.com/QwilApp/encrypted_sqlite which can be used as a drop-in replacement to sqflite which as you stated uses SQLCipher on the native side

answered Nov 29 '18 at 08:21

alextk

5,713
21
34

2

Hi, @alextk You might want to update this answer with your library https://pub.dev/packages/sembast Thanks! :) – DazChong Jul 12 '19 at 03:24
@DazChong well the question was about encrypting sqlite database, sembast is an alternative but it ain't no sql! – alextk Jul 12 '19 at 17:52

score 1 · Answer 3 · answered Aug 12 '19 at 19:47

1

I am also looking for such a library today.

And finally I found flutter_sqlcipher in pub.dev, which really solved my problem.

Here is the description of it.

This is a Flutter plugin that bundles and wraps SQLCipher for Android, an open-source extension to SQLite that provides transparent 256-bit AES encryption of database files.

Hope it helps you.

answered Aug 12 '19 at 19:47

NeroSong

11
3

1

Caveat: _Android only, at present. (iOS support is planned.)_ [Source](https://pub.dev/packages/flutter_sqlcipher#compatibility) – lo2ndii Aug 24 '20 at 14:00

How to encrypt the SQLite database in Flutter?

3 Answers3

Linked

Related