Comments by "TheEVEInspiration" (@TheEVEInspiration) on "Implementing Hardware-Friendly Databases (with DuckDB co-creator, Hannes Mühleisen)" video.

  1. I hope the database can be used in client server mode and had backup/restore functionality. Else its practicality in the field will be quite limited. Even a crude client/server with just a few broad rights (like read-only) and limited number of users would go a long way.
    2
  2.  @LtdJorge  IMO, you just described its crippling limitations for real applications, not its strengths. There are very few use-cases other than taking a first look at some data with the CLI tool as far as I can see from your reply. Actual applications for automation need more than that and cannot accept data of unknown structures to work with meaningfully. And also require support for other processes to access the data or the output after processing of said data. So as an explorer tool that uses SQL to open CSV files etc, sure. It will be better at that than typical RDBMS I seen, but once that is done, one still needs to use RDBMS for the real deal. Can't call it a database then, call it a data-explorer tool.
    1
  3. Another drawback of parallelizing re-partitioning streams instead of parallel operators is that there is a lot more memory claimed, just to avoid spillovers. And spillovers really hurt performance.
    1