Comment by densh
1 day ago
Sqlite is essentially a user space queryable file system and it can be faster than writing to file system directly while working with small files.
1 day ago
Sqlite is essentially a user space queryable file system and it can be faster than writing to file system directly while working with small files.
SQLite is in-process. A user space file system is another process. Like Postgres if we want to compare fs with dbs. And Postgres is slow for many small queries, like a userspace file system.