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.18.0 (2022-11-15)

• ros2bag: move storage preset validation to sqlite3 plugin (#1135)
• Move sqlite3 storage implementation to rosbag2_storage_sqlite3 package (#1113)
• Contributors: Emerson Knapp, james-rms

0.17.0 (2022-07-30)

• Use a single variable for evaluating the filter regex (#1053)
• Renamed --topics-regex to --regex and -e in Player class to be consistent with Recorder (#1045)
• Added support for filtering topics via regular expressions on Playback (#1034)
• Contributors: Esteve Fernandez

0.16.0 (2022-05-11)

0.15.1 (2022-04-06)

0.15.0 (2022-04-05)

0.14.1 (2022-03-29)

• Bump version number to avoid conflict
• Contributors: Chris Lalancette

0.14.0 (2022-03-29)

• Install headers to include/\${PROJECT_NAME} (#958)
• Contributors: Shane Loretz

0.13.0 (2022-01-13)

• Emit a warning rather than crash when a message is too big for sqlite (#919)
• Contributors: William Woodall

0.12.0 (2021-12-17)

• Enable YAML encoding/decoding for RecordOptions and StorageOptions (#916)
• Contributors: Emerson Knapp

0.11.0 (2021-11-08)

• Update package maintainers (#899)
• Contributors: Michel Hidalgo

0.10.1 (2021-10-22)

0.10.0 (2021-10-19)

• added seek interface (#836)
• Contributors: sonia

0.9.0 (2021-05-17)

0.8.0 (2021-04-19)

• Remove -Werror from builds, enable it in Action CI (#722)
• Explicitly add emersonknapp as maintainer (#692)
• Reindexer core (#641) Add a new C++ Reindexer class for reconstructing metadata from bags that are missing it.
• Contributors: Emerson Knapp, jhdcs

0.7.0 (2021-03-18)

0.6.0 (2021-02-01)

• Fix build issues when rosbag2_storage is binary installed (#585)
• Mutex protection for db writing and stl collections in writer & storage (#603)
• SQLite storage optimized by default (#568)
• Contributors: Adam D