Functions to manipulate IPs and subnets. Created by Vincent Bernat.
Returns the family of a specified IP address.
sqlite> select ipfamily('192.168.1.1');
4
Returns the host part of an IP address.
sqlite> select iphost('2001:db8::123/64');
2001:db8::123
Returns the prefix length of an IP address.
sqlite> select ipmasklen('192.168.16.12/24');
24
Returns the network part of an IP address.
sqlite> select ipnetwork('192.168.16.12/24');
192.168.16.0/24
Returns 1 if subnet contains ip (which can be another subnet).
0 otherwise.
sqlite> select ipcontains('192.168.16.0/24', '192.168.16.3');
1
sqlite> .load ./ipaddr
sqlite> select ipfamily('2001:db8::1');
6