New Episodes Dropping

Podcast

Deep-dives into building DuckDB extensions, the Cursor-on-Target protocol, ATAK deployments, real-time geospatial pipelines, and TAK ecosystem security. Hosted by the tak-cot-sender project team.

Episode 01
πŸ”§
EP 01 48 min DuckDB Extensions

Building tak-cot-sender: A DuckDB Extension from Scratch

The origin story behind tak-cot-sender. We cover the DuckDB extension C++ API, how to register scalar functions and table functions, the CMake build system for community extensions, and the design decisions that shaped the current architecture.

DuckDB Extension API C++17 CMake Design Decisions
Episode 02
πŸ“‘
EP 02 61 min CoT Protocol

Cursor-on-Target: Protocol Deep-Dive

Everything you wanted to know about CoT but were afraid to ask. We dissect the XML schema, walk through every field of the <event> element, explain MIL-STD-2525B type strings, and show how TAK Clients interpret incoming CoT messages on the map.

CoT Schema MIL-STD-2525B XML Framing TAK Client Rendering
Episode 03
πŸ—ΊοΈ
EP 03 54 min ATAK Deployments

Real-World ATAK: From Training Ranges to Disaster Response

Practitioners share how ATAK and TAK Server have been deployed in real scenarios: military training exercises, wildfire incident command, search-and-rescue coordination, and border security operations. What works, what breaks, and how tak-cot-sender fits in.

ATAK TAK Server Incident Command Emergency Management
Episode 04
πŸ“
EP 04 67 min GIS & Geospatial

GIS for Tactical Operations: Bringing Spatial Data into TAK

How to combine DuckDB's spatial extension with tak-cot-sender to stream GeoJSON, shapefiles, GPX tracks, and PostGIS query results directly to ATAK as live CoT markers. We cover coordinate reference systems, geometry simplification, and bounding box queries for area-of-interest filtering.

DuckDB Spatial GeoJSON PostGIS CRS Transformations
Episode 05
⚑
EP 05 58 min Real-Time Pipelines

Real-Time Sensor Pipelines: From IoT to TAK in SQL

Connecting live sensor feeds β€” GPS trackers, drone telemetry, AIS vessel transponders, vehicle CANbus data, weather stations β€” to TAK via DuckDB SQL pipelines. We walk through polling loops, the cronjob extension, error handling strategies, and how to tune your stale timeout to match sensor update rates.

IoT Integration GPS Telemetry Polling Loops AIS Drone Feeds
Episode 06
πŸ”
EP 06 72 min Security

Securing TAK: mTLS, Certificate Management, and Zero-Trust Networks

A technical deep-dive into TAK network security. How TAK Server CA works, issuing and rotating client certificates, mTLS handshake mechanics, common misconfiguration pitfalls, and how tak-cot-sender's tak_configure_tls() integrates with your PKI. Includes a live demo of certificate rotation without dropping the connection.

mTLS PKI Zero Trust Certificate Rotation OpenSSL
Listen on: πŸŽ™ Apple Podcasts 🎧 Spotify πŸ“» Google Podcasts πŸ”— RSS Feed β–Ά YouTube