On Mon, Jul 2, 2012 at 4:29 AM, Niall O'Reilly <niall.orei...@ucd.ie> wrote: > > On 29 Jun 2012, at 23:58, Richard Hipp wrote: > >> But you know: How often do people use BLOBs as keys? What other SQL >> engines other than SQLite even allow BLOBs as keys? Are we trying to >> optimize something that is never actually used? > > For an IPAM application I have on my back burner, BLOB seems > a natural way to express IPv[46] addresses, ranges, and prefixes. > A bulkier alternative would be hexadecimal encoding as text.
That reminds me: it'd be nice to have a bit string type, since the correct way to sort IPv4 CIDR blocks is as bit strings. This is also a proper way to sort IPv6 blocks. Alternatively, it'd be nice to have native IP address types in SQLite4, as otherwise one has to jump through hoops to handle IP addresses properly. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users