New in C Turtle

sql_database: database_interface | student_database

Stack Summary

Provides an easy way to use SQL databases from the ROS environment.

• Author: Maintained by Matei Ciocarlie
• License: BSD
• Repository: wg-ros-pkg
• Source: svn https://code.ros.org/svn/wg-ros-pkg/stacks/sql_database/trunk

Documentation

Stack details

This stack contains:

• database_interface: a general interface for using SQL database from inside C++ code, in a way that makes it easy to encapsulate the conceptual "objects" contained in the database as C++ classes. See the package documentation for details and tutorials.

• household_objects_database: implementation of this interface for a specific database. Such implementations are usually very thin, and contain:

  • C++ class definitions for the objects stored in the database
  • (optional) convenience functions for queries commonly executed on the specific database, as very thin wrappers around the general versions found in the database interface;
  • wrappers around some of the most commonly used data processing functions exposing them through ROS topics or services.

Supported SQL databases

The current release provides an interface with PostgreSQL database. However, most of the code is in place to support sqlite database as well. This feature will probably be added in a future release.

Database releases

Specific releases of ROS stacks, containing algorithms that process a certain type of data, can be accompanied by versioned database releases containing the data itself. As an example, a release might contain:

• tabletop_object_detector 0.4: a ROS package with code for recognizing objects using a database of 3D shapes
• household_objects_database 0.2: the database itself, in PostgreSQL format
• database_interface 0.5: the interface for accessing the database from the code (also as a ROS package)

We believe that this model will enable:

• sharing of datasets along with code
• consistency between code versions and data versions
• flexibility when using, extending or modifying somebody else's data

Tutorials

Report a Bug

Use trac to report bugs or request features. [View active tickets]