Skip to content

Latest commit

 

History

History
127 lines (86 loc) · 3.34 KB

non-db-sql.md

File metadata and controls

127 lines (86 loc) · 3.34 KB

JSON logs

  • SQL for JSON and CSV streams https://github.com/avz/jl-sql

    cat data.json | jl-sql 'SELECT key, SUM(value) AS sum, COUNT(*) AS count GROUP BY key'

OS details

  • SQL powered operating system instrumentation, monitoring, and analytics. https://osquery.io/

    osqueryi --json "SELECT * FROM mounts m, disk_encryption d WHERE m.device_alias = d.name AND d.encrypted = 0;"

Images

MongoDB, DynamoDB, Kafka, S3

Git

Play Music

Cloud

k8s

Terraform

  • Run SQL queries on your Terraform infrastructure. Query resources and analyze its configuration using a SQL-powered framework. https://github.com/mazen160/tfquery

    tfquery -q 'select count(*) as count from resources;'  --tfstate-dir /path/to/terraform-states

Geodata

  • Display your spatial data on a map, no server required. Simply define the SQL query and get a ready-to-use tile endpoint https://www.vtiler.com/

    SELECT id, name, line AS geom FROM roads WHERE line && bbox;

Blockchain

Files

Games

AI