internet
13 internet types: 3 a sibling also accepts and reads alike, 6 that decompose into parts.
The 13 internet types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Hostname hostname · VARCHAR | example.com | top_level_domain |
IPv4 Address ip_v4 · VARCHAR | 192.168.1.1 | hostname |
Top-Level Domain (TLD) top_level_domain · VARCHAR | com | hostname |
CIDR Notation cidr · VARCHAR | 192.168.1.0/24 | — |
Data URI data_uri · VARCHAR | data:text/plain;base64,SGVsbG8gV29ybGQ= | — |
HTTP Method http_method · VARCHAR | GET | — |
IPv4 Address with Port ip_v4_with_port · VARCHAR | 192.168.1.1:8080 | — |
IPv6 Address ip_v6 · VARCHAR | 2001:0db8:85a3:0000:0000:8a2e:0370:7334 | — |
MAC Address mac_address · VARCHAR | 00:1a:2b:3c:4d:5e | — |
Email Message-ID message_id · VARCHAR | <30365805.1075860998985.JavaMail.evans@thyme> | — |
URL url · VARCHAR | https://example.com/path/to/resource | — |
URN urn · VARCHAR | urn:isbn:0451450523 | — |
User Agent String user_agent · VARCHAR | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 | — |
Which internet type is it?
2 of 13 internet types accept it, and read it alike.
| Type | Reads it as |
|---|---|
Hostname hostname | example.com |
Top-Level Domain (TLD) top_level_domain | example.com |
Use it
CLI · DuckDB
$ printf '%s\n' 'example.com' 'www.google.com' > column.txt
$ finetype infer -f column.txt --mode column
SELECT ft_profile(v) FROM (VALUES ('example.com'), ('www.google.com')) t(v);After www.google.com, one type remains: hostname.