Database - SQLite

[ReessKennedy]

I was hoping the index was already in a SQLite db so I could see if I could use the unique IDs assigned to a path as a universal id for image sharing (even if path changes) but looks like the SQLite Db is currenty not the full index and just for the job processing, as mentioned here: #1293

It's also encrypted so couldn't open it in TablePlus.

So the current database is Go's bolt? I guess I am confused about where the index is stored.

Amazing work on this @gtsteffaniak .... really almost deserves it's own name since the index and API make it so much different than original Filebrowser.

[gtsteffaniak]

yep -- see

1. bbolt/boltdb alternative #1026
2. Investigate optimize for memory #807

[gtsteffaniak]

Hey btw check out this experimental build which uses SQLite for indexing.

The benefit is reduced memory usage, but it is a bit slower and more io heavy. But seems like a decent compromise.

https://github.com/gtsteffaniak/filebrowser/discussions/1666