Mert

The update to `fileCreatedAt`, `fileModifiedAt` and `originalFileName` is unnecessary and can be handled in metadata extraction since this will be queued anyway. This makes the batched update for `isOffline` and...

> > The update to `fileCreatedAt`, `fileModifiedAt` and `originalFileName` is unnecessary and can be handled in metadata extraction since this will be queued anyway. This makes the batched update for...

I don't see why fileModifiedAt needs a non-null constraint in the DB. Might just be an oversight that didn't matter because it didn't affect our usage. I think you can...

I think queueing sidecar discovery would introduce a race condition where it could run before, during or after metadata extraction. Since the refresh logic is already so much better, maybe...

I haven't looked closely at the sidecar discovery job either, but I think it's an issue either way since it's possible for jobs dependent on the metadata to behave differently....

@etnoy I made a few changes, let me know if there's anything that seems off.

The command "upgrading" to 0.2.0 meant that it never tried to actually upgrade the extension. You should run `UPDATE pg_catalog.pg_extension SET extversion = '0.1.11' WHERE extname = 'vectors';`. If it...

I think this should be tracked as an issue rather than a discussion, especially as this is due to poor optimization rather than a hardware limitation.

> The migration from save to update all seems quite independent of prisma. Can You pull those changes into a separate PR? Good idea!

Prisma is too limited, both in the queries it can express, the database features it supports and the customization it offers.