News for hackers. Stuff that matters.

A comment on Appropriate Uses for SQLite. Parent comment

Re:Appropriate Uses for SQLite by hawski on Monday September 26, 2016 @07:57AM (#12581072)
Why can't I have both? I am not against text logs, but it is good to have options. When binary format is an option I say that netstrings are probably better option.
[ Parent | on HN ]
Re:Appropriate Uses for SQLite by jstimpfle on Monday September 26, 2016 @09:50AM (#12581772)
For literal binary data you need to store the length information separately.

Netstrings are one option for ephemeral streams. But they are a bad tradeoff for persistent information: you have to read from the beginning of the stream until you find the relevant information. And a single corrupted byte destroys all the information after it.

Better options for persistent data are (pointer+length)s or memory-pools + ranges.

[ Parent | on HN ]