rosbag2_storage_sqlite3

Storage implementation plugin for rosbag2 providing SQLite3 .db3 files as the bag storage backend.

Storage Configuration File

The --storage-config-file option for this plugin takes files in the following format:

read:
  pragmas: <list of SQLite pragma settings for read-only>
write:
  pragmas: <list of SQLite pragma settings for write modes>

By default, SQLite settings are significantly optimized for performance. This might have consequences of bag data being corrupted after an application or system-level crash. This consideration only applies to current bagfile in case bag splitting is on (through --max-bag-* parameters). If increased crash-caused corruption resistance is necessary, use resilient option for --storage-preset-profile setting.

Settings are fully exposed to the user and should be applied with understanding. Please refer to documentation of pragmas.

An example configuration file could look like this:

write:
  pragmas: ["journal_mode = MEMORY", "synchronous = OFF", "schema.cache_size = 1000", "schema.page_size = 4096"]

Changelog for package rosbag2_storage_default_plugins

0.26.7 (2025-04-22)

0.26.6 (2024-12-18)

0.26.5 (2024-09-06)

• Fix incorrect zero size for sqlite storage (#1759) (#1761) Co-authored-by: Michael Orlov <<michael.orlov@apex.ai>> (cherry picked from commit 86f681d9f525a4b7c3b4133d6b657e342283aad8) Co-authored-by: Roman <<rsokolkov@gmail.com>>
• Fix for failing throws_on_invalid_pragma_in_config_file on Windows (#1742) (#1746) (cherry picked from commit 055935d33dd2fed2772657c9dc1f2173eaa7f752) Co-authored-by: Michael Orlov <<michael.orlov@apex.ai>>
• Contributors: mergify[bot]

0.26.4 (2024-06-27)

• Add topics with zero message counts to the SQLiteStorage::get_metadata(). (#1725) (#1731) Co-authored-by: Michael Orlov <<michael.orlov@apex.ai>> Co-authored-by: Tomoya Fujita <<Tomoya.Fujita@sony.com>>
• Contributors: mergify[bot]

0.26.3 (2024-05-15)

0.26.2 (2024-04-24)

0.26.1 (2024-04-17)

0.26.0 (2024-04-16)

• Support service 2/2 --- rosbag2 service play (#1481)
• Use middleware send and receive timestamps from message_info during recording (#1531)
• Update to use yaml-cpp version 0.8.0. (#1605)
• Contributors: Barry Xu, Chris Lalancette, jmachowinski, Michael Orlov

0.25.0 (2024-03-27)

• Make some changes for newer versions of uncrustify. (#1578)
• Add topic_id returned by storage to the TopicMetadata (#1538)
• Remove rcpputils::fs dependencies from rosbag2_storages (#1558)
• Change an incorrect TSA annotation. (#1552)
• Improve performance in SqliteStorage::get_bagfile_size() (#1516)
• Update rosbag2_storage_sqlite3 to C++17. (#1501)
• Use enum values for offered_qos_profiles in code and string names in serialized metadata (#1476)
• Stop inheriting from std::iterator. (#1424)
• Contributors: Chris Lalancette, Michael Orlov, Patrick Roncagliolo, Roman Sokolkov

0.24.0 (2023-07-11)

• Implement storing and loading ROS_DISTRO from metadata.yaml and mcap files (#1241)
• Store metadata in db3 file (#1294)
• Contributors: Emerson Knapp, Michael Orlov

0.23.0 (2023-04-28)

0.22.0 (2023-04-18)

• Add type_hash in MessageDefinition struct (#1296)
• Store message definitions in SQLite3 storage plugin (#1293)
• Add message definition read API (#1292)
• rosbag2_storage: add type description hash to topic metadata (#1272)
• Contributors: Michael Orlov, james-rms

0.21.0 (2023-04-12)

• rosbag2_cpp: move local message definition source out of MCAP plugin (#1265)
• Update rosbag2 to C++17. (#1238)
• Use target_link_libraries instead of ament_target_dependencies (#1202)

File truncated at 100 lines see the full file