Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom

UUID support? #509

Open
StayBlue opened this issue Dec 18, 2024 · 3 comments
Open

UUID support? #509

StayBlue opened this issue Dec 18, 2024 · 3 comments

Comments

@StayBlue
Copy link

One of the nice things about libSQL is that it supports UUIDs through an (experimental) extension. Are there any plans to have this feature in Limbo?
@StayBlue StayBlue changed the title UUID support UUID support? Dec 18, 2024
@pereman2
Copy link
Collaborator

If it is in libsql, it most likely means we will get to it in the future. At the end of the day, we want the same things.

@PThorpe92 PThorpe92 mentioned this issue Dec 20, 2024
Merged
penberg added a commit that referenced this issue Dec 23, 2024
@penberg
Merge 'UUID support' from Preston Thorpe
58292c1 
#509
Started the discussion on discord about possibly supporting UUID types
natively. This PR only implements the `sqlean` extension's functions and
behavior, with the only changes being:
1. uuid's are returned as `blob`s by default. (that was an assumption I
made considering perf, thinking this would be preferred if UUID ended up
being a supported native type.  if `text` is preferred I can change it)
2.  `uuidv7` types here can accept an argument of seconds since epoch to
customize the embedded timestamp. The func
`uuidv7_timestamp_ms(string_or_blob_v7)` allows the user to convert
their uuid7 back into the timestamp.
![image](https://github.com/user-
attachments/assets/ca53ee9b-f1f1-410b-955f-acd140bd4989)

Closes #518
@StayBlue
Copy link
Author

With #518 being merged, should this be closed?

@pereman2
Copy link
Collaborator

I think so @PThorpe92, is something missing?

# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@StayBlue @pereman2