🦆DuckDB v2.0 Brings Client/Server Mode This Fall
Client/server mode finally arrives in DuckDB v2.0
TL;DR
DuckDB v2.0, named 'Cyanoptera', introduces client/server mode and a new storage format this fall. Key features include triggers, nested schemas, and asynchronous I/O for object stores.
DuckDB is set to release version 2.0, dubbed 'Cyanoptera,' this fall with significant updates including client/server support and an enhanced storage format. For developers working with large datasets or requiring distributed computing capabilities, the new client/server mode allows any DuckDB process to serve databases over a network, while other processes can connect and route queries using the CONNECT statement. This is particularly useful for teams needing robust data processing pipelines in environments like cloud object stores (S3). The update also brings long-requested features such as triggers, nested schemas, and JSON mutation functions, enhancing DuckDB's SQL dialect with NEAREST joins and recursive CTEs.
Key Points
DuckDB v2.0 ships in fall with client/server support; any process can serve databases over network
New SQL parser, default storage format, C API rework, and carefully chosen breaking changes included
Client/server mode allows connecting to DuckDBs via the quack extension for seamless data routing
Triggers (BEFORE/AFTER, FOR EACH ROW/STATEMENT) enable audit tables and complex business logic
Asynchronous I/O supports object stores like S3; JSON mutation functions add in-place document modification
Why It Matters
If you're working with large datasets or need distributed computing capabilities, DuckDB v2.0's client/server mode is a game changer. It allows seamless data routing and processing across multiple instances, enhancing scalability and performance. For teams using cloud object stores like S3, the asynchronous I/O support makes it easier to manage and process big data efficiently.
Frequently Asked Questions
Why does this matter?
If you're working with large datasets or need distributed computing capabilities, DuckDB v2.0's client/server mode is a game changer. It allows seamless data routing and processing across multiple instances, enhancing scalability and performance. For teams using cloud object stores like S3, the asynchronous I/O support makes it easier to manage and process big data efficiently.
What happened?
DuckDB v2.0, named 'Cyanoptera', introduces client/server mode and a new storage format this fall. Key features include triggers, nested schemas, and asynchronous I/O for object stores.
Comments
Be the first to comment
Enjoyed this article?
Get it daily. 7am. Free. Reads in 5 minutes.
Join 3,129 builders reading daily.