Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Sure, Drupal is suited for data-centric websites. <a href="http://developmentseed.org/" rel="nofollow">Development Seed</a> is a company that <a href="http://developmentseed.org/sectors/open-source-drupal" rel="nofollow">use Drupal</a> and make data-centric websites but they also use other technologies such as Node.JS. As suggested by Marek Sebera, it really depends on your actual needs and what exactly your site will be doing with the data.</p> <p>You basically have two ways to integrate your data into Drupal. One is to import the data into Drupal as <a href="http://drupal.org/glossary#entity" rel="nofollow">entities</a> (a generic concept for anything data in Drupal 7) or <a href="http://drupal.org/glossary#node" rel="nofollow">nodes</a> (a concrete concept for anything <em>content</em> in Drupal). The other is to directly query an external data source from Drupal.</p> <p>To import data, the <a href="http://drupal.org/project/feeds" rel="nofollow">Feeds</a> module is a very solid and flexible solution. Out of the box it <em>only</em> supports CSV, Atom and RSS from local files or HTTP. But it is flexible and extensible and there is already many <a href="http://drupal.org/node/856644" rel="nofollow">contributed modules</a> that extends it.</p> <p>To query the data, both external or imported, you can use the <a href="http://drupal.org/project/views" rel="nofollow">Views</a> module to build query pages. For external data source support, you will need <a href="http://drupal.org/search/apachesolr_multisitesearch/views%20backend?filters=ss_meta_type%3amodule" rel="nofollow">additional <em>backends</em> modules</a> and probably have to write your own.</p> <p>If you import the data as entities, you can also uses the <em>core</em>'s <a href="http://api.drupal.org/api/drupal/includes--entity.inc/class/EntityFieldQuery/7" rel="nofollow">EntityFieldQuery</a> to write your own query without using Views. And you can also uses the <a href="http://drupal.org/project/search_api" rel="nofollow">Search API</a> to index the imported data using a search engine such a <a href="http://lucene.apache.org/solr/" rel="nofollow">Apache Solr</a>. </p>
    singulars
    1. This table or related slice is empty.
    1. POIs a CMS like Drupal or WordPress appropriate for a basic data-centric web application?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USPierre Buyle
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs a CMS like Drupal or WordPress appropriate for a basic data-centric web application?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks. This tells me a lot about how I would go about doing it, and also tells me that I may be best off building it as a custom application, since there is a lot of the Drupal infrastructure that the development will have to support that I won't really be using. Thanks for an insightful response.
      singulars
      1. PO
      1. USEv Conrad
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload