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.
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.Read more
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.
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.Read more
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.Read more
Job Title: Software Engineer II (Drupal)
Requisition Number: ISS-3383
Requirements: Candidate MUST be able to obtain at least a US DoD SECRET clearance.
The primary skills required are analytical skills. Other important skills include administrative, communication, leadership, and problem solving skills, and short term and long term planning skills. Ideal candidate will possess skills in detailed analysis or have a lessons learned operations background, preferably both. Candidate needs to have experience in development and maintenance of databases.Read more
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
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
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.Read more
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.Read more
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.Read more
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.Read more
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.Read more
Our website need to read one type of nodes body directly for high performance. The code is as following:
$result = mysql_query ("SELECT
uid = 1 AND
title = 'test1' LIMIT 1 ");
$row = mysql_fetch_assoc ($result);
It doesn't run drupal_bootstrap. It has no relation with the drupal except read its database table.Read more
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.Read more
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.Read more
I am looking for help on a Drupal project and I found your contact information on the web. I am looking for data import and synchronization help specifically. The project involves real estate data, here are some of the requirements.
• Migrate a text or csv file of new data once per day.
• Data fields will map to the fields in the content type cck.
o The fields are text, integers, floats and dates.
• Run an update to remove old rows based on either the ‘status’ or the fact that the row is missing from the daily file, indicating it is no longer available.
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
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.Read more
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:Read more