v0.104-0 (June 09, 2025)

This release adds collation support for key operators, enables background index builds, improves user CRUD defaults, and expands feature/config coverage.

1. Add string case support for $toDate operator.
2. Support sort with collation in runtime.
3. Support collation with $indexOfArray aggregation operator.
4. Support collation with array and object comparisons.
5. Default support enabled for Read & Read\Write privileges with secondary users.
6. Enable $let support for delete queries (requires EnableVariablesSupportForWriteCommands to be enabled).
7. Support compact command (requires documentdb.enablecompact GUC).
8. Enable role privileges for usersInfo command.

Performance
Enable rum_enable_index_scan as default.

Tooling / Infra
Add public documentdb-local Docker image with gateway to GHCR.

Full Changelog: v0.103-0...v0.104-0

v0.103-0 (May 09, 2025)

This release adds collation support across aggregation and find on sharded collections, enhances vector indexing with 4,000 dimension support, introduces binData conversions, ARM64 Docker builds (preview), documentdb gateway, and fixes database listing for >2GB.

1. Support collation with aggregation and find on sharded collections [Feature]
2. Support $convert on binData to binData, string to binData and binData to string (except with format: auto) [Feature]
3. Support half-precision vector indexing, vectors can have up to 4,000 dimensions [Feature]
4. Support collation with $documents and $replaceWith stage of the aggregation pipeline [Feature]
5. Push pg_documentdb_gw for documentdb connections [Feature]
6. Support ARM64 architecture when building docker container [Preview]
7. Fix list_databases for databases with size > 2 GB [Bugfix] (#119)

Full Changelog: v0.102-0...v0.103-0

v0.102-0 (March 26, 2025)

New Release with improvements to vector queries, adding support for collation and several commands and more...

1. Support index pushdown for vector search queries [Bugfix]
2. Support exact search for vector search queries [Feature]
3. Inline $match with let in $lookup pipelines as JOIN Filter [Perf]
4. Support TTL indexes [Bugfix] (#34)
5. Support joining between postgres and documentdb tables [Feature] (#61)
6. Support current_op command [Feature] (#59)
7. Support for list_databases command [Feature] (#45)
8. Disable analyze statistics for unique index uuid columns which improves resource usage [Perf]
9. Support collation with $expr, $in, $cmp, $eq, $ne, $lt, $lte, $gt, $gte comparison operators (Opt-in) [Feature]
10. Support collation in find, aggregation $project, $redact, $set, $addFields, $replaceRoot stages (Opt-in) [Feature]
11. Support collation with $setEquals, $setUnion, $setIntersection, $setDifference, $setIsSubet in the aggregation pipeline (Opt-in) [Feature]
12. Support unique index truncation by default with new operator class [Feature]
13. Top level aggregate command let variables support for $geoNear stage [Feature]
14. Enable Backend Command support for Statement Timeout [Feature]
15. Support type aggregation operator $toUUID. [Feature]
16. Support Partial filter pushdown for $in predicates [Perf]
17. Support the $dateFromString operator with full functionality [Feature]
18. Support extended syntax for $getField aggregation operator. Now the value of 'field' could be an expression that resolves to a string. [Feature]

Full change log: v0.101-0...v0.102-0

v0.101-0 is out! (February 12, 2025)

See what's new in DocumentDB:

1. Push $graphlookup recursive CTE JOIN filters to index [Perf]
2. Build pg_documentdb for PostgreSQL 17 [Infra] (#13)
3. Enable support of currentOp aggregation stage, along with collstats, dbstats, and indexStats [Commands] (#52)
4. Allow inlining $unwind with $lookup with preserveNullAndEmptyArrays [Perf]
5. Skip loading documents if group expression is constant [Perf]
6. Fix Merge stage not outputing to target collection [Bugfix] (#20)

Full change log: v0.100-0...v0.101-0

Initial Public Release (v0.100-0)

Initial version of DocumentDB includes support for

1. CRUD, Query and aggregation operations on BSON datatype.
2. Indexing the BSON field.
3. Compatible with pg_vector to support vector queries.
4. Compatible with postgis for geospatial queries.
5. Compatible with RUM indexes for Full text searches.