--- warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there title: duckwake excerpt: | DuckDB Community Extensions Real-time DuckLake tables, exactly once. Keeps SQL views over Kafka as DuckLake tables, updated every few seconds. extension: name: duckwake description: Real-time DuckLake tables, exactly once. Keeps SQL views over Kafka as DuckLake tables, updated every few seconds. version: 0.2.0 language: Rust build: cmake license: MIT excluded_platforms: "windows_amd64_rtools;windows_amd64_mingw;windows_amd64;wasm_threads;wasm_eh;wasm_mvp;linux_amd64_musl" requires_toolchains: "rust;python3" maintainers: - harrydevforlife repo: github: duckwake/duckwake ref: 16ec8d6b32e27312733d51ca2caadaa55619802f docs: hello_world: | -- A DuckLake catalog in PostgreSQL and a Kafka topic of JSON events. CALL duckwake_connect('ducklake:postgres:dbname=lake host=localhost user=lake password=lake', data_path := 'lake_data/'); CALL duckwake_create_source('clicks', 'kafka', '{"brokers":"localhost:9092","topic":"clicks","event_time":"ts", "columns":{"ts":"TIMESTAMP","game_id":"VARCHAR","amount":"DECIMAL(18,2)"}}'); CALL duckwake_create_view('analytics.clicks_per_min', 'SELECT window_start, game_id, count(*) AS n, sum(amount) AS revenue FROM TUMBLE(clicks, ts, INTERVAL 1 MINUTE) GROUP BY ALL'); CALL duckwake_worker_start(); CALL duckwake_start('analytics.clicks_per_min'); FROM duckwake_jobs(); extended_description: | DuckWake keeps a SQL view's table in a DuckLake lake current as events arrive from Kafka. Each epoch (every 10 seconds by default) commits the view's new rows, its state and the Kafka offsets in one DuckLake transaction, so a crash never loses or repeats an event, and `duckwake_verify` checks a view against its query run as one batch. Views can filter, join lake tables, aggregate over tumbling and hopping windows or per group, and read other views and lake tables through their change feed. The extension runs a worker inside the DuckDB process (`duckwake_worker_start`); the same engine also runs as the `duckwaked` server and the `duckwake` CLI. It needs a DuckLake catalog in PostgreSQL and Kafka (JSON messages). Documentation: https://duckwake.github.io extension_star_count: 1 extension_star_count_pretty: 1 extension_download_count: 41 extension_download_count_pretty: 41 image: '/images/community_extensions/social_preview/preview_community_extension_duckwake.png' layout: community_extension_doc --- ### Compatibility Matrix This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.
| Platform | 1.5.5 | 1.5.6 | 2.0.0 | | :--- | :---: | :---: | :---: | | Linux AMD64 | ❌ | ❌ | ✅ | | Linux ARM64 | ❌ | ❌ | ✅ | | macOS AMD64 | ❌ | ❌ | ❌ | | macOS ARM64 | ❌ | ❌ | ✅ | | Windows AMD64 | ❌ | ❌ | ❌ | | Windows ARM64 | ❌ | ❌ | ❌ | | WebAssembly | ❌ | ❌ | ❌ | ### Installing and Loading ```sql INSTALL {{ page.extension.name }} FROM community; LOAD {{ page.extension.name }}; ``` {% if page.docs.hello_world %} ### Example ```sql {{ page.docs.hello_world }}``` {% endif %} {% if page.docs.extended_description %} ### About {{ page.extension.name }} {{ page.docs.extended_description }} {% endif %} ### Added Functions
| function_name | function_type | description | comment | examples | |----------------------------|---------------|-------------|---------|----------| | duckwake_add_source_column | table | NULL | NULL | | | duckwake_alter_view | table | NULL | NULL | | | duckwake_checkpoints | table | NULL | NULL | | | duckwake_connect | table | NULL | NULL | | | duckwake_create_source | table | NULL | NULL | | | duckwake_create_view | table | NULL | NULL | | | duckwake_drain | table | NULL | NULL | | | duckwake_drop | table | NULL | NULL | | | duckwake_explain | table | NULL | NULL | | | duckwake_jobs | table | NULL | NULL | | | duckwake_metrics | table | NULL | NULL | | | duckwake_pause | table | NULL | NULL | | | duckwake_reset | table | NULL | NULL | | | duckwake_sources | table | NULL | NULL | | | duckwake_start | table | NULL | NULL | | | duckwake_stop | table | NULL | NULL | | | duckwake_verify | table | NULL | NULL | | | duckwake_wait | table | NULL | NULL | | | duckwake_worker_start | table | NULL | NULL | | | duckwake_worker_status | table | NULL | NULL | | | duckwake_worker_stop | table | NULL | NULL | | | duckwake_workers | table | NULL | NULL | | ### Overloaded Functions
This extension does not add any function overloads. ### Added Types
This extension does not add any types. ### Added Settings
| name | description | input_type | scope | aliases | typed_value | |----------------|---------------------------------------------------------|------------|--------|---------|-------------| | temp_directory | Set the directory to which temporary files are written. | VARCHAR | GLOBAL | [] | post.db.tmp |