Search Shortcut cmd + k | ctrl + k

- Overview
- Documentation
- Development
- Download Metrics
- FAQ
- Core Extensions
- List of Community Extensions

- shellfs
- duckpgq
- ulid
- faiss
- open_prompt

ulid
Downloads 386this week

ULID data type for DuckDB

Extension repository on GitHub
Extension descriptor (YAML)

### 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