News for hackers. Stuff that matters.
Re:Appropriate Uses for SQLite by tracker1 on Monday September 26, 2016 @05:48AM (#12580503)
It's simply easier to determine when an object ends with a delimiter...

    {"dtm":"2016-...",...,meta:{...}}
That requires more complicated input processing/streaming than read until '\n' then parse the record...
Re:Appropriate Uses for SQLite by eatonphil on Monday September 26, 2016 @07:43AM (#12580997)
Not meaningfully more complicated. You know when you've reached the end of your object of you are actually parsing it, so you also know when the next one can begin.
Re:Appropriate Uses for SQLite by JdeBP on Tuesday September 27, 2016 @12:29PM (#12590840)
Actually, no, one is not necessarily parsing it. Xyr point was that using line delimiters allows one to retain one-log-record-per line semantics and use the log stream with text processing tools that understand those semantics but that do not understand JSON.
Re:Appropriate Uses for SQLite by tracker1 on Monday September 26, 2016 @01:08PM (#12583584)
When you're working with a platform that has native JSON parsing, it generally doesn't support streams as described... so you either count braces and quotes, create a stream processor or use a delimiter... a delimiter is an easy enough solution, also allows for easier viewing in a text editor. It's about being pragmatic.