feature request: customize id generation method

[rockey2020]

Describe the bug

1.The id of my user table is uuid data type

2.When I initiate the request, the data type error occurs
invalid input syntax for type uuid: "ZUnIm3tHexoJ"

3.When I get my user information, I see the corresponding string, and I don't understand why I don't use a separate id to store the userId

Expected behavior

succee

How to reproduce?

Context

OS:

Environment:
Docker

Logto version:
1.1.0

Node version:
19

Postgres version:
15

Command of starting Logto:

Screenshots

[rockey2020]

Can you provide option setting about user id generation, allow user to define int, string or uuid generation type

[simeng-li]

If you are trying to keep Logto as the SSOT of your user data, I would prefer following the original user ID's data source type when adding new mapping fields in a foreign table. Will you be able to change the id type in your own table?

[rockey2020]

@simeng-li
yes As you said, when I change the id type of my own table to text, it will work.
But logto's id rules should be able to be generated by the user, for example, by exposing a variable in docker-compose.yml for the user to choose the type or something

[gao-sun]

@rockey2020 are you interested in contributing? since currently we have no plan to support this.

[rockey2020]

@gao-sun sure This week I took the time to look at the code and submit a commit

[gao-sun]

@rockey2020 it'll be great if we can start with a simple tech design since it's more than a commit. e.g. how would we store uuid in the current database schema.

[rockey2020]

@gao-sun after I read your code structure, I will explain how I will modify your code and ask for your opinion before I start writing it

[gao-sun]

@rockey2020 sounds awesome