3 ms·
PostgreSQL natively supports a UUID datatype. SQLite provides an official extension to add UUID support. Since you asked for "SQL database" and not really "OLT
by pritambaral 5y ago
PostgreSQL natively supports a UUID datatype. SQLite provides an official extension to add UUID support.
Since you asked for "SQL database" and not really "OLTP database": ClickHouse natively supports UUID and 128-bit numeric datatypes. I think by now it also supports 256-bit.
- ciupicri 5y agoYou're right it, Clickhouse has UInt8, UInt16, UInt32, UInt64, UInt128, UInt256, Int8, Int16, Int32, Int64, Int128, Int256 [1]. [1]: https://clickhouse.com/docs/en/sql-reference/data-types/int-uint/ https://clickhouse.com/docs/en/sql-reference/data-types/int-...
- hashimotonomora 5y agoWhat are some use cases for Int256?
- ciupicri 5y agoMaybe SHA-256 or BLAKE3?
- hans_castorp 5y agoSQL Server also has a dedicated data type for UUIDs