Skip to content

v2.0.0

Choose a tag to compare

@sphildreth sphildreth released this 28 Mar 18:54
· 568 commits to main since this release
78ecfad

DecentDB v2.0.0 is the first release of the Rust-native DecentDB engine.

This release replaces the earlier Nim-era implementation with a Rust rewrite focused on durable ACID writes, fast embedded reads, predictable correctness, a stable C ABI, and a fully refreshed multi-language binding ecosystem.

Highlights

  • Rust-native engine core with WAL-backed durability, B+Tree storage, snapshot-isolated reads, and a one-writer / many-readers concurrency model.
  • Stable native integration boundary via the public C ABI in include/decentdb.h, giving bindings a shared, versioned contract.
  • Major SQL surface expansion, including:
    • window enhancements such as NTILE, PERCENT_RANK, CUME_DIST, aggregate window functions, and frame-aware execution
    • ordered-set and statistical aggregates such as ARRAY_AGG, MEDIAN, PERCENTILE_CONT, and PERCENTILE_DISC
    • regex operators: ~, ~*, !~, !~*
    • richer date/time support with DATE_TRUNC, DATE_PART, DATE_DIFF, LAST_DAY, NEXT_DAY, MAKE_DATE, MAKE_TIMESTAMP, TO_TIMESTAMP, AGE, and timestamp INTERVAL arithmetic
    • richer scalar functions including GREATEST, LEAST, IIF, CONCAT, CONCAT_WS, POSITION, INITCAP, ASCII, REGEXP_REPLACE, SPLIT_PART, STRING_TO_ARRAY, QUOTE_IDENT, QUOTE_LITERAL, MD5, SHA256, and trigonometric functions
    • DML improvements including UPDATE ... RETURNING, DELETE ... RETURNING, and TRUNCATE TABLE variants
    • query and DDL additions including standalone VALUES, VALUES table sources, CREATE TABLE ... AS SELECT, LATERAL, CREATE SCHEMA, ALTER TABLE ... RENAME TO, named constraint add/drop support, generated VIRTUAL columns, and covering indexes with INCLUDE (...)
    • SQL-level PRAGMA support for page_size, cache_size, integrity_check, database_list, and table_info(table)
  • Updated bindings and tooling across:
    • .NET (ADO.NET, Dapper, MicroOrm, EF Core)
    • Python
    • Go
    • Java / JDBC
    • DBeaver integration
    • Node.js / Knex
    • Dart / Flutter desktop
  • Expanded CLI tooling for day-to-day operations, including import/export, save-as, vacuum, verify-header, and verify-index.
  • Cross-platform release assets for Linux x64, Linux arm64, macOS arm64, and Windows x64, plus JDBC and DBeaver packages, including Linux arm64 artifacts suitable for 64-bit Raspberry Pi OS.

Upgrade notes

  • v2.0.0 is a major release. It begins the Rust-native DecentDB line.
  • The earlier v1.x Nim-era releases are preserved in repository history but are no longer maintained.
  • If you are upgrading from an older Nim-era integration, treat this as a major-version migration and validate your application, binding usage, and packaging flow against the current v2 documentation and release assets.
  • For non-Rust integrations, the recommended native contract is the stable C ABI plus the officially published binding/tooling packages built on top of it.

Release assets

This GitHub release publishes:

  • DecentDB CLI + native library bundles for supported operating systems
  • JDBC driver artifacts
  • DBeaver extension packages

See the release assets for platform-specific downloads.

Documentation

Thanks to everyone helping move DecentDB into its Rust-native v2 line.