better-sql
steampipe-plugin-sdk
better-sql | steampipe-plugin-sdk | |
---|---|---|
2 | 9 | |
25 | 29 | |
- | - | |
0.0 | 9.1 | |
over 1 year ago | 8 days ago | |
TypeScript | Go | |
BSD 2-clause "Simplified" License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
better-sql
-
Steampipe – Select * from Cloud;
The ergonomics issue of SQL can be workaround by transpiler.
I do like SQL the syntax but it's hard to discard the ecosystem around SQL.
For instance, I made better-sql [1] recently which generate SQL from a language similar to GraphQL and EdgeDB query language.
[1] https://better-sql.surge.sh
-
EdgeDB 2.0
I'm working on a npm package [1] that "transpile" from a syntax inspired by edgedb into raw sql. I've implemented select columns, join tables and where statements. Still having more to work on (e.g. order by, group by, aggregate function, and more important, the readme)
[1] https://github.com/beenotung/better-sql
steampipe-plugin-sdk
- Zero-ETL for Postgres: Live-query cloud APIs with 100 open source FDWs
-
Steampipe Hacktoberfest 2023
🔧 The CLI is written in Go, as well as the Steampipe Plugins connecting to various APIs like AWS, GitHub, Zoom, Reddit, and 130+ more. https://hub.steampipe.io/plugins
-
Cloudquery, Resoto, Steampipe, or Airbyte?
It's fully open source with a thriving community of users and contributors. As of today, there are 111 plugins (including AWS & Azure). We also have thousands of open source queries, security benchmarks, resource graphs and dashboards available out of the box as mods. See the Steampipe Hub for full docs and details.
-
Steampipe vs aws security hub
Steampipe is free, open source. It's a CLI used to SQL query & report across all your cloud APIs & data sources (e.g. AWS, GitHub, Slack, Kubernetes, Terraform, etc) along with a dashboards-as-code capability to run automated security & compliance benchmarks. Allows you to simply query & report without the overhead for log ingestion, ETL or a DB.
-
Need to audit an Azure environment, any tip?
For some background, the Steampipe CLI provides an open source, common SQL interface to query join and report from your cloud APIs (e.g. Azure, AWS, GitHub, AzureAD, M365, etc).
-
Enrich Splunk events with Steampipe
Not the author, but a big fan of steampipe. You can use this example as a starting point to write integrations with a number of other services that are supported by steampipe plugins.
-
Use SQL to query Microsoft 365 drive files, mail messages, team members and more (new open source project)
Since Steampipe provides a common SQL interface across plugins, there could be interesting 'joins' that you can do for querying & reporting -- any interesting joins you would consider across SPO, M365 or other plugins?
-
Steampipe (CLI to query APIs with SQL) is participating in Hacktoberfest 2022!
The CLI is written primarily in Go, as well as its plugins (e.g. AWS, GitHub, Slack, Zoom, Reddit, etc): https://hub.steampipe.io/plugins. You can extend an existing plugin by adding new 'tables', or you can write your own plugin for your favorite cloud service.
- Steampipe – Select * from Cloud;
What are some alternatives?
edgedb-go - The official Go client library for EdgeDB
steampipe-plugin-aws - Use SQL to instantly query AWS resources across regions and accounts. Open source CLI. No DB required.
edgedb-cli - The EdgeDB CLI
steampipe - Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.
edgedb-examples - EdgeDB example projects for different stacks
OSQuery - SQL powered operating system instrumentation, monitoring, and analytics.
vlcn-orm - Develop with your data model anywhere. Query and load data reactively. Replicate between peers without a central server.
steampipe-plugin-jira - Use SQL to instantly query Jira. Open source CLI. No DB required.
steampipe-mod-aws-thrifty - Are you a Thrifty AWS dev? This mod checks your AWS accounts for unused and under-utilized resources using Powerpipe and Steampipe.
steampipe-plugin-tailscale - Use SQL to instantly query Tailscale resources. Open source CLI. No DB required.