3 ms·
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
by Woodi 3y ago
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 !
- martinbaun 3y agowait, Sqlite3 can access files this way?
- leosanchez 3y agoSELECT * FROM "/etc/passwd"; does not work for me.
- formerly_proven 3y agoselect 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
- Woodi 3y agoOk, it is extra beautifull and very very sharp knive...
- SQLite 3y agoPerhaps the OP means OsQuery: https://github.com/osquery/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.
- digdugdirk 3y agoHoly 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.
- SahAssar 3y agoIIRC 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.