Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I hadn't heard of sqinn before. According to these benchmarks it beats Cgo-based solutions most of the time, which makes it a very interesting candidate. Anyone have real-world experience using it?


(Sqinn is made by the same guy that made these benchmarks in case you didn't realize)


I did not notice that, thanks for pointing it out.


Yes, in fact the benchmark started out as a comparison between sqinn and mattn. (There was no modernc at that time.)


Sqinn author here. Yes, sqinn performs quite well compared to the 'standard' mattn driver. The only use case it clearly breaks down is when SELECTing very large (gigabytes) resultsets.


That stood out to me as well. Any insights why sqinn and zombie underperform in this case, and is the problem inherent to their design?


For sqinn it's because of its design: Shuffling that much data over process boundaries takes time. For zombie, more pprof would be needed to explain the behaviour.


I would suspect some unnecessary copying. Nothing else explains a “lower level” binding (zombie) performing worse than modernc.

My (WASM) binding also has a lower level API. But I worked hard to make database/sql work first class, so I wouldn't expect much improvement.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: