Repository navigation
Support of Scanner and Valuer Interfaces in database/sql #80
Description
If we could receive bigint as SonyflakeID types from the RDB, we could easily use them with ORM.
To receive SonyflakeID types from the RDB, we need to implement the sql.Scanner interface and the driver.Vuler interface.
-
Scanner Interface
https://pkg.go.dev/database/sql#Scanner -
Valuer Interface
https://pkg.go.dev/database/sql/driver#Valuer -
uuid Scan
https://github.com/google/uuid/blob/v1.6.0/sql.go#L15-L52 -
ulid Scan
https://github.com/oklog/ulid/blob/main/ulid.go#L499-L547
Activity
YoshiyukiMineo commentedon Sep 15, 2025
One of the benefits of Sonyfake is that a Sonyflake ID is just a int64. So you can easily handle Sonyflake IDs as BIGINT in RDB.
Add Scanner and Valuer interfaces for database/sql support