immich icon indicating copy to clipboard operation
immich copied to clipboard

refactor: database repository

Open jrasm91 opened this issue 9 months ago • 3 comments

Migrate database repository to use kysely.

TypeORM is now gone from everything, outside of migrations. :tada:

  • Replace dynamic/automatic on conflict statements with explicit column names
  • Add CREATE EXTENSION IF NOT EXISTS "uuid-ossp" to first migration (this was previously done automatically by TypeORM)
  • Remove TypeORM reconnection logic that was added in #12320. We may need to revisit this to see how it works with kysely

jrasm91 avatar Mar 04 '25 18:03 jrasm91

/s/not/now

zackpollard avatar Mar 04 '25 18:03 zackpollard

@mertalev were you able actually to test pgvector upgrades?

jrasm91 avatar Mar 04 '25 21:03 jrasm91

@mertalev were you able actually to test pgvector upgrades?

I tested pgvecto.rs 0.2.0 -> 0.3.0 and immich 1.90.2 (last typesense release) -> this PR

mertalev avatar Mar 04 '25 21:03 mertalev