0.9.0 release

[andyfengHKU]

This issue keeps track of 0.9.0 release plans

Features

• Vector index
  • Filtered search (Guodong)
  • Move vector index as an extension (Guodong)
  • Benchmark on public datasets (index construction time, search latency, and recall) (Guodong)
  • Add the support of YIELD (Guodong)
• Scan from arbitrary SQL statement
• Async Python API: Add AsyncConnection for asynchronous query execution on Python API #5061
• Sync Node.js API: Implement synchronous APIs for Node.js bindings #5058
• List predicate: all, single, none, any

Performance optimization

• Parallel distinct simple aggregate
  • Click benchmark (Ben)
  • Create FTS index performance (Ziyi)
• Bulk insert performance Statistics update optimization #4980

Outstanding issues

• Feature: CURRENT_TIMESTAMP as a default value for TIMESTAMP attributes #5081 (Ziyi)
• Feature: Support querying on Internal ID #4901 (Ziyi)
• Bug: FTS is unable to operate on tables created in the same query context #5066 (Ziyi)
• Feature: Support list parameters in kuzu-wasm #5056 (Chang)
• Bug: Query using WITH ... + recursive relation hangs #5040 (Xiyang)
• Bug: Assertion failure on recursive join test in manual transaction #5012 (Guodong)
• Feature: Possibility to use JOIN with LOAD FROM when importing data from a SQL database #4970
• Bug: Buffer manager exception for simple queries on large data #4943
• Feature: Bundle extension during the build process #5076 (Ziyi)
• Bug: reverse() function always casts to string (should work differently for integer arrays) #5105 (Ziyi)
• Bug: EnableCompression seems to have no effect #5050 (Ben)
• Bug: Defining a rel table with multiple node table pairs #5049 (Guodong)
• Bug: LSQB Q3 Performance #4967 (Guodong/Xiyang)
• Bug: Loading a small JSON takes forever #5086: (Royi)
• Feature: Graceful stopping and reloading if connection to database is stopped midquery #5016 (Royi)
• Bug: Prepared statement reuse unexpected behavior #5102 (Royi)
• Bug: Copy node table using too much memory and not managed by bm #4937 (Ben)
  • Track the mem usage of in-mem index with BM.
• Bug: Extensions don't load from within the Rust API #5065 (Ben)
• Feature: Provide a table of all function keyword alias mappings for downstream syntax highlighters #5107

Docs

• Vector Index Vector extension kuzu-docs#416 (Guodong)
• SQL_QUERY Add doc for sql-query kuzu-docs#430 (Ziyi)
• Async Python API and Sync NodeJS API Document Python async connection and node sync connections kuzu-docs#414 (Prashanth)
• List predicates Document list predicate kuzu-docs#418 (Ziyi)
• Using Ollama with Kuzu Explorer Documentation for using Ollama with Kuzu Explorer kuzu-docs#415 (Prashanth)

Blog post

• Vector index
• Scan from arbitrary SQL statement
• Point to Unity catalog docs update that shows Kuzu
• New APIs (async Python, sync Nodejs)
• Ollama (open source LLM) integration with Kuzu Explorer for text2Cypher
• Performance improvements
• Bundled WASM with vector and fts