top | item 34314925

(no title)

hckr1292 | 3 years ago

Can you saw more about this? I've never heard of anything like this and can't figure out if its genius or silly. Things I'm curious about:

* Are you working on a SAAS product or embedded/IoT project or hobby project?

* How do you aggregate the SQLite logs together from disparate machines? Seems like you probably can't use fluentbit/filebeat/etc.

* Where do you query these logs?

* How do you structure these logs? (timestamp, machine, message) or something with more columns?

* Are you able to capture stacktraces?

I _love_ the idea of leveraging SQLite for this kind of scenario and possibly skipping a lot of messy plumbing or pricy vendors, but I'm uncertain how this works.

discuss

order

bob1029|3 years ago

We ship a B2B product that spools to a log.db when running on client machines. We built in-house tooling that is tailored to obtaining and analyzing copies of these databases.

Stack traces, user actions, 3rd party logs, et. al. are meticulously tracked in a schema we thought most appropriate for our business.