beekeeper-studio
steampipe
| beekeeper-studio | steampipe | |
|---|---|---|
| 59 | 146 | |
| 15,348 | 6,401 | |
| 1.7% | 1.0% | |
| 9.9 | 9.7 | |
| 3 days ago | 7 days ago | |
| TypeScript | Go | |
| GNU General Public License v3.0 only | GNU Affero General Public License v3.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.
beekeeper-studio
-
Using migrations with Golang
If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:
-
Document your database simply and easily
This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database.
To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/
- API completa em Golang - Parte 2
- Usando migrations com Golang
-
Beekeeper Studio SQL editor 4.0 – Import. backup, restore, and bigquery
I use the free “community” edition daily: https://github.com/beekeeper-studio/beekeeper-studio/release...
-
Why people care about PostGIS and Postgres
postgres has some cool tools these days. postico if you are on macos or my personal fav lately has been https://www.beekeeperstudio.io/
-
👻Top 8 Free, Open Source SQL Clients🔥
Beekeeper Studio is a modern (aesthetic) and lightweight SQL client that supports MySQL, Postgres, SQLite, SQL Server, etc. It is available on Linux, Mac and Windows.
- Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?
-
Where to get OV code signing certificates now?
I'm trying to renew my certificate for Beekeeper Studio, 3 years ago it was a simple download, but now it costs 3x the price and they want to ship me a physical device with the private key on it.
-
Software Developer Mac Apps
`cask "beekeeper-studio"` [link][oss] for anything database
steampipe
- Steampipe: Dynamically query APIs, code and more with SQL
-
Cloud Tools You Probably Haven't Heard Of
Steampipe is a tool for querying cloud APIs and other data sources using SQL in a zero-ETL manner.
-
Show HN: Query Your Sheets with SheetSQL
Readers may also enjoy Steampipe [1], an open source CLI to live query Google Sheets [2] and 140+ other services with SQL (e.g. AWS, GitHub, etc). It uses Postgres Foreign Data Wrappers under the hood and supports joins etc across the services. (Disclaimer - I'm a lead on the project.)
1 - https://github.com/turbot/steampipe
-
Osquery: An sqlite3 virtual table exposing operating system data to SQL
be mindful of its AGPLv3 https://github.com/turbot/steampipe/blob/v0.21.8/LICENSE (AFAIK v0.4.3 is the last MIT release https://github.com/turbot/steampipe/blob/v0.4.3/LICENSE ) and the actual providers are Apache 2 <https://github.com/turbot/steampipe-plugin-aws/blob/v0.131.0...> (but I don't know if provider drift makes them compatible with 0.4 or not)
iasql seems to be AWS only, but good for them for taking this on:
-
How to run an AWS CIS v3.0 assessment in CloudShell
In a prior post I showed how to install Steampipe in AWS CloudShell to instantly query over 460+ resource types from your AWS APIs using SQL, and another post on how to use the Steampipe AWS Compliance mod to assess over 25+ security benchmarks across your AWS accounts.
- Git Query Language
- Query Cloud and SaaS APIs with SQL
-
Cutting down AWS cost by $150k per year simply by shutting things off
Readers may find Steampipe's [1] AWS Thrifty Mod [2] useful. It will automatically scan multiple accounts and regions for 50 cost saving opportunities - many of which are looking for over-provisioned or unused resources. For example, it's crazy how much you can save by doing things like just converting your EBS volumes to the newer gp3 type. Combine with Flowpipe [3] to automate checks and actions. It's all open source and extensible.
1 - https://github.com/turbot/steampipe
- FLaNK Weekly 08 Jan 2024
-
Zero-ETL for Postgres: Live-query cloud APIs with 100 open source FDWs
Steampipe [1] is an open source project [2] that includes an embedded Postgres to instantly query cloud, code & more with SQL. This release expands our plugin ecosystem [3] to be a full Zero-ETL platform. Steampipe plugins can now run natively in your own Postgres as Foreign Data Wrappers [4], as SQLite extensions [5] or as simple data export tools [6]. Please give it a try, we'd love your feedback and contributions!
1 - https://steampipe.io
What are some alternatives?
dbgate - Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application
cloudquery - The open source high performance ELT framework powered by Apache Arrow
Sequel-Ace - MySQL/MariaDB database management for macOS
cloud-custodian - Rules engine for cloud security, cost optimization, and governance, DSL in yaml for policies to query, filter, and take actions on resources
cloudbeaver - Cloud Database Manager
metriql - The metrics layer for your data. Join us at https://metriql.com/slack
Portainer - Making Docker and Kubernetes management easy.
inspec-aws - InSpec AWS Resource Pack https://www.inspec.io/
sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
steampipe-mod-github-sherlock - Interrogate your GitHub resources with the help of the world's greatest detectives: Powerpipe + Steampipe + Sherlock.
sqlitestudio - A free, open source, multi-platform SQLite database manager.
embedded-postgres-binaries - Lightweight bundles of PostgreSQL binaries with reduced size intended for testing purposes.