| ▲ | lgeorget 3 days ago | |||||||||||||
More of a sidenote than an answer but a database system can be faster than using the disk directly: https://sqlite.org/fasterthanfs.html#approx. It turns out having a defined abstraction like a database makes things faster than having to rely on a rawer interface like filesystems because you can then reduce the number of system calls and context switches necessary. If you wanted to optimize that in your own code rather than relying on a database, you'd end up reinventing a database system of sorts, when (probably) better solutions already exist. | ||||||||||||||
| ▲ | AyanamiKaine 3 days ago | parent [-] | |||||||||||||
But this would only relate to local databases wouldn't it? Having to connect to a postgres server or something similar. The latency for queries would be far higher than using the file system. | ||||||||||||||
| ||||||||||||||