from Hacker News

SQL powered operating system instrumentation, monitoring, and analytics

by gzel on 9/10/24, 8:31 AM with 7 comments

  • by nathanwallace on 9/10/24, 1:41 PM

    Readers may also enjoy Steampipe [1], an open source tool to live query 140+ services with SQL (e.g. AWS, GitHub, CSV, Kubernetes, etc). It uses Postgres Foreign Data Wrappers under the hood and supports joins etc with other tables. (Disclaimer - I'm a lead on the project.)

    1 - https://github.com/turbot/steampipe

  • by willvarfar on 9/10/24, 1:28 PM

    meta comment, but gotta say I'm loving the marked uptick in sql stories on HN recently. SQL is getting trendy again. Great :)
  • by thoughboxy on 9/10/24, 2:28 PM

    If you're looking at this, you might want to also look at fleetdm (https://github.com/fleetdm/fleet), from which hosts that have osquery installed, can be queried.
  • by RajT88 on 9/10/24, 1:59 PM

    Wasn't this the concept behind WMI?