ULID data type for DuckDB
Installing and Loading
INSTALL ulid FROM community;
LOAD ulid;
Example
SELECT ulid() AS result;
About ulid
This extension adds a new ULID data type to DuckDB.
A ULID is similar to a UUID except that it also contains a timestamp component, which makes it more suitable for use cases where the order of creation is important.
Additionally, the string representation is lexicographically sortable while preserving the sort order of the timestamps.
Added Functions
| function_name | function_type | description | comment | example |
|---|---|---|---|---|
| ulid | scalar | |||
| ulid_epoch_ms | scalar | |||
| ulid_timestamp | scalar |
Added Types
| type_name | type_size | logical_type | type_category | internal |
|---|---|---|---|---|
| ULID | 16 | UHUGEINT | NUMERIC | true |