Enterprise

This group provides an area to share information about Drupal in the enterprise. Areas for discussion might include the integration of Drupal with traditional enterprise applications such as ERP and CRM; the use of Drupal as an enterprise web content framework; Drupal's place within the enterprise architecture; or even the use of Drupal as an enterprise architecture tool.

Other Drupal groups of interest to the enterprise include High Performance and Best Practices in Security.

Arto's picture

Potential RDF use cases for Drupal

Following up on my previous post introducing the in-progress RDF API for Drupal 6.x, I'm going to be, bit by bit, posting some of the materials that I've earlier put together internally for the project this is being developed for. Development of this project is supported through M.C. Dean and MakaluMedia on behalf of their clients.

Read more
hswong3i's picture

Some review and proposal about Drupal 7.x database stack

I start my Drupal + Oracle research since the end of Drupal 4.7 life cycle (around Oct 2006), based on my client's request. The project is still running, but I am not satisfy about its progress. After keep trace in Drupal database stack implementation for more than years, it is time for focusing on Drupal 7.x development.

So what are the changes since 4.7.x? And what will be happened for 7.x? I would like to share my research progress with you, and so let's brain storming for what's next :-)

Read more
hswong3i's picture

DB support as contribute: is it a good idea?

Abstract

Drupal 6.0 is revamped with Schema API, so what's next for Drupal 7.x? PDO for sure! With this powerful data-access abstraction layer, workload will much reduced for DB abstraction layer designers and developers, and finally benefit our contribute developers and end users.

By the way, together with the decision of Drupal 7.x + PDO, there is also some voice about moving PostgreSQL (and so other potential databases support, e.g. Oracle, DB2, MSSQL, etc) support away from core, but contribute; on the other hand, add official SQLite support into Drupal core, together with MySQL.

Is this really a good idea? Or even if it is possible? As an existing Drupal + PostgreSQL users, what will this affect your daily work? As a potential customer of Drupal + Oracle/DB2/MSSQL/etc, is this a good new for you, or just an evil? I would like to provide some brief idea for you within this article.

Read more
ChrisBryant's picture

Boston Drupalcon showcase and case study contest

Cross posting from here: http://drupal.org/node/219476

There will be a Drupal site showcase and case study contest at the upcoming Boston Drupalcon.

Submitted sites will be voted online and judged by a panel of community nominated judges and some great prizes will be awarded to the winners! This is a chance to have all your hard work creating amazing Drupal sites recognized.

Read more

Issues Need Review for Enhance Cross Database Compatibility

Enhance cross database compatibility is important for our Drupal Core, especially when we are going to ship D7 with PHP5.2.x PDO implementation. BTW, this will require number of individual patches, so your help and review are required - add it to the top list with a brief description and an estimate of the time to review. Once reviewed, move the issues to the bottom "reviewed" list, perhaps with your name attached.

Read more
hswong3i's picture

My personal battle target for Druapl 7.x

My primary battle plan should be enhance Drupal cross database compatibility. I have involved in this topic for around a year, and I would like to keep it on going. To accomplish this target, I would like to complete the following tasks before D7 code freeze:

<

ul>

  • Improve Database API for better abstraction

    Something should be done before any other targets, e.g. resolve reserved words conflict, split drivers into individual files for better management, indeed but simple abstraction for different database syntax, add INSERT/UPDATE/DELETE abstraction and enhance drupal_write_record() abstraction, etc. With a better common base for multiple database development, we will need much less time to study the differences between databases than that of before.

  • Add PHP PDO supporting

    Shipping D7 with PHP PDO should be a spotlight topic, since it is now official package for PHP5.2.x, and legacy drivers will soon be removed in PHP6.x. We may need some cleanup in our core query syntax, in order to let PDO get works.

  • Introduce more database backend

    Up to this point, I would like to introduce some other database backend for D7, e.g. <a href="http://drupal.org/node/39260'>Oracle, SQLite, IBM DB2 and also MSSQL. If we are able to support SQLite in D7, which also means we are going to standardize our core queries into SQL92 standard, the problem for maintain multiple database backend should no longer a critical problem; if we are able to support Oracle, the most complicated database I guess, this should no longer a problem for us to implement drivers for other databases.

  • I have summarize most of my personal battle targets in here. Most logic are proved as functioning, and they are all get set for the open of D7 public development. On the other hand, I would like to explore if this may integrate with other interest musings with Data API, so we will able get all stuff better in D7 ;-)

    jwhatcott-gdo's picture

    Time to Give Back: Become a Speaker at Drupalcon Boston 2008

    Hello,

    We are looking for speakers for the upcoming DrupalCon in Boston. Since you are subscribed to a business and marketing related group, you might be especially interested in the "Business and Marketing" track (see http://boston2008.drupalcon.org/business-and-marketing-track-descriptions ).

    This track covers the following topics:

    • The Drupal ecosystem
    • Businesses learning to use Drupal
    • Case studies
    • Showcases: NPO, Education, News, Media, Government, Healthcare
    Read more
    Souvent22's picture

    PHP 5.2.5 breaks SQL Server support; Yet MSFT SQL Driver Works

    So, I've had some free time latley, and I've started back on the database API layers (DB2 and SQL Server currently).
    However, I have found 2 disturbing issues.

    Overview
    First, I'm currently exploring the following 3 ways to connect to sql server:
    1. FreeTDS
    2. php_mssql driver
    3. MSFT SQL Driver ( See pcorbetts posting for a link to the driver )

    1. PHP 5.2.5 breaks support for SQL Server
    Read more
    pcorbett's picture

    Obstacles For Real SQL Server Support

    There are some major issues, in my opinion, that are preventing MSSQL from being fully supported in PHP and thus Drupal. Most, if not all, of these revolve around the terribly outdated DBLIB library - forcing some to use alternative libraries (FreeTDS or the recently released SQL Server Driver for PHP). I want to get this out in the open so that we may address them appropriately. I have run into these myself and have had to do some creative work-arounds to get Drupal to behave the way I need it to while running on SQL Server.

    Read more
    greggles's picture

    RFC: Best practices for managing indexes (particularly on cck tables)

    As a site goes live and we do performance tweaking and benchmarking one of the common results is adding database indexes. I post this into the CCK group since one of the common sources of slow queries is for queries against the CCK tables. For example, a site that has a block that queries a field table to look for information about that field for every page load can quickly make its way into the slow query log. Adding an index to the field is likely to be the best solution.

    Read more
    pcorbett's picture

    Suggested Method For Choosing Between SQL Server 2000 and 2005/2008

    I have been working to get SQL Server 2000 to work with Drupal 5.3. Everything seems to be working except for a small pagination issue. As part of this, I have been prepping it for use with 2005/2008 as well, but wanted to share with the group to see if we should agree upon a common way to distinguish between different versions (since syntax and functions vary so much between them). I am assuming that there will be differences between 2005 and 2008 that we may have to account for, so this doesn't have to be 2000 vs. 2005-specific.

    Read more
    pcorbett's picture

    New Windows SQL Server Driver for PHP

    A new SQL Server 2000/2005 driver (preview version) for PHP improves compatibility between the two: http://www.microsoft.com/sql/technologies/php/default.mspx

    Now there's native support for PHP that will save us from having to deal with freeTDS and other things. For example, the current limitation between PHP and SQL Server is that it truncates text pulled from a varchar to 255 characters. I currently have to change anything > varchar(255) to a TEXT datatype in SQL Server to avoid this issue.

    Has anyone else used this in their SQL Server setup?

    pcorbett's picture

    New FastCGI extension for IIS

    A new IIS 6/7 FastCGI extension was recently released: http://www.iis.net/downloads/default.aspx?tabid=34&g=6&i=1521 It runs on top of ISAPI and generally makes PHP within IIS more stable. Has anyone tried installing this yet? Any noticeable performance boost? I'll be setting it up soon and will reply with my own opinion soon...

    Database Equivalency Chart (please edit)

    This table lists equivalent functions, queries, etc. necessary to properly convert Drupal queries and .install files between MySQL and SQL Server 2000/2005/2008

    <

    table title="Database Equivalency Table">

    Database Equivalency Table MySQL MSSQL 2000 MSSQL 2005 MSSQL 2008 SHOW TABLES SELECT name FROM sysobjects WHERE xtype = 'U' Read more
    ChrisBryant's picture

    Popular, high profile, high traffic Drupal sites for BADCAMP and Drupal.org

    I'm cross posting this from here in case anyone else has any information to share: http://drupal.org/node/187464

    Hi Fellow Drupalers,
    I'm working on a session for BADCAMP (http://badcamp07.org) where we will walk through some cool, popular and high performance Drupal sites. The main focus here is high-profile, big companies, high traffic. What is the biggest and highest traffic Drupal site out there?

    Read more

    Examples of corporate sites for Case Studies

    hswong3i's picture

    Ready for Testing: New DB2 Driver for Drupal

    After 4 days (!?) development, a new DB2 driver for Drupal 6.x is now ready for testing. It takes IBM's D5 DB2 implementation as base reference, and reuse almost all Oracle driver for Drupal 6.x progress for overcoming DB2-specific limitations.

    Read more
    hswong3i's picture

    Ready for Testing: New Oracle Driver for Drupal

    After over 1.5 years of development (since 29/11, 2005), plus number of developers contribution, and help of Drupal 6.x schema API, a new Oracle driver for Drupal 6.x is now ready for testing.

    The latest version of Oracle driver overcome a lot of Oracle-specific limitation, and able to work well as like as existing Drupal database driver, e.g. MySQL and PgSQL.

    Read more
    mymaestro's picture

    Anybody done a w3 theme?

    Now that we have GSA and Bluehost available, has anybody done a "w3 standards" theme for internal sites using Drupal?

    Want to?

    allisterbeharry's picture

    How can I help out with MSSQL driver?

    I'm a MCDBA/MCSD and I don't want to get rusty with MSSQL - I'd like to contribute to the mssql driver development in Drupal- I have a pretty good knowledge of SQL Server 2000 (a modest amount of 2005 too) and data access layers like OLE DB. How can I help out?

    Subscribe with RSS Syndicate content

    Enterprise

    Group organizers

    Group events

    Add to calendar

    Group notifications

    This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

    Hot content this week