SQL
SQL | News, how-tos, features, reviews, and videos
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...
![JavaWorld > Persistence [series] > coding / programming / software development](https://images.idgesg.net/images/article/2019/04/jw_java_persistence_series_3x2_2400x1600_6_coding_programming_software_development_by_alpesh_ambalal_patel_gettyimages-100792566-small.3x2.jpg?auto=webp&quality=85,70)
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.
Beyond SQL: 8 new languages for data querying
SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases.
JSONB in PostgreSQL today and tomorrow
PostgreSQL was the first relational DBMS to introduce JSON support, and its JSONB index search capability is unique. More is on the way.
How SQL can unify access to APIs
PostgreSQL foreign data wrappers are a great way to expose APIs to SQL. And SQL is a great way to reason over the data.
