Does this support mobile and flutter?

[zhubarb]

The only dart/flutter compatible vector db project I am aware of is this: https://github.com/FastCodeAI/DVDB.

I was wondering whether this would support Android / IoS / Flutter?

Specifically, Flutter has the following package: import 'package:sqflite/sqflite.dart' [1]; and I am curious whether this sqlite-vec would be compatible with this?

[asg017]

Ideally it should work on mobile devices. It's written in portable C, so theoretically you should be able to compile sqlite-vec to work on any mobile device.

I'm unsure about sqflite, however. Is it possible to load sqlite extensions in sqflite? I can't seem to find any examples of that in their documentation. I guess we could compile on own version of SQLite with sqlite-vec builtin, but I'm unsure how the sqflite ecosystem usually handles these things

To be clear: I 100% want sqlite-vec to work on all devices, including Android/iOS/Flutter/Dart etc. But I haven't personally ever done much mobile development in the past. Would be happy to make it work if someone shows me the ropes!

[zhubarb]

Hi Alex, Makes sense, thanks. I think flutter/dart would be good for "two birds-one stone"ing the problem in terms of Android and IoS compatibility.

Regarding the ability to load extensions with sqflite, I found:

1. https://stackoverflow.com/questions/53351775/loading-json1-extension-with-flutter-sqflite
2. fts5 support tekartik/sqflite#105

I will keep digging, and post here if I find a lead.

[rodydavis]

Made a flutter example, even got it working on MacOS!

https://github.com/rodydavis/flutter_sqlite_document_search

[rodydavis]

Currently there are some blockers for web:
simolus3/sqlite3.dart#247

[rodydavis]

PR: #119