Implement custom identity query #41

New issue

Closed

opened 2024-12-26 14:58:39 +00:00 by Ghost · 0 comments

Ghost commented

2024-12-26 14:58:39 +00:00

(Migrated from codeberg.org)

Description

Right now, querying for an identity using the identifier is using Kratos' List Identities endpoint with the experimental preview_credentials_identifier_similar query param. This endpoint doesn't provide the search features I would want for searching an identity.

It basically matches using a startsWith(<query>) instead of an === query.

This is why I will implement a custom query function by directly connecting to the Kratos DB using Drizzle ORM. With that I can query on identitfiers, credentials, traits and more and provide a reliable query to find an identity.

The query will have to be tested on big datasets to make sure it is fast and also doesn't slow down Kratos.

## Description Right now, querying for an identity using the identifier is using Kratos' [List Identities](https://www.ory.sh/docs/kratos/reference/api#tag/identity/operation/listIdentities) endpoint with the experimental `preview_credentials_identifier_similar` query param. This endpoint doesn't provide the search features I would want for searching an identity. It basically matches using a `startsWith(<query>)` instead of an `=== query`. This is why I will implement a custom query function by directly connecting to the Kratos DB using [Drizzle ORM](https://github.com/drizzle-team/drizzle-orm). With that I can query on identitfiers, credentials, traits and more and provide a reliable query to find an identity. The query will have to be tested on big datasets to make sure it is fast and also doesn't slow down Kratos.