So either way you turn it both solutions go to disk?
So either way you turn it both solutions go to disk?
Simply saying you want the data to be durable isn’t that interesting or hard to achieve, there’s plenty of ways of achieving durable storage. The hard part is doing durable storage while also solving problems like query speed, and concurrency control.
And that is ignoring performance queries that don't require any guarantees.
You are thinking of a file system.
In the context of Linux/Unix/etc, the file-system is just another API for the OS - consider /dev/null or /proc - those are certainly in the file-system but they aren’t tied to persistent storage.
I didn't say they did.
consider /dev/null or /proc - those are certainly in the file-system but they aren’t tied to persistent storage.
I'm not sure what point you're trying to make here.
> > The whole point of a DB is to remember the data after power cycle. > You are thinking of a file system.
…as though you’re saying only an FS can persist data.