frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Hamming Distance for Hybrid Search in SQLite

https://notnotp.com/notes/hamming-distance-for-hybrid-search-in-sqlite/
38•enz•2d ago

Comments

jonatron•1h ago
You could first calculate the distance of the first n bits (eg: 64, one popcountll) as a first pass, then calculate the full distance for candidates over a threshold from the first pass. It makes it approximate, but depending on the application it can be worth it.
mbreese•30m ago
I was thinking of something similar — instead of just two passes, couldn’t you also store different quantized values? If you have thousands of documents, you could narrow it down to a handful with a few bit-wise Hamming comparisons before doing a full cosine similarity on just the rest. If you hand more than one bitmap stored, you’d have fewer comparisons at each step too.

Would this work?

stephenheron•42m ago
I've had good success in using this: https://github.com/sqliteai/sqlite-vector if you want something a bit more "off the shelf" if you are using SQLite.
0cf8612b2e1e•15m ago
Ooh that does look nice. However, that license is a deal breaker for me.
marcobambini•4m ago
Author here... it is free for open-source projects.

What kind of license would you like more?

stevesimmons•17m ago
USearch has a sqlite extension that supports various metrics on including Hamming distance on standard sqlite BLOB columns. It gets similar performance and is very convenient.

(There's also an indexed variant that does faster lookups, but it uses a special virtual table layout that constrains the types of the other columns in the table.)

See https://github.com/unum-cloud/USearch. pip-installable for Python users.

GrapheneOS – Break Free from Google and Apple

https://blog.tomaszdunia.pl/grapheneos-eng/
703•to3k•6h ago•440 comments

I converted 2D conventional flight tracking into 3D

https://aeris.edbn.me/?city=SFO
65•kewonit•2h ago•22 comments

America's Pensions Can't Beat Vanguard but They Can Close Your Hospital

https://www.governance.fyi/p/americas-pensions-cant-beat-a-vanguard
127•bigbobbeeper•1h ago•129 comments

Four Column ASCII (2017)

https://garbagecollected.org/2017/01/31/four-column-ascii/
282•tempodox•2d ago•63 comments

14-year-old Miles Wu folded origami pattern that holds 10k times its own weight

https://www.smithsonianmag.com/innovation/this-14-year-old-is-using-origami-to-design-emergency-s...
846•bookofjoe•22h ago•179 comments

Show HN: Price Per Ball – Site that sorts golf balls on Amazon by price per ball

https://priceperball.net/
7•rockdiesel•1h ago•6 comments

Hamming Distance for Hybrid Search in SQLite

https://notnotp.com/notes/hamming-distance-for-hybrid-search-in-sqlite/
38•enz•2d ago•6 comments

Show HN: Cycast – High-performance radio streaming server written in Python

https://github.com/LukeB42/Cycast
3•LukeB42•55m ago•0 comments

Why AI writing is so generic, boring, and dangerous: Semantic ablation

https://www.theregister.com/2026/02/16/semantic_ablation_ai_writing/
26•benji8000•30m ago•2 comments

Show HN: Glitchy camera – a circuit-bent camera simulator in the browser

https://glitchycam.com
138•elayabharath•1d ago•18 comments

Rise of the Triforce

https://dolphin-emu.org/blog/2026/02/16/rise-of-the-triforce/
372•max-m•19h ago•56 comments

Rendering the Visible Spectrum

https://brandonli.net/spectra/doc/
127•signa11•3d ago•21 comments

Xbox UI Portfolio Site

https://gabrielcabrera.co/
115•valgaze•10h ago•33 comments

A Programmer's Loss of Identity

https://ratfactor.com/tech-nope2
163•zdw•3d ago•100 comments

This is What It's Like to Spend Your Life in Prison (2023) [video]

https://www.youtube.com/watch?v=chpgT_VTEjE
15•NaOH•2d ago•7 comments

Visual introduction to PyTorch

https://0byte.io/articles/pytorch_introduction.html
359•0bytematt•4d ago•25 comments

What your Bluetooth devices reveal

https://blog.dmcc.io/journal/2026-bluetooth-privacy-bluehood/
496•ssgodderidge•1d ago•180 comments

Poor Deming never stood a chance

https://surfingcomplexity.blog/2026/02/16/poor-deming-never-stood-a-chance/
169•todsacerdoti•14h ago•103 comments

Undo in Vi and Its Successors

https://utcc.utoronto.ca/~cks/space/blog/unix/ViUndoMyViews
35•todsacerdoti•2h ago•32 comments

How teaching molecules to think is revealing what a 'mind' is

https://www.newscientist.com/article/2513815-how-teaching-molecules-to-think-is-revealing-what-a-...
58•pella•4d ago•40 comments

Show HN: Free alternative to Wispr Flow, Superwhisper, and Monologue

https://github.com/zachlatta/freeflow
245•zachlatta•19h ago•110 comments

A deep dive into Apple's .car file format

https://dbg.re/posts/car-file-format/
140•MrFinch•3d ago•53 comments

"Token anxiety", a slot machine by any other name

https://jkap.io/token-anxiety-or-a-slot-machine-by-any-other-name/
215•presbyterian•22h ago•200 comments

Ghidra by NSA

https://github.com/NationalSecurityAgency/ghidra
417•handfuloflight•3d ago•207 comments

DBASE on the Kaypro II

https://stonetools.ghost.io/dbase-cpm/
75•TMWNN•3d ago•37 comments

Neurons outside the brain

https://essays.debugyourpain.com/p/you-are-not-just-your-brain
140•yichab0d•21h ago•71 comments

Show HN: Scanned 1927-1945 Daily USFS Work Diary

https://forestrydiary.com/
111•dogline•17h ago•23 comments

Running NanoClaw in a Docker Shell Sandbox

https://www.docker.com/blog/run-nanoclaw-in-docker-shell-sandboxes/
152•four_fifths•17h ago•73 comments

Turing Labs (YC W20) Is Hiring – Founding GTM Sales Hacker

1•turinglabs•19h ago

State of Show HN: 2025

https://blog.sturdystatistics.com/posts/show_hn/
126•kianN•20h ago•31 comments