A
A
alex14782019-12-22 18:50:12
linux
alex1478, 2019-12-22 18:50:12

Database for single payer?

I don't know how to make the title clearer.
I need a database that won't crash when it crashes. Specifically, I need this database to work on my single-board device, which can be turned off at any time by simply pulling it out of the socket. It's not scary if the current operation fails, the main thing is that the database is not damaged.
UPD. I'll try everything that was suggested here, except for writing to a file, since there are quite a lot of records in tables, as well as search operations on them. After a while, I will write where I stopped and note the working options as a solution.

Answer the question

In order to leave comments, you need to log in

5 answer(s)
A
Alexey Cheremisin, 2019-12-22
@leahch

But do not believe it - redis !!! Writes every 15 minutes, recovers, works in memory.

V
Vladimir Korotenko, 2019-12-22
@firedragon

sqlite only write in 1 thread

E
Egor Kazantsev, 2019-12-23
@saintbyte

Write to files, do sync after each write

K
Karpion, 2019-12-23
@Karpion

In fact, all modern DBMSs are designed specifically for this. Ideally, the data should be located not in the file system, but in an unformatted partition, otherwise not all file systems can withstand a power outage.

S
Saboteur, 2019-12-23
@saboteur_kiev

So it's not a single-payer and not a process. The point is the disk subsystem, how it is organized.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question