Fun fact, ipv6 addresses are bigger than BigInts.
Conversation
Replying to
My concept of a bigint is like 4096 bits (RSA) so I guess you mean some really small bigint. 😜
1
1
1
SQLite only has a single INTEGER type encoding 64-bit integers as a variable length integer.
sqlite.org/datatype3.html
Columns in SQLite have a preferred storage format (affinity) rather than types.
sqlite.org/datatype3.html
BIGINT is one of many aliases for INTEGER affinity.
2
Yes, that is a long winded way of saying what I said, thanks.
1
I'm clarifying for that BIGINT is part of SQLite's compatibility cruft for column type names. It doesn't have a BIGINT type and they inherited those alias names as cruft from every other mainstream database. It's worth reading what I linked to see what a mess that is.
1
2
"BIGINT" isn't even explicitly an alias for INTEGER affinity. Every type name containing the string "INT" is an alias for INTEGER.
They give the example of "FLOATING POINT" mapping to INTEGER affinity because "INT" is matched before the rule for "FLOA". It's pretty gross.