P
P
Pavel K2017-08-29 17:48:28
SQLite
Pavel K, 2017-08-29 17:48:28

Is writing logs in sqlite a bad idea?

Greetings!
How bad is it to write logs in SQLite?
In the logs themselves there will be mostly errors (and their dump), events and little things.
About 1000 entries per day. The logs themselves are from the client program.
Of the pluses, I see:
1. The ability to easily transfer the entire log to the server on request.
2. No problems with rotation. You can delete not all, but selectively records.
3. Easy search of the necessary records on the "place" with the help of portable SQLite managers.
But I do not see any cons - tell me, please?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
X
x67, 2017-08-29
@x67

There is nothing wrong with this, although writing to a file ensures that the log is always written while the machine is running. But the probability that sqlite will break is still higher.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question