Data module helps you model, manage and query related sets of tables. It offers an administration interface and a low level API for manipulating tables and accessing their contents. Data module provides Views integration for displaying table data and Drupal search integration for searching table content.

You can use Feeds to import RSS, Atom, CSV or OPML files into data tables.

The Data module provides

  • an API for dynamically allocating tables for single-row records.
  • an API for insert/update/delete operations and describing how tables join to each other.
  • automatic views integration.
  • a way to export table definitions to code.

The included Data UI module provides

  • UI to add new database tables.
  • UI to add or alter columns to existing tables managed by Data module.
  • UI to define joins between tables.
  • UI to solve conflicts between table in database and schema information.
  • default views for tables managed by Data module.
  • UI to add existing tables that are unclaimed by other modules to Data's table management.

Further, you can

  • Search specific table fields with the included Data Search module.
  • Relate table records to nodes with the included Data Node module.

You may want to

API

(to give an example, not complete)

// Get a table.
$table = data_get_table('my_table');

// If this table is not available create a table.
if (!$table) {
  $table = data_create_table('my_table', $schema).
}

// Save some data to it.
$table->handler()->save($data);

// Add a field to it.
$table->addField('newfield', $spec);

// Add an index to it.
$table->addIndex('newfield');

// Remove all data from the table.
$table->handler()->truncate();

// Destroy the table.
$table->drop();

New maintainers needed!

Downloads

Recommended releases

Version Downloads Date Links
7.x-1.0-alpha4 tar.gz (54.52 KB) | zip (76.19 KB) 2012-Nov-25 Notes
6.x-1.1 tar.gz (48.73 KB) | zip (67.3 KB) 2012-Mar-06 Notes

Development releases

Version Downloads Date Links
7.x-1.x-dev tar.gz (54.65 KB) | zip (76.32 KB) 2013-Mar-31 Notes
6.x-1.x-dev tar.gz (48.76 KB) | zip (67.33 KB) 2012-Mar-07 Notes

Project Information


Maintainers for Data

  • joachim - 54 commits
    last: 1 year ago, first: 1 year ago
  • alex_b - 212 commits
    last: 2 years ago, first: 3 years ago
  • Will White - 3 commits
    last: 3 years ago, first: 3 years ago
  • yhahn - 8 commits
    last: 3 years ago, first: 3 years ago
  • David Goode - 1 commit
    last: 3 years ago, first: 3 years ago

Issues for Data

To avoid duplicates, please search before submitting a new issue.
All issues
Bug reports
Statistics (2 years)
New issues
Open bugs
Participants
nobody click here