Your second paragraph describes SpiderOak quite accurately: it is exactly a logical file system implemented client side, with all the database work to support that done locally. It works because Sqlite is awesome.