Data
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
- check out Feeds module for using Data as a storage engine for RSS/Atom feed data.
- know how Data relates to Table Wizard
- know that Data module is the successor of Flatstore.
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();