Hacker News Reader

Comment by Woodi | Hacker News Reader

I use it for some doc making in small family business :)

However sqlite gained "SELECT * FROM /etc/passwd" and other system stats gathering features so looking for replacement...

Some fork dedicated to eradicated more complicated things like eg. WINDOWS would be nice. And ex-Redis and others simplifications too !

View on HN

Perhaps the OP means OsQuery: https://github.com/osquery/osquery

OsQuery is an SQLite extension consisting of hundreds of virtual tables that provide SQL access to operating system status and configuration.

Holy smokes, that's the coolest thing I've found out about recently.

I'm trying to wrap my head around where this sits within the OS. Is it a layer "on top" of everything? Or does it sit "underneath" the higher level os functionality?

Apologies if that doesn't make any sense, it looks to be a really cool tool and I'll be investigating it regardless.

IIRC it reads from the same sources as command line tools do, so /proc/, /sys/ etc.

So it sits in the same place as `top` or similar.

wait, Sqlite3 can access files this way?

SELECT * FROM "/etc/passwd"; does not work for me.

select readfile('/etc/passwd');

Only works in the CLI. Which also has .import

    sqlite> create table pwd(name, pass, uid, gid, gecos, home, shell);
    sqlite> .sep :
    sqlite> .import /etc/passwd pwd
    sqlite> .mode column
    sqlite> select * from pwd where uid = '0';
    name  pass  uid  gid  gecos  home   shell    
    ----  ----  ---  ---  -----  -----  ---------
    root  x     0    0    root   /root  /bin/bash

Ok, it is extra beautifull and very very sharp knive...

Reply on news.ycombinator.com