Database

This group should probably have more organizers. See documentation on this recommendation.

This is a working group for those involved in the development and extension of Drupal's Next Generation database abstraction layer, including the Schema API and the development of new database drivers.

Please remember to read the documentation for the Database API. It will likely be helpful to review the PDO documentation as well.

Big Data Drupal: Cloudera Hadoop, MapReduce, Nutch, Solr, Aegir BOA, Drupal 7 ApacheSolr Views

Posted by niccolox on October 4, 2013 at 5:37pm

I am giving a talk at Badcamp on Big Data Drupal: Cloudera Hadoop, MapReduce, Nutch, Solr, Aegir BOA, Drupal 7 ApacheSolr Views

http://2013.badcamp.net/sessions/big-data-drupal-cloudera-hadoop-mapredu...

I am trying to gather some other experts i.e. Cloudera / Hadoop / MapReduce + HyperDrupal + Twig etc to come and handle the bigger and deeper questions

https://drupal.org/node/2104503
https://groups.google.com/a/cloudera.org/forum/#!topic/cdh-user/Uwuj1q7bWBY

Forms, schemas and DB transactions

Posted by ken205726 on October 8, 2012 at 7:36pm

I have gradually built up my knowledge of how to do stuff in Drupal and have virtually always started the wrong way. Eventually a light bulb goes on and I get an idea of the power of the Drupal framework and API's.

I have just created my first db table in a module and am about to build forms to handle add, modify, delete datbase records and then I am struck.

I have just defined my table in a schema. I can write a piece of code to create basic forms from my schema with basic a/m/d transactions and then I can tweek if necessary.

Connect the SQL or Oracle database

Posted by vbose on May 30, 2012 at 11:05am

Hi Team,

I want to know about that can I connect my site of different Database like Oracle or Sql. So what is the procedure of it and how could I connected it?

Calendar with footer, using data from another content type.

Posted by mtg.nampa.net on February 16, 2012 at 1:13am

Making a calendar of events. In the footer section, adding in a view of another content type which uses the 'Inherit contextual filters'.

I can 'Preview with contextual filters' and everything works great.
In the real window, the view in the footer never changes. It's like the contextual information never gets passed to the footer.

Any ideas would be greatly appreciated.

Thanks, MTG

Include date formatting and conversion routines into Database Abstraction Layer

Posted by d.novikov on November 25, 2011 at 3:37pm

In Drupal 7, as it supports different databases, modules which run queries containing date conversions and comparisons (Views, Date and others) face with bugs connected to different SQL syntax (partially I see a number of problems with MSSQL). Date functions are also a part of SQL and I think they should not be handled by modules. We need a kind of date abstraction layer within database drivers, which will contain date formatting, conversion, and extraction routines. I don't know if current DB layer can be changed too much, but this idea can become a roadmap for Drupal 8.

Database development prior to MySQL

Posted by aaron1948 on September 28, 2011 at 7:20am

I am seeking advice about what might be the best database program to use to create a large pre-MySQL database, from which I will select the content to export/import/enter into a Drupal MySQL database.

I am developing my first Drupal site -- a web portal where information will be organized by relevance to various generations. The site will launch with a Baby Boomer orientation, with information organized for various baby boomer niches, and then expand to serve more generational niches.

How to use SELECT in a SELECT?

Posted by MrHaroldA on August 16, 2011 at 6:42pm

I have a tested and working query that I need to convert to the new Drupal 7 database layer, but I can't seem to find how to use a nested SELECT...

I need to join the MAX() value of last_totalcount to all rows in node_counter and this should be the way to do that:

SELECT nc.nid AS nid, nc.totalcount AS totalcount, last_totalcount AS last_totalcount

FROM node_counter nc, (
  SELECT max(last_totalcount) AS last_totalcount, nid 
  FROM node_counter_history GROUP BY nid
) AS tbl

WHERE nc.timestamp >= 1309471200 AND tbl.nid = nc.nid

New to Drupal, just want to create and use a database (table) on various pages with a single page to edit data

Posted by mtg.nampa.net on August 15, 2011 at 11:11pm

I'm new to Drupal. Sorry, if I'm in the wrong group, but I'm looking for the best direction.

I want to create a database table, edit from a single list, but display results on various pages. I've done various database programming before. Drupal has so many modules to choose from, and many do similar things.

I'm just a bit overwhelmed by the variety of directions I could proceed. I'm looking for opinions about modules suited to my needs.

    Thanks in advance, MTG

merge and select from, incomplete or incompetent?

Posted by mixel on May 7, 2011 at 2:29pm

While converting my exercises from Drupal 6 to 7 I've tried to stay loyal to the new DB-abstraction layer. One of the exercises has some advanced mysql. In an attempt to make this query work, I've encountered several issues that make me question if I've discovered some incompleteness in the DB-abstraction layer or if I'm incompetent and do not understanding the DB-abstraction layer.

Slave support in D7

Posted by ctoomey on March 12, 2011 at 8:56pm

I'm an architect working on a project to rebuild our current consumer site, possibly using Drupal, and am new to Drupal and learning as much as I can as fast as I can. I see that one of the things that's been added in D7 is support for master/slave DB configurations, so I wanted to get more info. about that.

Looking for Group for Drupal 7 and Microsoft SQL Server

Posted by bg1 on March 9, 2011 at 9:04pm

I am looking for a group or just others interested in using MSSQL Svr with Drupal (especially Drupal 7).

I am NOT necessarily wanting to run Drupal on Windows. I want to leave Drupal on its own server under Linux but store the data in SQL Svr on its own Windows server.

Is this group the appropriate group for such discussion? If not, where might I find people interested in such discussion.

NVARCHAR Support in Drupal?

Posted by Captain Nemo on February 17, 2011 at 10:40pm

Hi.

Complete n00b here, working from a technical documentation perspective. Drupal lets me store data in a db and display it (or turn it to PDF for printing); that's fine. However, it is imperative that large chunks of data (XML tagged UETF-8 Unicode) can be easily stored and retrieved from my Drupal database. There are two parts to what I must be sure of:

1) Unicode support (CJK, Arabic, etc. must be possible for our customers)

Drupal does this, fine.

New Group: Drupal 7 on Windows

Posted by brian.travis on February 2, 2011 at 3:03pm

I created this group to see what kind of interest there is in running Drupal 7 on a Windows environment. There is already a group to dedicated to Drupal on IIS, which has a good following of people interested in getting Drupal running under Microsoft's Internet Information Servier. The group is mostly focused on Drupal 6, and has some good content.

I wanted a group to discuss the specific issues around running Drupal 7 on Windows, particularly the use of Microsoft's SQL Server as a replacement for MySQL. This is made possible by the work done by a team at Microsoft that wrote a driver for SQL Server, and then packaged up the whole thing as an installable item.

Need help on database access, problem solved.

Posted by color on January 16, 2011 at 11:21pm

Our website need to read one type of nodes body directly for high performance. The code is as following:
include("opendatabase.php");
$result = mysql_query ("SELECT body FROM node_revisions WHERE uid = 1 AND title = 'test1' LIMIT 1 ");
$row = mysql_fetch_assoc ($result);
print_r ($row["body"]);

mysql_close();

It doesn't run drupal_bootstrap. It has no relation with the drupal except read its database table.

Wherefore static queries?

Posted by brian.travis on November 12, 2010 at 11:01pm

The TNG database layer has the concept of static and dynamic queries. Insert, update, delete, and merge queries must be dynamic, which is great because it provides an abstraction from writing SQL statements, allowing the layer to create the proper SQL that goes to the database engine. However, the database abstraction layer for Drupal 7 allows select statements to be dynamic or static.

I'm writing a book on Drupal 7 for Windows developers, and I see a potential problem with allowing people to write static queries. That is, they may not be transportable across different engines.

CouchDB

Posted by maury on April 4, 2010 at 5:48pm

What is the status of couchdb?

From what I read about it I love the concept. Unfortunately though I cannot find any groups oriented around couchdb and wonder if it is still evolving. How are users liking it.

I want to create a series of books and other related products and love the potential non linear flexibility of couchdb which I read about. I am not a programmer though and would love to learn more about how this db is actually being used and what it will take to start using it.

Using information from another database for drupal user management

Posted by t14 on September 30, 2009 at 9:12am

I was wondering is there a way to make use of information on another database to create user accounts.

I have a database with all my clients information already stored and I want to avoid duplicating the information on my Drupal database and I also want to take advantage of all the funtionality already available with Drupal user management.

All ideas and suggestions are welcome.

Thank you all for your time

What to do with slaves?

Posted by Crell on September 27, 2009 at 10:11pm

So this conversation hasn't happened yet, but it really really needs to. We have this nice and shiny new slave server support in Drupal 7, but we are not using it. That means we need to go through and flag which queries are "Slave safe", that is, are able to use a slave server if one is available without breaking stuff.

Oracle Driver for 7.x

Posted by aaaristo on July 19, 2009 at 6:30pm

Hi all,
i'm happy to say that today i closed the last odd test cases (http://drupal.org/node/464514), and that the 7.x driver for oracle looks working.
It would be very nice if someone wants to help with it to make it work even better / faster. My poor PHP skills makes the code ugly probably, and may be some of you can contribute some ideas to support a wider variety of SQL statements or to remove/improve some Regular Expressions.

The actual state is pretty difficult to explain because i worked on the driver almost for the last year in "free time" so excuse me if do not remember all the points. I'll use this post as a T.O.C. http://drupal.org/node/39260#comment-1124563:

Oracle support and O.R.M.

Posted by aaaristo on June 24, 2009 at 5:00pm

Hi all,
i'am one of the guys who is triyng to build an oracle driver for drupal.... (http://drupal.org/project/oracle)
I actually wrote 2 drivers: 1 for the 6.x and 1 for the 7.x. Both based on PDO_OCI, and both working pretty
well with the core, (i'am still working on the 7.x SimpleTest test cases but 90% is ok).

I started using the 6.x driver in production on February (when it was on sourceforge.net as drupaloracle).

A couple of days a go, one of my company web developers, told me:

"Hey.. we should use this X module.... It is cool!"

Subscribe with RSS