DuckDB Netquack Extension
July 25, 2026 Β· View on GitHub

This extension is designed to simplify working with domains, URIs, 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.
NetQuack uses ClickHouse-inspired character-by-character parsing and gperf-generated perfect hash functions for optimal performance.
Table of Contents
- DuckDB Netquack Extension
- Installation π
- Usage Examples π
- Extracting The Main Domain
- Extracting The Path
- Extracting The Host
- Extracting The Schema
- Extracting The Query
- Extracting The Port
- Extracting The File Extension
- Extracting The TLD (Top-Level Domain)
- Extracting The Sub Domain
- Extracting The Fragment
- Get Tranco Rank
- IP Address Functions
- Normalize URL
- Domain Depth
- Base64 Encode / Decode
- Validate URL
- Validate Domain
- Extract Path Segments
- URL Encode / Decode
- Get Extension Version
- Build Requirements
- Debugging
- Roadmap πΊοΈ
- Contributing π€
- Issues π
Installation π
netquack is distributed as a DuckDB Community Extension and can be installed using SQL:
SET allow_community_extensions = true;
INSTALL netquack FROM community;
LOAD netquack;
If you previously installed the netquack extension, upgrade using the FORCE command
FORCE INSTALL netquack FROM community;
LOAD netquack;
Also, you can check for any available updates for the extension using this command:
UPDATE EXTENSIONS (netquack);
The compatibility between Netquack and DuckDB varies across versions.
| Version of Netquack | Version of DuckDB |
|---|---|
| v1.13.0 | v1.5.5 |
| v1.12.1 | v1.5.3 |
| v1.12.0 | v1.5.2 |
| v1.11.2 | v1.5.2 |
| v1.11.1 | v1.5.1 |
| v1.11.0 | v1.4.4 |
Usage Examples π
Once installed, the macro functions provided by the extension can be used just like built-in functions.
Extracting The Main Domain
This function extracts the main domain from a URL using an optimized static TLD lookup system. The extension uses Mozilla's Public Suffix List compiled into a gperf-generated perfect hash function for O(1) TLD lookups with zero collisions.
D SELECT extract_domain('a.example.com') AS domain;
βββββββββββββββ
β domain β
β varchar β
βββββββββββββββ€
β example.com β
βββββββββββββββ
D SELECT extract_domain('https://b.a.example.com/path') AS domain;
βββββββββββββββ
β domain β
β varchar β
βββββββββββββββ€
β example.com β
βββββββββββββββ
The TLD lookup is built into the extension at compile time using the latest Mozilla Public Suffix List. No runtime downloads or database operations are required.
Extracting The Path
This function extracts the path from a URL.
D SELECT extract_path('https://b.a.example.com/path/path') AS path;
ββββββββββββββ
β path β
β varchar β
ββββββββββββββ€
β /path/path β
ββββββββββββββ
D SELECT extract_path('example.com/path/path/image.png') AS path;
ββββββββββββββββββββββββ
β path β
β varchar β
ββββββββββββββββββββββββ€
β /path/path/image.png β
ββββββββββββββββββββββββ
Extracting The Host
This function extracts the host from a URL.
D SELECT extract_host('https://b.a.example.com/path/path') AS host;
βββββββββββββββββββ
β host β
β varchar β
βββββββββββββββββββ€
β b.a.example.com β
βββββββββββββββββββ
D SELECT extract_host('example.com:443/path/image.png') AS host;
βββββββββββββββ
β host β
β varchar β
βββββββββββββββ€
β example.com β
βββββββββββββββ
Extracting The Schema
This function extracts the schema from a URL. Supported schemas for now:
http|httpsftpmailtotel|sms
D SELECT extract_schema('https://b.a.example.com/path/path') AS schema;
βββββββββββ
β schema β
β varchar β
βββββββββββ€
β https β
βββββββββββ
D SELECT extract_schema('mailto:someone@example.com') AS schema;
βββββββββββ
β schema β
β varchar β
βββββββββββ€
β mailto β
βββββββββββ
D SELECT extract_schema('tel:+123456789') AS schema;
βββββββββββ
β schema β
β varchar β
βββββββββββ€
β tel β
βββββββββββ
Extracting The Query
Query String
The extract_query_string function extracts the query string from a URL as a single string.
D SELECT extract_query_string('example.com?key=value') AS query;
βββββββββββββ
β query β
β varchar β
βββββββββββββ€
β key=value β
βββββββββββββ
D SELECT extract_query_string('http://example.com.ac/path/?a=1&b=2') AS query;
βββββββββββ
β query β
β varchar β
βββββββββββ€
β a=1&b=2 β
βββββββββββ
Query Parameters
The extract_query_parameters table function parses the query string and returns each key-value pair as a separate row. This is useful for analyzing URL parameters in a structured way.
D SELECT * FROM extract_query_parameters('http://example.com/path/?a=1&b=2');
βββββββββββ¬ββββββββββ
β key β value β
β varchar β varchar β
βββββββββββΌββββββββββ€
β a β 1 β
β b β 2 β
βββββββββββ΄ββββββββββ
D SELECT * FROM extract_query_parameters('https://example.com/search?q=duckdb&hl=en&num=10');
βββββββββββ¬ββββββββββ
β key β value β
β varchar β varchar β
βββββββββββΌββββββββββ€
β q β duckdb β
β hl β en β
β num β 10 β
βββββββββββ΄ββββββββββ
D SELECT m.media_url,
e.key,
e.value
FROM instagram_posts m,
LATERAL extract_query_parameters(m.media_url) e
ORDER BY m.id;
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ¬βββββββββββββ¬ββββββββββββ
β media_url β key β value β
β varchar β varchar β varchar β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββΌβββββββββββββΌββββββββββββ€
β https://cdn.instagram.com/media/abc123.jpg?utm_source=instagram&utm_medium=social&id=1001 β id β 1001 β
β https://cdn.instagram.com/media/abc123.jpg?utm_source=instagram&utm_medium=social&id=1001 β utm_medium β social β
β https://cdn.instagram.com/media/abc123.jpg?utm_source=instagram&utm_medium=social&id=1001 β utm_source β instagram β
β https://cdn.instagram.com/media/def456.jpg?quality=hd&format=webp&user=arash β user β arash β
β https://cdn.instagram.com/media/def456.jpg?quality=hd&format=webp&user=arash β format β webp β
β https://cdn.instagram.com/media/def456.jpg?quality=hd&format=webp&user=arash β quality β hd β
β https://cdn.instagram.com/media/ghi789.mp4?autoplay=true&loop=false&session_id=xyz987 β session_id β xyz987 β
β https://cdn.instagram.com/media/ghi789.mp4?autoplay=true&loop=false&session_id=xyz987 β loop β false β
β https://cdn.instagram.com/media/ghi789.mp4?autoplay=true&loop=false&session_id=xyz987 β autoplay β true β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ΄βββββββββββββ΄ββββββββββββ
Extracting The Port
This function extracts the port from a URL.
D SELECT extract_port('https://example.com:8443/') AS port;
βββββββββββ
β port β
β varchar β
βββββββββββ€
β 8443 β
βββββββββββ
D SELECT extract_port('[::1]:6379') AS port;
βββββββββββ
β port β
β varchar β
βββββββββββ€
β 6379 β
βββββββββββ
Extracting The File Extension
This function extracts the file extension from a URL. It will return the file extension without the dot.
D SELECT extract_extension('http://example.com/image.jpg') AS ext;
βββββββββββ
β ext β
β varchar β
βββββββββββ€
β jpg β
βββββββββββ
Extracting The TLD (Top-Level Domain)
This function extracts the top-level domain from a URL using the optimized gperf-based public suffix lookup system. The function correctly handles multi-part TLDs (like com.au) using the longest-match algorithm from Mozilla's Public Suffix List.
D SELECT extract_tld('https://example.com.ac/path/path') AS tld;
βββββββββββ
β tld β
β varchar β
βββββββββββ€
β com.ac β
βββββββββββ
D SELECT extract_tld('a.example.com') AS tld;
βββββββββββ
β tld β
β varchar β
βββββββββββ€
β com β
βββββββββββ
Extracting The Sub Domain
This function extracts the sub-domain from a URL using the optimized public suffix lookup system to correctly identify the domain boundary and extract everything before it.
D SELECT extract_subdomain('http://a.b.example.com/path') AS dns_record;
ββββββββββββββ
β dns_record β
β varchar β
ββββββββββββββ€
β a.b β
ββββββββββββββ
D SELECT extract_subdomain('test.example.com.ac') AS dns_record;
ββββββββββββββ
β dns_record β
β varchar β
ββββββββββββββ€
β test β
ββββββββββββββ
Extracting The Fragment
The extract_fragment function extracts the fragment (the part after #) from a URL. Fragments are commonly used for page anchors, SPA routing, and deep linking.
D SELECT extract_fragment('http://example.com/page#section') AS fragment;
ββββββββββββ
β fragment β
β varchar β
ββββββββββββ€
β section β
ββββββββββββ
D SELECT extract_fragment('http://example.com/path?q=1#results') AS fragment;
ββββββββββββ
β fragment β
β varchar β
ββββββββββββ€
β results β
ββββββββββββ
D SELECT extract_fragment('http://example.com/#/users/123/profile') AS fragment;
ββββββββββββββββββββββ
β fragment β
β varchar β
ββββββββββββββββββββββ€
β /users/123/profile β
ββββββββββββββββββββββ
Returns an empty string when no fragment is present, and NULL for NULL input.
Get Tranco Rank
Update Tranco List
This function returns the Tranco rank of a domain. You have an update_tranco function to update the Tranco list manually.
D SELECT update_tranco(true);
βββββββββββββββββββββββββββββββββββββββ
β update_tranco(CAST('f' AS BOOLEAN)) β
β varchar β
βββββββββββββββββββββββββββββββββββββββ€
β Tranco list updated β
βββββββββββββββββββββββββββββββββββββββ
This function will get the latest Tranco list and save it into the tranco_list table. There will be a tranco_list_%Y-%m-%d.csv file in the current directory after the function is called. The extension will use this file to prevent downloading the list again.
You can ignore the file and force the extension to download the list again by calling the function with true as a parameter. If you don't want to download the list again, you can call the function with false as a parameter.
D SELECT update_tranco(false);
As the latest Tranco list is for the last day, you can download your list manually and rename it to tranco_list_%Y-%m-%d.csv to use it with the extension too.
Get Tranco Ranking
You can use this function to get the ranking of a domain:
D SELECT get_tranco_rank('microsoft.com') AS rank;
βββββββββββ
β rank β
β varchar β
βββββββββββ€
β 2 β
βββββββββββ
D SELECT get_tranco_rank('cloudflare.com') AS rank;
βββββββββββ
β rank β
β varchar β
βββββββββββ€
β 13 β
βββββββββββ
You can use the get_tranco_rank_category function to retrieve the category utility column that gives you the domain's rank category. The category value is on a log10 scale with half steps (e.g., top 1k, top 5k, top 10k, top 50k, top 100k, top 500k, top 1M, top 5m, etc.), with each rank excluding the previous (e.g., top 5k is actually 4k domains, excluding top 1k).
D SELECT get_tranco_rank_category('microsoft.com') AS category;
ββββββββββββ
β category β
β varchar β
ββββββββββββ€
β top1k β
ββββββββββββ
IP Address Functions
This extension provides various functions for manipulating and analyzing IP addresses, including calculating networks, hosts, and subnet masks.
IP Calculator
Warning
It's an experimental function.
The ipcalc function takes an IP address and netmask and calculates the resulting broadcast, network, wildcard mask, and host range.

SELECT * FROM ipcalc('192.168.1.0/24');
It's a table function that provides various details about IP addresses, including:
- Address
- Netmask
- Wildcard
- Network / Hostroute
- HostMin
- HostMax
- Broadcast
- Hosts count
You can use this table function with your data easily:
D CREATE OR REPLACE TABLE ips AS SELECT '127.0.0.1' AS ip UNION ALL SELECT '192.168.1.0/22';
D SELECT i.IP,
(
SELECT hostsPerNet
FROM ipcalc(i.IP)
) AS hosts
FROM ips AS i;
ββββββββββββββββββ¬ββββββββ
β ip β hosts β
β varchar β int64 β
ββββββββββββββββββΌββββββββ€
β 127.0.0.1 β 254 β
β 192.168.1.0/22 β 1022 β
ββββββββββββββββββ΄ββββββββ
Validate IP Address
The is_valid_ip function checks whether a string is a valid IPv4 or IPv6 address. Returns a BOOLEAN.
D SELECT is_valid_ip('192.168.1.1');
ββββββββββββββββββββββββββββββ
β is_valid_ip('192.168.1.1') β
β boolean β
ββββββββββββββββββββββββββββββ€
β true β
ββββββββββββββββββββββββββββββ
D SELECT is_valid_ip('2001:db8::1');
ββββββββββββββββββββββββββββββ
β is_valid_ip('2001:db8::1') β
β boolean β
ββββββββββββββββββββββββββββββ€
β true β
ββββββββββββββββββββββββββββββ
D SELECT is_valid_ip('not-an-ip');
ββββββββββββββββββββββββββββ
β is_valid_ip('not-an-ip') β
β boolean β
ββββββββββββββββββββββββββββ€
β false β
ββββββββββββββββββββββββββββ
Check Private IP
The is_private_ip function checks whether an IP address belongs to a private or reserved range. Supports both IPv4 and IPv6. Returns NULL for invalid addresses.
IPv4 ranges covered:
- RFC 1918 (10/8, 172.16/12, 192.168/16)
- loopback (127/8)
- link-local (169.254/16)
- carrier-grade NAT (100.64/10)
- documentation (TEST-NET)
- benchmarking (198.18/15)
- multicast (224/4)
- reserved (240/4)
IPv6 ranges covered:
- loopback (::1)
- unspecified (::)
- link-local (fe80::/10)
- ULA (fc00::/7)
- multicast (ff00::/8)
- documentation (2001:db8::/32)
- discard (100::/64)
D SELECT is_private_ip('192.168.1.1');
ββββββββββββββββββββββββββββββββ
β is_private_ip('192.168.1.1') β
β boolean β
ββββββββββββββββββββββββββββββββ€
β true β
ββββββββββββββββββββββββββββββββ
D SELECT is_private_ip('8.8.8.8');
ββββββββββββββββββββββββββββ
β is_private_ip('8.8.8.8') β
β boolean β
ββββββββββββββββββββββββββββ€
β false β
ββββββββββββββββββββββββββββ
D SELECT is_private_ip('fe80::c028:8eff:fe34:6e5f');
ββββββββββββββββββββββββββββββββββββββββββββββ
β is_private_ip('fe80::c028:8eff:fe34:6e5f') β
β boolean β
ββββββββββββββββββββββββββββββββββββββββββββββ€
β true β
ββββββββββββββββββββββββββββββββββββββββββββββ
IP Version
The ip_version function returns 4 for IPv4, 6 for IPv6, or NULL for invalid addresses.
D SELECT ip_version('192.168.1.1');
βββββββββββββββββββββββββββββ
β ip_version('192.168.1.1') β
β int8 β
βββββββββββββββββββββββββββββ€
β 4 β
βββββββββββββββββββββββββββββ
D SELECT ip_version('::1');
βββββββββββββββββββββ
β ip_version('::1') β
β int8 β
βββββββββββββββββββββ€
β 6 β
βββββββββββββββββββββ
IP to Integer / Integer to IP
The ip_to_int function converts an IPv4 address to its 32-bit unsigned integer representation. The int_to_ip function converts back. Returns NULL for invalid or IPv6 input (IPv6 requires 128-bit support).
D SELECT ip_to_int('192.168.1.1');
ββββββββββββββββββββββββββββ
β ip_to_int('192.168.1.1') β
β uint64 β
ββββββββββββββββββββββββββββ€
β 3232235777 β
β (3.23 billion) β
ββββββββββββββββββββββββββββ
D SELECT int_to_ip(3232235777::UBIGINT);
ββββββββββββββββββββββββββββββββββββββββββ
β int_to_ip(CAST(3232235777 AS UBIGINT)) β
β varchar β
ββββββββββββββββββββββββββββββββββββββββββ€
β 192.168.1.1 β
ββββββββββββββββββββββββββββββββββββββββββ
D SELECT int_to_ip('3232235777');
βββββββββββββββββββββββββββ
β int_to_ip('3232235777') β
β varchar β
βββββββββββββββββββββββββββ€
β 192.168.1.1 β
βββββββββββββββββββββββββββ
These functions are useful for sorting IPs numerically or performing range comparisons.
Sort IPs numerically instead of lexicographically:
D SELECT ip FROM my_ips ORDER BY ip_to_int(ip);
βββββββββββββββ
β ip β
β varchar β
βββββββββββββββ€
β 8.8.8.8 β
β 10.0.0.1 β
β 192.168.1.1 β
βββββββββββββββ
Range queries using integer comparison:
D SELECT ip
FROM my_ips
WHERE ip_to_int(ip) BETWEEN ip_to_int('10.0.0.0') AND ip_to_int('10.255.255.255');
ββββββββββββ
β ip β
β varchar β
ββββββββββββ€
β 10.0.0.1 β
ββββββββββββ
Normalize URL
The normalize_url function canonicalizes a URL by applying RFC 3986 normalizations: scheme/host lowercasing, default port removal (80/443/21), trailing slash removal, dot segment resolution, query parameter sorting, fragment removal, and percent-encoding normalization.
D SELECT normalize_url('HTTP://WWW.EXAMPLE.COM:80/a/b/../c/?z=1&a=2#frag') AS url;
ββββββββββββββββββββββββββββββββββββββ
β url β
β varchar β
ββββββββββββββββββββββββββββββββββββββ€
β http://www.example.com/a/c?a=2&z=1 β
ββββββββββββββββββββββββββββββββββββββ
D SELECT normalize_url('HTTPS://Example.Com:443/path/./to/../page?b=2&a=1#section') AS url;
βββββββββββββββββββββββββββββββββββββββββ
β url β
β varchar β
βββββββββββββββββββββββββββββββββββββββββ€
β https://example.com/path/page?a=1&b=2 β
βββββββββββββββββββββββββββββββββββββββββ
D SELECT normalize_url('http://example.com/%7Euser') AS url;
ββββββββββββββββββββββββββββ
β url β
β varchar β
ββββββββββββββββββββββββββββ€
β http://example.com/~user β
ββββββββββββββββββββββββββββ
This is especially useful for deduplicating URLs that differ only in formatting:
D SELECT normalize_url(url) AS normalized,
count(*) AS cnt
FROM urls
GROUP BY normalized
HAVING cnt > 1;
Domain Depth
The domain_depth function returns the number of dot-separated levels in a domain. It extracts the host from a URL and counts the labels. Returns 0 for IP addresses and invalid input, NULL for NULL.
D SELECT domain_depth('example.com') AS depth;
βββββββββ
β depth β
β int32 β
βββββββββ€
β 2 β
βββββββββ
D SELECT domain_depth('https://www.example.com/page') AS depth;
βββββββββ
β depth β
β int32 β
βββββββββ€
β 3 β
βββββββββ
D SELECT domain_depth('http://a.b.c.example.co.uk/page') AS depth;
βββββββββ
β depth β
β int32 β
βββββββββ€
β 6 β
βββββββββ
Base64 Encode / Decode
The base64_encode function encodes a string into Base64 format. The base64_decode function decodes a Base64-encoded string back to its original form.
D SELECT base64_encode('Hello World') AS encoded;
ββββββββββββββββββββ
β encoded β
β varchar β
ββββββββββββββββββββ€
β SGVsbG8gV29ybGQ= β
ββββββββββββββββββββ
D SELECT base64_decode('SGVsbG8gV29ybGQ=') AS decoded;
βββββββββββββββ
β decoded β
β varchar β
βββββββββββββββ€
β Hello World β
βββββββββββββββ
D SELECT base64_decode(base64_encode('https://example.com')) AS roundtrip;
βββββββββββββββββββββββ
β roundtrip β
β varchar β
βββββββββββββββββββββββ€
β https://example.com β
βββββββββββββββββββββββ
Validate URL
The is_valid_url function checks whether a string is a well-formed URL. A valid URL must have a scheme (e.g., http, https, ftp), the :// separator, and a non-empty host. Returns a BOOLEAN, NULL for NULL input.
D SELECT is_valid_url('https://example.com') AS valid;
βββββββββββ
β valid β
β boolean β
βββββββββββ€
β true β
βββββββββββ
D SELECT is_valid_url('example.com') AS valid;
βββββββββββ
β valid β
β boolean β
βββββββββββ€
β false β
βββββββββββ
D SELECT is_valid_url('https://[::1]:8080/path') AS valid;
βββββββββββ
β valid β
β boolean β
βββββββββββ€
β true β
βββββββββββ
Validate Domain
The is_valid_domain function validates a domain name against RFC 1035 / RFC 1123 rules. Requires at least two labels, alphanumeric and hyphens only (no start/end with hyphen), max 63 chars per label, max 253 chars total, and a non-numeric TLD. Returns a BOOLEAN, NULL for NULL input.
D SELECT is_valid_domain('example.com') AS valid;
βββββββββββ
β valid β
β boolean β
βββββββββββ€
β true β
βββββββββββ
D SELECT is_valid_domain('sub.example.co.uk') AS valid;
βββββββββββ
β valid β
β boolean β
βββββββββββ€
β true β
βββββββββββ
D SELECT is_valid_domain('localhost') AS valid;
βββββββββββ
β valid β
β boolean β
βββββββββββ€
β false β
βββββββββββ
Extract Path Segments
The extract_path_segments table function splits a URL path into individual segment rows. Each row contains a 1-based segment_index and the segment string. Returns 0 rows for NULL, empty, or root-only paths.
D SELECT * FROM extract_path_segments('https://example.com/path/to/page?q=1');
βββββββββββββββββ¬ββββββββββ
β segment_index β segment β
β int32 β varchar β
βββββββββββββββββΌββββββββββ€
β 1 β path β
β 2 β to β
β 3 β page β
βββββββββββββββββ΄ββββββββββ
Use with LATERAL to expand segments per row in a table:
D SELECT u.url,
s.segment_index,
s.segment
FROM urls u,
LATERAL extract_path_segments(u.url) s
ORDER BY u.url,
s.segment_index;
βββββββββββββββββββββββββββββ¬ββββββββββββββββ¬ββββββββββ
β url β segment_index β segment β
β varchar β int32 β varchar β
βββββββββββββββββββββββββββββΌββββββββββββββββΌββββββββββ€
β https://example.com/a/b/c β 1 β a β
β https://example.com/a/b/c β 2 β b β
β https://example.com/a/b/c β 3 β c β
β https://test.org/x/y β 1 β x β
β https://test.org/x/y β 2 β y β
βββββββββββββββββββββββββββββ΄ββββββββββββββββ΄ββββββββββ
URL Encode / Decode
The url_encode function percent-encodes a string per RFC 3986. Only unreserved characters (A-Z, a-z, 0-9, -, _, ., ~) are left as-is β everything else is encoded as %XX with uppercase hex digits.
The url_decode function decodes percent-encoded strings back to their original form. It also decodes + as a space (for application/x-www-form-urlencoded compatibility). Invalid percent sequences are passed through literally.
D SELECT url_encode('hello world') AS encoded;
βββββββββββββββββ
β encoded β
β varchar β
βββββββββββββββββ€
β hello%20world β
βββββββββββββββββ
D SELECT url_decode('hello%20world') AS decoded;
βββββββββββββββ
β decoded β
β varchar β
βββββββββββββββ€
β hello world β
βββββββββββββββ
D SELECT url_encode('https://www.google.com/search?client=firefox-b-d&q=url+encode') AS encoded;
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β encoded β
β varchar β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β https%3A%2F%2Fwww.google.com%2Fsearch%3Fclient%3Dfirefox-b-d%26q%3Durl%2Bencode β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
D SELECT url_decode(url_encode('cafΓ© π¦')) AS roundtrip;
βββββββββββββ
β roundtrip β
β varchar β
βββββββββββββ€
β cafΓ© π¦ β
βββββββββββββ
url_decode also decodes + as space:
D SELECT url_decode('hello+world') AS decoded;
βββββββββββββββ
β decoded β
β varchar β
βββββββββββββββ€
β hello world β
βββββββββββββββ
Get Extension Version
You can use the netquack_version function to get the extension version.
D SELECT * FROM netquack_version();
βββββββββββ
β version β
β varchar β
βββββββββββ€
β v1.13.0 β
βββββββββββ
Build Requirements
- C++ compiler: Needs C++17 or later (e.g.,
g++,clang++). - gperf: Perfect hash generation requires
gperf. - CMake
- GNU Make
# On Debian-based systems
sudo apt-get install gperf cmake make
# On MacOS using Homebrew
brew install gperf cmake make
Debugging
The debugging process for DuckDB extensions is not an easy job. For Netquack, we have created a log file in the current directory. The log file is named netquack.log and contains all the logs for the extension. You can use this file to debug your code.
Also, there will be stdout errors for background tasks like CURL.
Roadmap πΊοΈ
- Implement
extract_custom_formatfunction - Implement
parse_urifunction - Return a STRUCT with all components (scheme, host, port, path, query, fragment) in a single call - Save Tranco data as Parquet
- Implement GeoIP functionality
- Return default value for
get_tranco_rank - Implement
ip_in_rangefunction - Check if an IP falls within a given CIDR block - Support internationalized domain names (IDNs)
- Implement
punycode_encode/punycode_decodefunctions - Convert internationalized domain names to/from ASCII-compatible encoding
Contributing π€
Don't be shy and reach out to us if you want to contribute π
- Fork it!
- Create your feature branch:
git checkout -b my-new-feature - Commit your changes:
git commit -am 'Add some feature' - Push to the branch:
git push origin my-new-feature - Submit a pull request
Issues π
Each project may have many problems. Contributing to the better development of this project by reporting them. π