3 ms·
Why wouldn't a dedicated data type be more efficient than an improvisation with CHAR, a pair of two BIGINT/INT8, INT16* or BLOB? * Is there a SQL database with
by ciupicri 5y ago
Why wouldn't a dedicated data type be more efficient than an improvisation with CHAR, a pair of two BIGINT/INT8, INT16* or BLOB?
* Is there a SQL database with support for 128 bit integers?
- pritambaral 5y agoPostgreSQL 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