netquack.md

warning	title	excerpt	extension	repo	docs	extension_star_count	extension_star_count_pretty	extension_download_count	extension_download_count_pretty	image	layout
DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there	netquack	DuckDB Community Extensions DuckDB extension for parsing, extracting, and analyzing domains, URIs, and paths with ease.	name description version language build license maintainers netquack DuckDB extension for parsing, extracting, and analyzing domains, URIs, and paths with ease. 1.2.0 C++ cmake MIT hatamiarash7	github ref hatamiarash7/duckdb-netquack 8094acb2ed43eb20e1ef56f54e91cc49c0788d62	extended_description This extension designed to simplify working with domains, URIs, IPs, and web paths directly within your database queries. Whether you're extracting top-level domains (TLDs), parsing URI components, or analyzing web paths, Netquack provides a suite of intuitive functions to handle all your network tasks efficiently. Built for data engineers, analysts, and developers. With Netquack, you can unlock deeper insights from your web-related datasets without the need for external tools or complex workflows. Check the [documentation](https://github.com/hatamiarash7/duckdb-netquack) for more details and examples on each function.	11	11	507	507	/images/community_extensions/social_preview/preview_community_extension_netquack.png	community_extension_doc

Installing and Loading

INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};

{% if page.docs.hello_world %}

Example

{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}

### Added Functions

<div class="extension_functions_table"></div>

|      function_name       | function_type |                description                 | comment |                              examples                               |
|--------------------------|---------------|--------------------------------------------|---------|---------------------------------------------------------------------|
| extract_domain           | scalar        | Extracting the main domain from a URL      | NULL    | [SELECT extract_domain('a.example.com') as domain;]                 |
| extract_host             | scalar        | Extracting the hostname from a URL         | NULL    | [SELECT extract_host('https://b.a.example.com/path/path') as host;] |
| extract_path             | scalar        | Extracting the path from a URL             | NULL    | [SELECT extract_path('example.com/path/path/image.png') as path;]   |
| extract_query_string     | scalar        | Extracting the query string from a URL     | NULL    | [SELECT extract_query_string('example.com?key=value') as query;]    |
| extract_schema           | scalar        | Extracting the schema from a URL           | NULL    | [SELECT extract_schema('mailto:[email protected]') as schema;]    |
| extract_subdomain        | scalar        | Extracting the subdomain from a URL        | NULL    | [SELECT extract_subdomain('test.example.com.ac') as dns_record;]    |
| extract_tld              | scalar        | Extracting the top-level domain from a URL | NULL    | [SELECT extract_tld('a.example.com') as tld;]                       |
| get_tranco_rank          | scalar        | Getting the Tranco rank of a domain        | NULL    | [SELECT get_tranco_rank('cloudflare.com') as rank;]                 |
| update_suffixes          | scalar        | Update public suffixes                     | NULL    | [SELECT update_suffixes();]                                         |
| update_tranco            | scalar        | Update tranco data                         | NULL    | [SELECT update_tranco(true);]                                       |
| ipcalc                   | table         | NULL                                       | NULL    | [NULL]                                                              |
| get_tranco_rank_category | scalar        | NULL                                       | NULL    | [NULL]                                                              |
| netquack_version         | table         | NULL                                       | NULL    | [NULL]                                                              |