4 ms·
You know, this wouldn't be too hard to implement as a storage engine for MySQL... What an intriguing idea.
by falcolas 12y ago
You know, this wouldn't be too hard to implement as a storage engine for MySQL... What an intriguing idea.
- marpaia 12y agoThe 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!
- Shish2k 12y agoPostgres 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/ http://multicorn.org/foreign-data-wrappers/ [2] https://github.com/Kozea/Multicorn/blob/master/python/multicorn/imapfdw.py#L66 https://github.com/Kozea/Multicorn/blob/master/python/multic...
- Shish2k 12y agoTurns 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 https://github.com/shish/pgosquery
- ris 12y agoPlease just let MySQL die.
- ninjaplease 12y agoGet 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.
- AlisdairO 12y agoWithout 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.
- ninjaplease 12y agoInteresting. 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.
- agrover 12y agoeasier in Postgresql, with its foreign data wrapper capability.