News for hackers. Stuff that matters.
Re:Osquery: Expose the operating system as a relational data... by falcolas on Wednesday October 29, 2014 @02:01PM (#8528768)
You know, this wouldn't be too hard to implement as a storage engine for MySQL... What an intriguing idea.
Re:Osquery: Expose the operating system as a relational data... by marpaia on Wednesday October 29, 2014 @02:27PM (#8528928)
The SQL engine part of osquery is backed by SQLite's parser, lexer, query planner, etc. MySQL would be awesome as well though, mostly because of how easy it might be to integrate the MySQL remote access protocol to do remotely authenticated queries!
Re:Osquery: Expose the operating system as a relational data... by Shish2k on Thursday October 30, 2014 @08:35AM (#8532546)
Postgres would probably be even easier, since it already has the framework to do this (foreign data wrappers) and a nice API to write said wrappers in python[1] - 200 lines to use your SQL client as an email reader[2], I imagine that wrapping /proc would be considerably less :)

[1] http://multicorn.org/foreign-data-wrappers/ [2] https://github.com/Kozea/Multicorn/blob/master/python/multic...

Re:Osquery: Expose the operating system as a relational data... by Shish2k on Thursday October 30, 2014 @09:04AM (#8532646)
Turns out postgres is even easier. Took 15 minutes to go from "never used FDWs before, but how hard can it be?" to "got access to the process table as SQL" :)

https://github.com/shish/pgosquery

Re:Osquery: Expose the operating system as a relational data... by agrover on Wednesday October 29, 2014 @02:46PM (#8529047)
easier in Postgresql, with its foreign data wrapper capability.
Re:Osquery: Expose the operating system as a relational data... by ris on Wednesday October 29, 2014 @02:29PM (#8528940)
Please just let MySQL die.
Re:Osquery: Expose the operating system as a relational data... by ninjaplease on Wednesday October 29, 2014 @06:09PM (#8530305)
Get a load of Mr. "Im-too-l33t-to-use-MySQL" over here.

Otherwise it sounds like you're insinuating that MySQL is somehow languishing or limping along, which is ridiculous.

MySQL is going to SELECT almost any query faster than Postgres in a single-user/desktop installation, it's going to be easier (although granted less strict) to import data, plus it has Sequel Pro.

Re:Osquery: Expose the operating system as a relational data... by AlisdairO on Thursday October 30, 2014 @04:12PM (#8535529)
Without endorsing the GP's trolling, Postgres generally substantially outperforms MySQL on queries with any complexity to them. Its query optimiser is enormously superior.

The idea that MySQL is much faster than PG is largely a relic of the era of MyISAM, which was very fast for trivial queries, but also terrible in basically every other way.

Re:Osquery: Expose the operating system as a relational data... by ninjaplease on Friday October 31, 2014 @06:56PM (#8541504)
Interesting. Apparently my received wisdom is out-of-date. I usually use MySQL on the laptop when I have to clean data for analysis because it's already installed, but I will have to look into replacing it.