SQL

SQL | News, how-tos, features, reviews, and videos

Team member extends all hands in for a huddle. [unity / teamwork / trust / diversity / inclusion]

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.

light string in a jar at sunset / lightbulbs / ideas / innovation / brainstorming

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.

shutterstock 1193930281 silver whistle on green paper background

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.

modular humanoid polyhedra / connections / structure / building / network

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.

shutterstock 359257322 SQL structured query language

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.

shutterstock 1936992907 dashboard terminal finance analytics

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.

social media network interaction

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.

shutterstock 734506006 steam pipe pressure gauge engine room

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.

13 small business security

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.

Planning / strategy / management  >  Nurturing growth / scale / expansion

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.

background black coffee cactus 951228

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.

budgets / data / analytics / charts / money

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.

global connections / digital world map / planet earth / particles, light

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.

datacenter servers warehouse database

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.

Binary stream passing over rows of monitors, each also displaying binary streams.

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.

A network of linked question marks.

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.

CIO | Middle East  >  Egypt  >  Giza  >  Milky way galaxy stars shine over the pyramids

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.

car speedometer

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.

datacenter servers warehouse database

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...

Neon sign > handshake / deal / agreement / partnership / team / merger

Aerospike partners with Starburst to jump on the SQL bandwagon

Aerospike is jumping on the trend for NoSQL database providers to allow users to query data with popular SQL-based business intelligence and analytics tools, to reach a broader customer base.

Load More