News for hackers. Stuff that matters.
Re:Why SQLite is so great for the edge by xyx0826 on Tuesday June 06, 2023 @10:01PM (#36221896)
Precisely so! There are two CAN buses and one UART port to log from, and the Python code spawns subprocesses for each of them. They each create or open a SQLite database named after their bus/port and get to work.

This setup is easy to put together but might not be optimal. I don't have a lot of experience with SQLite performance tuning, and I wonder if it will be faster to have worker threads pass everything thru IPC to a writer thread, which batches rows and writes to a centralized database.

There are no comments on this comment yet.