ipaddr: IP Address Manipulation in SQLite

Functions to manipulate IPs and subnets. Created by Vincent Bernat.

⚠️ This extension is not available on Windows.

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

Installation and Usage

SQLite command-line interface:

sqlite> .load ./ipaddr
sqlite> select ipfamily('2001:db8::1');

See How to Install an Extension for usage with IDE, Python, etc.