Comment by teleforce
5 years ago
Shouldn't this has 2014 inside the title? The story has also appeared several times in HN before.
Very interesting concept but now I think perhaps application file format using TileDB will be much better since it can support sparse data as well [1].
TileDB uses a "pile of files", as the article calls it, it doesn't have SQL, and it has a rather embarrassing point of view on race conditions (https://docs.tiledb.com/main/basic-concepts/consistency). It could be a good choice for applications that rely on large and simple multidimensional arrays, hardly the same "market" as application file formats.
Moreover, database tables are a very good fit for sparse multidimensional arrays.
Perhaps SQlite or any SQL engine is not a good idea for application file format [1],[2], or is it just bad for web applications?
[1]https://support.google.com/chrome/thread/17537877?hl=en
That's not at all similar it doesn't support SQL