pushrax
Joined 13 years ago
Joined 13 years ago
The biggest difference at a low level is that turbopuffer records have unique primary keys, and can be updated, like in a normal database. Old records that were overwritten won't be returned in searches. The LSM tree storage engine is used to achieve this. The LSM tree also enables maintenance of global indexes that can be used for efficient retrieval without any time-based filter.
Quickwit records are immutable. You can't overwrite a record (well, you can, but overwritten records will also be returned in searches). The data files it produces are organized into a time series, and if you don't pass a time-based filter it has to look at every file.
- https://www.interactivebrokers.com/en/pricing/stock-yield-en...
- https://www.fidelity.com/trading/fully-paid-lending
Some brokerages lend out spare cash (and pay a transparent interest rate, and are subject to strict reserve requirements) but the majority of assets controlled by a typical brokerage are securities. FTX assets were all subject to their leverage strategies, with no specific reserve.
Unlike AVIF, JPEG XL also has advanced progressive delivery features, which is useful for the web. And if you look at the testing described in the post, JPEG XL also achieved higher subjective quality per compressed bit, despite having a faster encoder.
This timecode format is a timestamp with seconds resolution plus a frame count within each second. To properly sync, all the timecode generators must use the same framerate. In other words, the audio recorder’s timecode framerate needs to match the camera.
Either way it's more sensible to build high throughput microwave networks given the tiny amount of shortwave bandwidth we have.
As you say the downside is available bandwidth and throughput.