TestaDiMucca / Hoarder-Util

CLI and UI tool that does some basic file operations for file storage and organization.

1 stars 0 forks source link

[internal] Add indices to uuid columns #148

Closed Jkwok0714 closed 1 week ago

Jkwok0714 commented 2 weeks ago

Description

SQLite does not have native support for uuid, so the uuid columns are strings.

Since we will perform a number of operations by uuid instead of the integer database id, we should add an index even though data sizes should not be expected to be very large..

Unknowns

Things that need to be investigated if any.