How to create the collection with time stamp #95

Activity

1. quinnj commented on Oct 4, 2026

   

   quinnj

   on Oct 4, 2026

   Member

   More actions

   The existing Mongoc.write_command method can send MongoDB's create command with time-series options:

   import Mongoc
   using Dates
   
   client = Mongoc.Client("mongodb://localhost:27017")
   database = client["time_series"]
   Mongoc.write_command(database, Mongoc.BSON(
       "create" => "measurements",
       "timeseries" => Dict(
           "timeField" => "timestamp",
           "metaField" => "sensor",
           "granularity" => "minutes",
       ),
   ))
   collection = database["measurements"]
   Mongoc.insert_one(collection, Mongoc.BSON(
       "timestamp" => DateTime(2022, 1, 1),
       "sensor" => "A",
       "temperature" => 21,
   ))

   Use a new collection name. MongoDB requires feature compatibility version 5.0 or later for time-series collections, and the time field must contain a BSON date. Julia DateTime values encode as BSON dates. See the MongoDB time-series guide.

   Verified against current master 179b73bedb20a5adc58521a26298bda9afb6852e, MongoDB 5.0.33 and libmongoc 1.30.8 on Linux, with Julia 1.6.7 and 1.13.1. All 20 checks pass on each runtime, including the created collection's options, insertion, date filtering and aggregation. Closing this usage question with the working API example.

   AI disclosure: This work was prepared with assistance from OpenAI Codex.
2. quinnj

   closed this as completedon Oct 4, 2026