SQL
SQL | News, how-tos, features, reviews, and videos
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...
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.
Tired of searching Slack, GitHub, and Google Drive separately? Do it all at once in SQL
When APIs are automatically database tables, it’s easy to combine search results from diverse APIs.
CockroachDB’s 22.1 update aims to help prototype faster, scale on demand
The latest update from the distributed SQL database is expected to aid enterprise engineering teams to prototype faster, automate more operations, and maintain peak performance during massive transaction spikes across geographies with...
What is JDBC? Introduction to Java Database Connectivity
Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more.
Do your AWS deployments match your Terraform definitions? Use SQL to find out.
For belt-and-suspenders security and compliance, use SQL to query your Terraform files in the same way you query your AWS, Azure, or GCP services.
The 9 most important new features in YugabyteDB
YugabyteDB 2.13 brings materialized views, local reads for performance, region-local backups, and much more, extending the geo-distribution capabilities of the database.