We need explicit sqlite-aware index/locking controls in orm_loader (i.e. configurable index strategy in load_csv/manage_indices)
This could be achieved through addition of an explicit index strategy parameter to load_csv (auto, drop_rebuild, keep), where we default to auto and have sqlite resolve to keep, other DBs resolve to drop_rebuild
see temporary workaround currently implemented here: https://github.com/gkennos/graph-demo/blob/d3035ad27a817c81d4f6ffb1d917cbf57f4601e9/src/graph_demo/utils/sqlite_utils.py#L23
We need explicit sqlite-aware index/locking controls in orm_loader (i.e. configurable index strategy in load_csv/manage_indices)
This could be achieved through addition of an explicit index strategy parameter to load_csv (auto, drop_rebuild, keep), where we default to auto and have sqlite resolve to keep, other DBs resolve to drop_rebuild
see temporary workaround currently implemented here: https://github.com/gkennos/graph-demo/blob/d3035ad27a817c81d4f6ffb1d917cbf57f4601e9/src/graph_demo/utils/sqlite_utils.py#L23