SQL
SQL | News, how-tos, features, reviews, and videos
![Team member extends all hands in for a huddle. [unity / teamwork / trust / diversity / inclusion]](https://images.idgesg.net/images/article/2020/09/business_team_puts_all_hands_in_for_a_huddle_for_unity_teamwork_team_spirit_trust_diversity_inclusion_by_prostock-studio_gettyimages-1201215883_2400x1600-100859605-small.3x2.jpg?auto=webp&quality=85,70)
Mastodon relationship graphs
Steampipe and SQL allow us to see relationships among the data we extract from APIs. Here’s how to graph the connections between tooters and boosters on Mastodon.
Instance-qualified Mastodon URLs
Transforming foreign server URLs into home server URLs makes a Mastodon dashboard massively more useful. Steampipe’s Mastodon plugin now does that for you.
How many people in my Mastodon feed also tweeted today?
You can discover which Mastodon tooters also tweeted using my favorite kind of Steampipe query.
Lists and people on Mastodon
When viewing the people you follow on Mastodon, it’s helpful to know which lists (if any) you’ve assigned them to. Here's how you can do that with SQL and Steampipe.
Create your own Mastodon UX
A dashboard+feed reader built with SQL gives you an easy and natural way to consume as much, or as little, Mastodon activity as you like.
A Bloomberg terminal for Mastodon
Our brains are built to take in a lot of information at a glance, and if it’s organized well we can do that very effectively. Applying filters helps.
Browsing the fediverse
Steampipe’s SQLification of the Mastodon API is a handy way to track activity in the fediverse. Use it to do Mastodon analytics, find interesting people, and more.
Mastodon, Steampipe, and RSS
Using Steampipe to build a dashboard that combines queries of the Mastodon search API and the joys of RSS-powered integration.
How Steampipe enables KPIs as code
CMD Solutions built tools for continuous controls assurance by using open-source Steampipe to define information security performance metrics as SQL statements.
Starburst Galaxy gets data discoverability updates
At AWS re:Invent 2022, the company also announced support for AWS Lake Formation via Starburst Enterprise suite to help joint customers implement data mesh architecture.
Java, Python top most wanted list for employers
Java, Python, SQL, C++, and JavaScript programming skills are most in demand in the workplace, says the HackerRank developer skills report.
InfluxDB’s next-gen time-series engine is built on Rust, supports SQL
The new time series engine is capable of responding to queries faster, supporting data analysis of massive database workloads.
Ant Group lists OceanBase on AWS Marketplace to increase reach
The distributed SQL-compatible database, which supports hybrid transactional analytical processing (HTAP), is expected to add support for other public cloud service providers soon.
Materialize offers early release of its streaming database as a service
The startup's managed, distributed database service is designed to run queries against real-time data in a more cost-efficient manner than batch processing systems.
Visualizing the Hacker News API with HCL and SQL
Use Steampipe and GitHub Actions to create a ‘dashboard as code’ for exploring thousands of Hacker News stories, right up to the current hour.
Why database design choices matter to developers
Rather than punt database design decisions to a cloud service or third-party provider, understand what you want to achieve and how best to deliver on that goal.
StarRocks launches managed DBaaS for real-time analytics
Built on Apache Doris, StarRocks is launching a fully-managed database-as-a-service, dubbed StarRocks Cloud.
7 key new features in SingleStoreDB
SingleStoreDB unifies transactions and analytics in the same engine to power real-time, data-intensive applications. Here’s what’s new.
Apache Doris just 'graduated': Why care about this SQL data warehouse
The open source, massively parallel processing (MPP) analytical database will take on the likes of ClickHouse, MariaDB, Apache Druid, Apache Pinot, and hyperscaler services such as Google BigQuery, Amazon RedShift and Microsoft...
