Hacker News: snissn

New comment by snissn in "DuckDB Internals: Why Is DuckDB Fast? (Part 1)"

snissn — Fri, 19 Jun 2026 05:56:05 +0000

I'm just curious - is duckdb too slow for people? This benchmark from clickhouse shows it being fairly slow compared to some options: https://jsonbench.com/

New comment by snissn in "OpenAI Adopts Google's SynthID Watermark for AI Images with Verification Tool"

snissn — Tue, 19 May 2026 20:20:30 +0000

I’m surprised! I guess I’m being naive but I would imagine you could pass an image to an image model without synthid and have it reconstruct the image in a net new way without the markers. I guess I’m wrong? That’s cool if the watermarks are so deeply ingrained that they persist

New comment by snissn in "NanoTDB – Golang Append-Only Time Series DB"

snissn — Fri, 15 May 2026 17:56:55 +0000

I've been thinking about this question for a while. It's confusing at first blush because it's an append-only database and it has a WAL — and it feels like a WAL is already an append-only database, so what's even happening?

Looking back at the project now, I think the value comes from querying it, and especially from automatic aggregations.

    [rollups]
    enabled = true
    checkpoint_file = "rollup.checkpoints.log"
    default_grace = "5m"

    [[rollups.jobs]]
    id = "outside_temp_1h"
    source_metric = "temp.out_dry"
    interval = "1h"
    aggregates = ["min", "max", "sum", "avg", "count"]
    destination_db = "sensors_rollup_1h"
    destination_metric_prefix = "temp.out_dry"

This is a reasonable use case that can't immediately be resolved by just logging to a file. It creates an aggregation profile, so a sensor could log temperature every minute and the database will automatically average temperature by the hour. That's a straightforward and meaningful use case.

There's also some query support, but that may be closer to something you can sort of do if you just have a log file.

I think the aggregations are the most direct value proposition. OP/author: worth making this pitch "above the fold" in the README, imho.

Also, I've done a lot of analytics work, and a fun feature to add that I've built in the past is an approximate median. I might open a PR and remind myself how to build that. Cheers!

New comment by snissn in "Fc, a lossless compressor for floating-point streams"

snissn — Wed, 13 May 2026 02:29:16 +0000

What do you mean by decode is parallel?

New comment by snissn in "An update on recent Claude Code quality reports"

snissn — Thu, 23 Apr 2026 18:40:43 +0000

it's been frustrating how bad it is at UI. I'm starting to test out using their image2 for UI and then handing it to codex to build out the images into code and I'm impressed and relieved so far

New comment by snissn in "Show HN: I Built Paul Graham's Intellectual Captcha Idea"

snissn — Mon, 06 Apr 2026 16:58:54 +0000

This is weird political propaganda. The first post misrepresented annual costs of housing.

New comment by snissn in "Study finds no evidence cannabis helps anxiety, depression, or PTSD"

snissn — Sun, 22 Mar 2026 03:35:03 +0000

Ok I see so they have six studies that they found to indicate effective treatment of anxiety with cannibanoids but their meta study only found six trials with 50 people so the significance / n count is not high enough. So the study is a null result ie they don’t have enough data not they’ve disproved it. In fact their data supports the hypothesis. Then the coverage on science daily misrepresented this. Here's citaiton 40: https://www.nature.com/articles/npp20116 "Cannabidiol Reduces the Anxiety Induced by Simulated Public Speaking in Treatment-Naïve Social Phobia Patients" Pretreatment with CBD significantly reduced anxiety, cognitive impairment and discomfort in their speech performance, and significantly decreased alert in their anticipatory speech. The placebo group presented higher anxiety, cognitive impairment, discomfort, and alert levels when compared with the control group as assessed with the VAMS.

New comment by snissn in "Study finds no evidence cannabis helps anxiety, depression, or PTSD"

snissn — Sun, 22 Mar 2026 03:25:02 +0000

I’m digging through the paper. It’s a meta analysis paper.. they have six studies they analyze on anxiety treatment and they (footnotes 40-46) have positive results in terms of cbd showing a significant effect on anxiety reduction. I’m not invested in figuring out exactly how this study came to represent what it claims but it seems like a joke

New comment by snissn in "Grafeo – A fast, lean, embeddable graph database built in Rust"

snissn — Sat, 21 Mar 2026 23:36:13 +0000

It's not clear that graph-bench in "Tested with the LDBC Social Network Benchmark via graph-bench" is a benchmark that you made. It seems more robust and reliable than "we built a db and a benchmark tool, and our benchmark tool says we're the best". Just a thing to be careful about. You should just state that it's your tool and you welcome feedback to help make it so that other projects being compared are compared in their best light. Something like that might help, I don't know though it's a hard problem.

New comment by snissn in "Claude Code daily benchmarks for degradation tracking"

snissn — Thu, 29 Jan 2026 20:35:27 +0000

they should run their test against a control baseline such as an open source hosted model to see the overall drift in their test

New comment by snissn in "My experience creating software with LLM coding agents – Part 2 (Tips)"

snissn — Sat, 23 Aug 2025 08:16:20 +0000

https://gist.github.com/snissn/4f06cae8fb4f4ac43ffdb104db192...

New comment by snissn in "O3 Turns Pro"

snissn — Tue, 17 Jun 2025 16:26:28 +0000

I’ve found throw the problem at 3 o3 pros and have another one evaluate and synthesize works really well

New comment by snissn in "Garfield Minus Garfield"

snissn — Thu, 10 Apr 2025 18:59:09 +0000

I'm impressed with how easy it is to recreate this effect using AI tools. I made this on my iPhone in the photos app by circling Garfield a few times: https://i.imgur.com/YVOZlj8.jpeg based on https://www.gocomics.com/garfield/2025/04/10

New comment by snissn in "Show HN: A Database Written in Golang"

snissn — Wed, 26 Feb 2025 18:09:23 +0000

to also share a reference - here's an on disk hashmap that uses mmap that I made in golang: https://github.com/snissn/gomap

New comment by snissn in "Effects of Gen AI on High Skilled Work: Experiments with Software Developers"

snissn — Sat, 07 Sep 2024 21:53:27 +0000

Human + ai writing tests >> human writing tests

New comment by snissn in "Zap Energy achieves 37M-degree temperatures in a compact fusion device"

snissn — Wed, 24 Apr 2024 21:20:38 +0000

37 million Kelvin

New comment by snissn in "The failure of the Domino's 30-minute delivery guarantee"

snissn — Mon, 22 Apr 2024 15:26:27 +0000

this is worth a read too https://en.wikipedia.org/wiki/The_Noid

New comment by snissn in "Faces.js, a JavaScript library for generating vector-based cartoon faces"

snissn — Sun, 07 Apr 2024 15:15:59 +0000

Here's a demo of my project shape faces https://shapefaces.com/

New comment by snissn in "Friends don't let friends export to CSV"

snissn — Tue, 26 Mar 2024 14:55:10 +0000

new line seperated json "JSONL"

New comment by snissn in "The AMD tinybox is on hold until we can build and run the firmware on our GPUs"

snissn — Wed, 20 Mar 2024 19:08:38 +0000

gooey?