Notes from the build
Design ideas, results and open questions from building MorletDB in public. Plans here are proposals until an issue, a test and a result say otherwise.
What audio codecs taught a sensor databaseGrizzbit 2.1 borrows two ideas from lossless audio coding and one from how sensors round numbers. A frozen study found machine waveforms 12.6% smaller in total, bit for bit lossless, with the same bytes on every platform. What inspired it, where it stands, and what comes next.
One file, every bitA MorletDB recording can now be one SQLite file with the same chunk bytes as the server, moved between file and server without losing a bit, and readable without MorletDB: a documented format, a compatibility promise, and a 254-line reference reader on Python's standard library.
A fast model decides, Claude explainsA System 1 model (TypeSafe's Jev) decided from MorletDB's decision state alone: AUROC 0.948 for worn milling inserts, 0.977 with four labelled examples, and a local model without cloud decided as well on unseen inserts. Claude then explained one decision from the same recordings.
Report 1 · Searching waveforms by shape inside PostgreSQLOrdinary vector search misses shifted matches; 13 shifted probes into one standard PostgreSQL index found 97.7% of the exact top ten on seismic data, every hit traceable to stored samples.
Report 2 · An archive that forgets on purposeA draft report on machine archives as episodic memory with graded, recorded forgetting; a first study shows exempting known events keeps them all findable, but retention by age stays the default.
Report 3 · Sending a tenth of the bytes and keeping faults visibleA plain wavelet coder at a tenth of lossless size beat SZ3 and ZFP and ran in real time on a Raspberry Pi, but seismic and screwdriving diagnosis did not fully survive.
Self-driving Postgres on the edgeTaking the self-driving Postgres idea of Postgres AI to the shop floor: why MorletDB should maintain itself on the machine, and where it must stop and ask. Updated with the first results: a disk filled on purpose on a Raspberry Pi, new recordings refused before it was full, nothing lost.