CrateDB 6.3 enhances compatibility with SQL and PostgreSQL, unifies object store access, and improves resilience, making integration with third-party tools easier.

CrateDB offers insights into distributed SQL database, IoT data management, and real-time analytics, providing documentation, tutorials, and best practices for deploying and scaling CrateDB in production environments. By exploring CrateDB's curated content, developers can learn about distributed query execution, data sharding, and replication strategies for building scalable and resilient database solutions. Whether you're collecting sensor data, analyzing log streams, or processing time-series events, CrateDB offers resources to handle high-volume, high-velocity data workloads and unlock the potential of distributed SQL databases.

CrateDB

CrateDB 6.3 has been released with a focus on SQL and PostgreSQL compatibility, unified object store access, and improved resilience. Key additions include ALTER COLUMN SET/DROP DEFAULT, CREATE TABLE ... LIKE, DROP SCHEMA CASCADE, new scalar functions (regexp_count, regexp_inst, pg_sleep, has_function_privileges), and Boolean predicates IS [NOT] TRUE/FALSE. Object store parameters for Azure, S3, and GCS have been unified under COPY TO/FROM commands. Resilience improvements include sequential ANALYZE processing, a new circuit breaker policy setting, and fixes to prevent SWAP/RENAME TO from interfering with snapshots.

New release: CrateDB 6.3