This experimental rust extension allows reading PCAP files from DuckDB using the pcap-parser crate
Experimental: USE AT YOUR OWN RISK!
INSTALL pcap_reader FROM community;
LOAD pcap_reader;D SELECT * FROM pcap_reader('test/test.pcap') LIMIT 3; βββββββββββββββββββββββ¬βββββββββββββββββ¬βββββββββββββββββ¬βββββββββββ¬βββββββββββ¬βββββββββββ¬βββββββββ¬ββββββββββββββββββββββββββββββββββββββββββββ β timestamp β src_ip β dst_ip β src_port β dst_port β protocol β length β payload β β timestamp β varchar β varchar β int32 β int32 β varchar β int32 β varchar β βββββββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌβββββββββββΌβββββββββββΌβββββββββββΌβββββββββΌββββββββββββββββββββββββββββββββββββββββββββ€ β 2024-12-06 19:30:2... β xx.xx.xx.xxx β yyy.yyy.yy.yyy β 64078 β 5080 β UDP β 756 β INVITE sip:810442837619024@yyy.yyy.yy.y... β β 2024-12-06 19:30:2... β yyy.yyy.yy.yyy β xx.xx.xx.xxx β 5080 β 64078 β UDP β 360 β SIP/2.0 100 Trying\r\nVia: SIP/2.0/UDP ... β β 2024-12-06 19:30:2... β yyy.yyy.yy.yyy β xx.xx.xx.xxx β 5080 β 64078 β UDP β 909 β SIP/2.0 480 Temporarily Unavailable\r\n... β βββββββββββββββββββββββ΄βββββββββββββββββ΄βββββββββββββββββ΄βββββββββββ΄βββββββββββ΄βββββββββββ΄βββββββββ΄ββββββββββββββββββββββββββββββββββββββββββββ€ β 3 rows 8 columns β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ