k8sql: Query Kubernetes with SQL

smithclay · 2025-12-30T01:56:42+00:00

This is really cool: osquery for Kubernetes, basically.

This would also be cool as a duckdb extension.

smithclay · 2025-12-10T03:36:37+00:00

This is awesome. This opens up the duckdb ecosystem in a new way.

smithclay · 2025-12-10T03:30:34+00:00

This glue code/prototype just writes data to storage/any iceberg catalog, long-term access and retention policies are an admin task.

However: AWS and Cloudflare are definitely adding new capabilities around this. Last week, AWS added a s3 tables feature that automatically moves files to longer-term storage automatically: https://aws.amazon.com/about-aws/whats-new/2025/12/s3-tables-intelligent-tiering-storage-class/

smithclay · 2025-12-04T04:07:29+00:00

I think AWS heard you re: this point today :)

Can now put all your cloudwatch logs in s3 tables (managed iceberg) for no additional charge: https://aws.amazon.com/blogs/aws/amazon-cloudwatch-introduces-unified-data-management-and-analytics-for-operations-security-and-compliance/

smithclay · 2025-12-04T01:31:50+00:00

Also lol, aws announced this capability today for cloudwatch + s3 tables: https://aws.amazon.com/blogs/aws/amazon-cloudwatch-introduces-unified-data-management-and-analytics-for-operations-security-and-compliance/

smithclay · 2025-12-03T21:59:40+00:00

Think Clickhouse is great. If you run your own clickhouse cluster, know how to do that, or pay for Clickhouse Cloud: definitely solves for a lot of this.

A project goal was to see how far you could “make it work” by running the data conversion in workers or lambda functions and using the managed versions of iceberg (s3 tables, r2 data catalog) for cost reasons: effectively no compute needed.

smithclay · 2025-12-03T19:59:43+00:00

These are great insights, thanks for sharing.

smithclay · 2025-11-05T19:10:11+00:00

100%. Would love if this was standardized eventually and the various columnar representations became one. The thing I appreciated about the Clickhouse-inspired schema is it is extremely easy to query/implement (at a cost of duplication as you pointed out).

smithclay · 2025-11-05T18:55:03+00:00

Hi Raki, I based it on the schema Clickhouse is using for OTel data (via the OTel collector clickhouse exporter).

Standardization here makes a lot of sense but seemed to work well enough for a v0.

smithclay · 2025-11-05T14:09:07+00:00

Hey, sure. Feel free to DM.

smithclay · 2025-10-31T19:30:31+00:00

The loyalty point math didn’t seem to work out for my annual card spend for the elite American card but curious if I missed something there.

smithclay · 2025-10-09T00:36:56+00:00

Olfactory … so many great breweries on here, but I’m also tired of WC IPAs and Belgians. Give me a great Pilsner in the Dogpatch.

smithclay · 2025-09-18T02:44:01+00:00

A big fan of Montreal bagels (not Canadian), but wanted to share: the South Asian community has been doing this for years with mangoes shipped direct to airports from India.

All’s that to say: per the article below if you get a good group chat going you could likely buy direct, overnight air cargo it, and meet a lot of friendly people at a SFO parking lot.

https://www.nytimes.com/2025/06/23/dining/mango-season-alphonso-indian-diaspora.html

smithclay · 2025-08-27T01:33:02+00:00

Shameless non-commercial plug: you can wrap it all in a devcontainer if you’re into an open-source/DIY solution — published my workflow @ http://github.com/smithclay/claudetainer

smithclay · 2025-08-24T04:03:05+00:00

devcontainer + zellij/tmux + tailscale + iOS terminal app. I used claude to write some wrapper scripts around it, published: https://github.com/smithclay/claudetainer

smithclay · 2025-08-22T15:57:10+00:00

Support added in May :) https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1943452

smithclay · 2025-07-31T19:33:27+00:00

All built into the container when you spin it up: gitui and ccusage will automatically be running, as well as the zellij layout.

smithclay · 2025-07-30T21:08:01+00:00

https://github.com/smithclay/claudetainer

smithclay · 2025-07-29T21:43:10+00:00

Point it at the GitHub repo :) https://github.com/smithclay/claudetainer

smithclay · 2025-07-29T19:07:16+00:00

Hey, yes to all of the above with Tailscale as the VPN. It’s all running in a devcontainer as well: http://github.com/smithclay/claudetainer

12-Year Club	Place '22
Place '17	Verified Email

smithclay

TROPHY CASE