News for hackers. Stuff that matters.
Re:Osquery: SQL-powered operating system instrumentation, mo... by NohatCoder on Wednesday August 21, 2019 @10:09AM (#20757293)
Am I the only person who read "SQL-powered operating system"?

It is just plausible enough to be imaginable. Everything is a table! Write applications using only SQL statements!

Re:Osquery: SQL-powered operating system instrumentation, mo... by aasasd on Wednesday August 21, 2019 @10:37AM (#20757621)
A filesystem isn't so different from a database in the first place. Not really relational, but still.

The olde PalmOS had databases as primary storage. Though databases seem to have had capacity for blobs, since apps themselves were stored that way, aside from text files, images and whatnot.

In fact, afaik some mainframe OSes were built around databases.

Re:Osquery: SQL-powered operating system instrumentation, mo... by hobs on Wednesday August 21, 2019 @10:35AM (#20757597)
It's not that far off from what WinFS had envisioned: https://en.wikipedia.org/wiki/WinFS

>WinFS includes a relational database for storage of information, and allows any type of information to be stored in it, provided there is a well defined schema for the type. Individual data items could then be related together by relationships, which are either inferred by the system based on certain attributes or explicitly stated by the user. As the data has a well defined schema, any application can reuse the data; and using the relationships, related data can be effectively organized as well as retrieved. Because the system knows the structure and intent of the information, it can be used to make complex queries that enable advanced searching through the data and aggregating various data items by exploiting the relationships between them.

From what I heard, it was slow, and devs just were not that interested in some clean schema based interface because it complicated their ability to ship; interesting that the modern approach seems to also favor schema on write.

Re:Osquery: SQL-powered operating system instrumentation, mo... by wglb on Wednesday August 21, 2019 @10:34AM (#20757587)
I learned that key parts of Azure involve MSSQL deep in the infrastructure.

The AS400 operating system had SQL as a key part of the core functionality.

So there is that.

Re:Osquery: SQL-powered operating system instrumentation, mo... by parasanti on Wednesday August 21, 2019 @10:18AM (#20757383)
I read your comment before clicking the link...I thought for sure we had a new OS that was in SQL...I was actually excited and definitely plausible.
Re:Osquery: SQL-powered operating system instrumentation, mo... by rmetzler on Wednesday August 21, 2019 @10:16AM (#20757363)
Haha, yes osquery works a little bit like this, but is read only on virtual tables backed by the OS.
Re:Osquery: SQL-powered operating system instrumentation, mo... by tabtab on Wednesday August 21, 2019 @11:44AM (#20758302)
Table-Oriented-Programming may finally hit the mainstream.