Does the

--database_in_memory

flag work for others? On osquery 1.8.2 on OSX I get

$ sudo osqueryd --database_in_memory
E0930 11:06:12.575891 2095128576 init.cpp:573] [Ref #1629] osqueryd initialize failed: Could not initialize database