Stack Overflow
Stack Overflow

Questions tagged [ulid]

7 questions
4
votes
0 answers

ULID datatype in SQL Server database

While searching for UUIDs I stumbled upon ULIDs https://github.com/ulid/spec And I want to use them in my SQL Server database as primary key for my users (instead of basic incremental value). So I wanted to ask: What datatype is the best suited?…
Kebechet
  • 1,461
  • 15
  • 31
2
votes
3 answers

How would one convert a UUID type to ULID type?

Theres a bit documentation out there how to convert ULID to UUID but not so much when you need to convert UUID to ULID. I'm looking at this UUID / ULID generator / converter https://www.ulidtools.com/ but I'm not quite sure how I would replicate the…
user3621898
  • 589
  • 5
  • 24
0
votes
1 answer

Why the Str::ulid() method in Laravel always return the ulid in uppercase?

I am using Laravel and when I get the result of this method: return (string) Str::ulid(); it returns this: 01H32R5Z0NDY1WRYWKWT20ZQYM I was trying the get something like this: 01gd6r360bp37zj17nxb55yv40 I would like it to return a mix of…
DeveloperX
  • 517
  • 5
  • 23
0
votes
0 answers

How can I conver ULID binary to string using Google BigQuery?

I stored ULID BINARY data in to google BigQuery database. how can I format the BINARY(BYTE in BigQuery?) to ULID string ? Ulid Spec https://github.com/ulid/spec This is MariaDB version Function definition DELIMITER // CREATE OR REPLACE FUNCTION…
bravo
  • 1
0
votes
1 answer

Append a column with an ULID to an existing MySQL table

I'm trying to append a column with an ULID to an existing MySQL table. I know how to do it with a function and an update query: delimiter // DROP FUNCTION IF EXISTS ulid// CREATE FUNCTION ulid () RETURNS CHAR(26) DETERMINISTIC BEGIN DECLARE s_hex…
Medical physicist
  • 2,510
  • 4
  • 34
  • 51
0
votes
0 answers

What format should a REST API use for ULIDs? i.e. Base32 or RFC4122

ULID Base32 01GMEX2SA207FNV8E19QM8EJ4M is the same as RFC4122 01851dd1-6542-01df-5da1-c14de8874894. Postgresql appears to store the ULIDs in RFC4122 format. Both GET /assets/01GMEX2SA207FNV8E19QM8EJ4M/resource_acl and GET…
user1032531
  • 24,767
  • 68
  • 217
  • 387
0
votes
1 answer

Is this a safe way to use ulid concurrently with other libraries too?

I'm trying to use for the first time the ulid package. In their README they say: Please note that rand.Rand from the math package is not safe for concurrent use. Instantiate one per long living go-routine or use a sync.Pool if you want to avoid the…
Fred Hors
  • 3,258
  • 3
  • 25
  • 71