Starstruk Logo MarkStarstruk

11.0.316

gophish/gophish11.0.316Aug 13, 2026by adubovikov

AI Summary

Fixes timestamp encoding in FlightSQL to prevent integer overflow when converting data for Grafana.

Key Highlights

  • Encode DuckDB `TIMESTAMP` as Arrow `timestamp[us]` instead of nanoseconds to fix overflow.
  • Fixes Grafana/Influx conversion issues that displayed capture times as 1882.
  • Enables `time_bucket` function to work without complex conversion steps.

New Features

  • Fixed timestamp encoding for FlightSQL/Grafana compatibility.

Full Release Notes

## What's Changed
* fix(flightsql): encode timestamps in Arrow field units by @adubovikov in https://github.com/sipcapture/homer/pull/932

### FlightSQL / Grafana
- Write DuckDB `TIMESTAMP` values as Arrow `timestamp[us]` (not nanoseconds). Grafana/Influx converting us→ns with `value*1000` overflowed int64 and showed capture times as **1882**.
- `time_bucket(..., timestamp)` works without `to_timestamp(epoch(timestamp))`. Stored DuckLake data is unchanged.

**Full Changelog**: https://github.com/sipcapture/homer/compare/11.0.315...11.0.316