News for hackers. Stuff that matters.

A comment on Do Not Recommend: User Provided Primary Keys. Parent comment

Re:Do Not Recommend: User Provided Primary Keys by ciupicri on Wednesday February 23, 2022 @09:08AM (#30441062)
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?

[ Parent | on HN ]
Re:Do Not Recommend: User Provided Primary Keys by pritambaral on Wednesday February 23, 2022 @09:13AM (#30441121)
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.

[ Parent | on HN ]
Re:Do Not Recommend: User Provided Primary Keys by ciupicri on Wednesday February 23, 2022 @10:43AM (#30442260)
You'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-...

[ Parent | on HN ]
Re:Do Not Recommend: User Provided Primary Keys by hashimotonomora on Wednesday February 23, 2022 @07:52PM (#30448932)
What are some use cases for Int256?
[ Parent | on HN ]
Re:Do Not Recommend: User Provided Primary Keys by ciupicri on Thursday February 24, 2022 @07:44AM (#30454007)
Maybe SHA-256 or BLAKE3?
[ Parent | on HN ]
Re:Do Not Recommend: User Provided Primary Keys by hans_castorp on Thursday February 24, 2022 @06:08AM (#30453383)
SQL Server also has a dedicated data type for UUIDs
[ Parent | on HN ]