technology
Network addresses, hashes, URIs, and device identifiers
7 categories, 30 types: 6 a sibling in its category also accepts, 18 accepted by another category's rule, 19 that decompose into parts.
The 7 technology categories
Each category's lookup value, against every other category's rule
| Category | Types | Casts to | For example | Within the group | Also accepted by |
|---|---|---|---|---|---|
| 13 | VARCHAR | example.com | 3 a sibling also accepts | code, development, filesystem | |
| 4 | VARCHAR | 10.1038/nature12373 | each told apart | cryptographic, development, filesystem, internet | |
| 3 | VARCHAR | 5d41402abc4b2a76b9719d911017… | 1 a sibling also accepts | code, development, internet | |
| 3 | VARCHAR | 2024.02.09 | 2 a sibling also accepts | filesystem, internet | |
| 3 | VARCHAR, BIGINT | 175928847299117063 | each told apart | cryptographic, development, internet | |
| 2 | VARCHAR | arn:aws:s3:::my-bucket | each told apart | — | |
| 2 | VARCHAR | report_final.xlsx | each told apart | development |
Where technology categories overlap
Each type's lookup value, against every other category's rule
Which technology type is it?
5 of 30 technology types in 3 categories accept it, and read it alike.
| Type | Category | Reads it as |
|---|---|---|
Calendar Version calver | development | 2024.02.09 |
Docker/OCI Image Reference docker_ref | development | 2024.02.09 |
Version Number version | development | 2024.02.09 |
Filename filename | filesystem | 2024.02.09 |
Hostname hostname | internet | 2024.02.09 |
What the engine extracts
- internet6 of 13domain · hostname · ip · is_base64 · local · media_type · network · nid · nss · path · port · prefix_length · scheme
- code3 of 4country · language · leaf · registrant · root · suffix
- cryptographic2 of 3algorithm · header · payload · signature
- development3 of 3day · digest · major · metadata · minor · month · patch · prerelease · registry · repository · tag · year
- identifier1 of 3sequence · timestamp_ms · worker_id
- cloud2 of 2account_id · bucket · key · partition · region · resource · service
- filesystem2 of 2drive · extension · filename · stem
Use it
One value from each category, each inferred on its own
CLI · DuckDB
$ for v in 'example.com' '10.1038/nature12373' '5d41402abc4b2a76b9719d911017c592' '2024.02.09' '175928847299117063' 'arn:aws:s3:::my-bucket' 'report_final.xlsx'; do finetype infer -i "$v"; done
SELECT v, ft_infer(v) FROM (VALUES ('example.com'), ('10.1038/nature12373'), ('5d41402abc4b2a76b9719d911017c592'), ('2024.02.09'), ('175928847299117063'), ('arn:aws:s3:::my-bucket'), ('report_final.xlsx')) t(v);