26 Modules match your search

Extend and customize Drupal functionality with contributed modules. If a module doesn't quite do what you want it to do, if you find a bug or have a suggestion, then join forces and help the module maintainer. Or, share your own by starting a new module.

Drupal 7 driver for SQL Server and SQL Azure

sql-server.png

Drupal 7 driver for Microsoft SQL Server database engines. It supports both SQL Server (version 2008 and later), and SQL Azure, part of Microsoft Azure cloud platform.

Installation instructions

Installation instructions are available as part of the release notes.

Sponsors

This work is supported by Commerce Guys, provider of innovative ecommerce solutions for Drupal.

Downloads

Forena Reports

Forena is database report writing software built on the Drupal platform. Forena is built of the idea that if you can write the SQL necessary to get the data out of a database, it should take very little work to get that data out on the web. It is designed to leverage knowledge of HTML, CSS, SQL and Java Script to help you create rich interactive web reports.

Features

The current version allows you to create reports using SQL from Drupal, or using data stored in XML files.

It comes bundled with a couple of sample reports reports that will both demonstrate how reports are created, and provide useful information on your existing Drupal site.

Some key features include:

  • Create custom reports from your Drupal database.
  • Create reports against PDO supported database (SQLite, MySQL, MS SQL, etc).
  • Create reports against any Oracle database.
  • Create charts in SVG format.
  • Export data to CSV, EXCEL or XML versions of reports.
  • Create and edit HTML reports using a simple web UI (includes WYSIWYG editor support).

Downloads

DBTNG Migrator

One of the most exciting new features about Drupal 7 is the object orientated database layer, or Database: The Next Generation (DBTNG) as it was code named. For the first time in Drupal's history, you can now connect to several different databases of different server types at the same time. All using Drupal's database framework.

Downloads

MongoDB

MongoDB integration for Drupal. This is a collection of several modules which allow sites to store different types of Drupal data in MongoDB.

Downloads

EntityFieldQuery Extra Fields

Warning : This module abuses EntityFieldQuery to return data from your database. It does not work with entities or any modules that build on them.

It allows you to use addField within an EntityFieldQueryExtraFields object (extends EntityFieldQuery objects). Initially EntityFieldQuery only gives you back the entity id, bundle and entity type. This module adds an extra layer on top of that without doing some extra entity_loads! Important if you want to work with massive amounts of data and you want to reduce the sql queries. Since EFQ already queries the database for this information, why not alter that query to also give you some additional fields. This means that not a single extra query will be performed to get that data.

A word of caution, if you rely on some post-formatting/post-loading that happens in entity_load or similar functions, this module won't take care of that. You have to ensure the validity of the retrieved data yourselves.

Example

Fetching the node title


$query = new EntityFieldQueryExtraFields();
$result = $query->entityCondition('entity_type', 'node')
->propertyCondition('type', 'my_bundle_type')
->propertyCondition('status', 1)
->addExtraField('field_myfield', value', value')
->addExtraField('field_mynodereffield', nid', nid')
->addExtraField('', 'title', 'title', 'node')

Downloads

Oracle driver

This is a driver that allows Drupal to use an Oracle Database (http://www.oracle.com/database/product_editions.html) instead of MySQL as the primary backend.

To create drupal nodes in a MySQL backend from Oracle tables you should use somenthing like http://drupal.org/project/migrate project, which is a robust data migration solution.

Eventually you can even store your site "files" directory inside Oracle with this module:
http://oranfs.sourceforge.net/ (let's say to have Oracle RMAN backup all your user data or
to search on it with the Oracle Text engine) or even use http://drupal.org/project/storage_api to implement an oracle backend for file storage.

A drupal_api PL/SQL package is also available to write/read drupal 6.x nodes and CCK fields, from PL/SQL procedures. You can write things like:


declare
v_node
begin
v_node:= drupal_api.new_node(p_title => 'Lorem ipsum',
p_type => 'my_news_ct',
p_body => 'lorem......',
p_language => 'en');

drupal_api.set_node_field(v_node,'publish_from_date', sysdate);

for news in (select * from table(drupal_api.get_nodes_by_type('my_news_ct'))) loop

if drupal_api.get_node_dat_field(news,'publish_from_date') < sysdate then

.... do whaterver ....

Downloads

Asynchronous Prefetch Database Query Cache

A pretty darn quick cache. Uses asynchronous connections & prefetching to speed up cache calls & eliminate deadlocks & metadata locks on the cache tables. Only MySQL currently.

Downloads

dbinfo

What this Module does for you:

DBinfo adds a small status report item to the /admin/status/reports page of your Drupal website.

DBinfo tells you the database connection information for any configured databases Drupal has connection info for. Optionally, it can test the connection on status report page load.

Requirements

This module requires Ctools in order to generate the collapsible reports.

As a security precaution the db password always displays as [omitted] from the report page.

Downloads

FileMaker

FileMaker module for Drupal logo

The filemaker module lets you build FileMaker web applications through Drupal.

Version 7 Features

  • Create, find, browse, and edit modes
  • Rich set of permissions
  • Choice of interface for anonymous users
  • Dynamic default values in find and create mode
  • Integration with actions and triggers
  • Support for most types of FileMaker value lists
  • Unlimited number of reusable connections to FileMaker database

Version 7 Requirements (FileMaker)

Version 7 Dependencies (Drupal)

  • Libraries module

Version 6 Features

  • Create, find, browse, and edit modes
  • Rich set of permissions
  • Choice of interface for anonymous users
  • Dynamic default values in find and create mode
  • Integration with actions and triggers
  • Integration with tokens
  • Support for FileMaker portals
  • FileMaker scripts - cron, triggers, and custom buttons
  • Support for all types of FileMaker value lists
  • Unlimited number of reusable connections to FileMaker database

Version 6 Requirements (FileMaker)

    Downloads

    Mongo Entity

    Overview

    Mongo Entity provides developers with entity and controller classes for storing entities entirely in a MongoDB collection. It eliminates the need for a base table, or any SQL queries at all; an entity's ID, name, properties, and any field data are all written directly to MongoDB. It also provides classes for embedded entities: entities that are stored as subdocuments in a parent collection, but that can be managed using the standard Entity API CRUD methods, as well as found with EntityFieldQuery. Ultimately, loading a parent entity should automatically load and embed all its child entities, with only one query to a single MongoDB collection.

    Mongo Entity is for developers. It provides no interface, nor does it alter the behavior of existings sites out of the box. Modules can use the provided MongoEntity and MongoEntityController classes in hook_entity_info to store entities in MongoDB, rather than a SQL database.

    Features

    • Minimal configuration. Save custom Entities entirely in automatically generated MongoDB collections. No SQL tables needed.
    • Performance boost. Field data is stored with the Entity in MongoDB, reducing the need for complex JOINs and multiple database queries to load a single object.

    Downloads

    Doctrine Object Relational Mapper

    This module is a set of base component and connectors to integrate Doctrine ORM with Drupal Core. The Doctrine Object Relational Mapper sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL.

    http://www.doctrine-project.org/projects/orm.html

    This module provides integration with Doctrine ORM, giving developers a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication.

    Designed with a few goal in mind:

    • Maintainability: the software will evolves with the Doctrine library and with versions of Drupal, the code base is written to cope with a changed environment. Test suit is the same quality as the software itself, allowing the isolation of defect for further correction and ensure new requirements will not break anything, thus, making future maintenance easier.
    • Dependability: it does what it claims, and is trustworthy. The code is optimized to run for limited resources computers with special care to cache optimizations or any form of I/O which are costly.

    Downloads

    DBTables

    Description
    This module allows the user to have a look to Drupal database tables of contents.
    Quite often we need to carry quick check on database, for example to see if the data have already been stored in tables; this module will be handy to have to that purpose.

    Features
    - Allows to look at the schema of each table of the Drupal db.
    - Allows to look at the content of each table of the Drupal db.

    Requirements
    This module doesn't require any other module to be enabled.

    Downloads

    CouchDB Integration

    The CouchDB module provides API access to any Couch Database. The API exposes a majority of the Database, Document, Design and Views API. The CouchDB module when enabled does not do anything. It provides a library to build additional functionality or applications.

    The couchdb_watchdog module is a sample implementation of using Drupal with CouchDB.

    Please help solidify the development release into a full 7.x release by logging issues and testing the module out.

    Downloads

    Collation Fixer

    A 'runtime' requirements checker (admin/reports/status) for checking all database tables have the right database collation (probably very MySQL centric).

    Offers the ability to fix tables with wrong database collation.

    Downloads

    Ming (a MongoDB wrapper)

    Drupal 8
    This module has been converted into a general PHP library called Vultan, and will not be released as a module for Drupal 8.

    Vultan is available on Packagist, and can be added to Drupal via Composer:
    https://packagist.org/packages/xtfer/vultan

    Drupal 7

    Ming is an API for working with data in MongoDB. It was designed to allow rapid construction of MongoDB-based apps in Drupal, where Field integration is not required.

    Ming is a wrapper around the PHP Mongo classes, which adds some additional capabilities and behaviours. In addition to what raw Mongo support provides, Ming has the following features:

    • Preconfigure and connect to multiple persistent connections, from multiple Mongo database sources, using hooks, site variables, at runtime, or from the Mongodb module
    • Simple wrappers around common Mongo tasks (Insert, Upsert, Delete, Find), including some common variants
    • Shortcuts for accessing objects by MongoID, without the need to instantiate MongoID classes
    • A scaffold class (ming\Ming\Item) for building, saving and working with MongoDB data

    Ming does not require the Mongodb module to be installed, but will work with it.

    Downloads

    SQLite Booster

    This module can speed up any drupal installation that uses the SQLite database driver. It has no effect on other database drivers so if you migrate databases and forget this module, nothing will happen.

    Usage

    You can just enable and forget this module.

    Background

    The speedup is done by wrapping the whole request in one transaction, so the database file will only be written once. Of course this blocks the database for the whole request, but SQLite is not suitable for several concurrent requests anyway.

    Downloads

    SQLite Vacuum

    When using a SQLite database, the database file can get fragmented and grow far beyond the actual data size. This module checks if the currend database is SQLite and then VACUUMs it every 3 hours.
    On a configuration page you can...

    • change this interval
    • switch automatic vacuum off
    • trigger manual vacuum

    Downloads

    OSF for Drupal

    OSF for Drupal

    The Open Semantic Framework (OSF) for Drupal is a middleware layer that allows structured data (RDF) and associated vocabularies (ontologies) to "drive" tailored tools and data displays within Drupal. The basic OSF for Drupal modules provide two types of capabilities. First, there are a series of connector modules such as OSF Entities, OSF SearchAPI, OSF Field Storage and OSF Views to integrate an OSF instance into Drupal's core APIs. Second, there is a series of module tools used to administer all of these capabilities.

    By using OSF for Drupal, you may create, read, update and delete any kind of content in a OSF instance. You may also search, browse, import and export structured datasets from an OSF instance.

    OSF for Drupal connects to the underlying structured (RDF) data via the separately available OSF Web services. OSF Web Services is a mostly RESTful Web services layer that also allows multiple Drupal installations to share and collaborate structured data with one another via user access rights and privileges to registered datasets. Collaboration networks may be established directly to distributed OSF Web Services servers, also allowing non-Drupal installations to participate in the network.

    Downloads

    Riak Field Storage

    The Riak Field Storage module stores fields in a Riak database. EntityFieldQuery is not yet implemented.

    Downloads

    Couchbase

    The Couchbase module provides integration with Couchbase 2.0 and above. This module
    consists of helper functions to instantiate couchbase connections from the $conf['couchbase']
    variable in settings.php.

    The module also provides a REST interface to Management REST API provided by Couchbase.
    The Management REST API is described here

    Finally, the module provides an api for accessing creating and deleting Couchbase Views.
    *These functions will probably go away once the php-ext-couchbase matures. Currently, the php-ext-couchbase library doesn't support creating/deleting views.*

    The module couchbase_watchdog is an example implementation of watchdog in Couchbase.
    It serves as an example of what can be done with the API.

    Since Couchbase 2.0 is in active development, this module will not see a stable release until such time.

    Please help test and report bugs back

    The couchbase_watchdog module is a sample implementation of using Drupal with Couchbase.

    Please help solidify the development release into a full 7.x release by logging issues and testing the module out.

    Downloads

    MongoDB Spaces Overrides

    Spaces Overrides mongodb storage backend for high performance and scalability of large spaces-enabled sites.

    Large (>100k records) spaces_overrides tables in MySQL perform slowly (even with optimal indexes) and performance appears to be O(n). In MongoDB, with minimal indexes, spaces_override queries are 1-2 orders of magnitude faster than MySQL (>100k records) and performance appears to be approximately O(1).

    Development of this module is sponsored by AllPlayers.com.

    Downloads

    pdo_oci

    Drupal 7.x pdo_oci driver supported with simpletest.

    Downloads

    DBLIB driver for SQL Server

    This driver is a fork of sqlsrv, it's pretty much similar except for using dblib rather than sqlsrv driver, which could be handy if Drupal is installed on a *nix environment.

    Downloads

    PostgreSQL User Signature

    Module administration interface

    Overview

    The Postgres Signature module making all database connections and queries "personalized". If you have not only default database user but also SQL users with the names as Drupal users, all requests would be performed with corresponding SQL-user name.

    Queries from user #1 and from anonymous users authored by default connection string.

    Adding and removing Drupal users also leads to do the same on database level.

    On administration pages there is a functional to create (or delete) in bulk SQL users to reflect existing Drupal users.

    Downloads

    Orbital Cache Nuke

    orbital_cache_nuke
    Dependencies

    Autoslave

    Version / Author
    1.0 Justin Slattery Justin.Slattery@mlssoccer.com

    Description
    This module allows asynchronous remote cache invalidation between replicated Drupal environments. Available for Drupal 7.

    See this blog post for details on how it works and integration.

    Downloads

    Pages