🛠️ [TASK] : Spike db libs

[damian-molinski]

Summary

Test available options for web / ios / android

Description

SQL

• Drift
• Floor
• sqflite

NoSQL

• isar
• sembast
• objectbox

[damian-molinski]

Isar

1. NoSQL is no go for me giving scale and complexity of this project.
2. NoSQL == No relations. Big -
3. Library was updated 21 months ago and looks like nothing is happening on repo either
4. Seems like has some outstanding unresolved issues such as https://github.com/isar/isar/issues/1068

[damian-molinski]

sembast

1. Seem like viable option but for smaller data sets. Its not very memory friendly (see https://github.com/tekartik/sembast.dart/issues/387 and https://github.com/tekartik/sembast.dart/issues/306 / https://github.com/tekartik/sembast.dart/blob/master/sembast/doc/usage_recommendations.md )
2. NoSQL == No relations

[damian-molinski]

objectbox

1. No support for web. No go

[damian-molinski]

sqflite

1. Relational db. Works on web mobile and macos (no linux or windows. Its possible via ffi but its not those platforms are not first class citizens)

[damian-molinski]

floor

1. No updates for last 8 months.
2. No web support (https://pinchbv.github.io/floor/platform-support/)

[damian-molinski]

drift

1. Works on all platforms
2. Nice interface and code generation base on sqflite
3. Relational DB

[damian-molinski]

drift is only option for me at the moment but i'll wait for architects to give their recommendations