Roy Gunawan, Yogyakarta, Drupal 7 Release Party 7 January 2011
WHAT IS DRUPAL?
Drupal is a free CMS written in PHP that allows
anyone to easily publish, manage and organize a common CMS since it also a framework capable software developed by community.
wide variety of content on a website. It not just a
WHAT IS DRUPAL?
Drupal is a free CMS written in PHP that allows
anyone to easily publish, manage and organize a
wide variety of content on a website. It not just a common CMS since it also a framework capable software developed by community.
WHAT IS DRUPAL?
Drupal ...is as much a Social Software Platform as it is a web content management system. -CMS Watch, The Web CMS Report 2009
An estimated 7.2 million sites used Drupal as of July 2010
527,548 people in 228 countries speaking 182 languages
7,441 Modules
911 Themes
HISTORY OF DRUPAL
Originally written by Dries Buytaert
dorp (Dutch for village)
Miss-typed In Dutch
drop
druppel
English
Pronunciation
Drupal
WHO IS MAKING IT HAPPEN
Your name here >
WHO IS USING DRUPAL
WHO IS USING DRUPAL
And THOUSANDS More!!! Including YOUR site!
Drupal Vocabularies
Node/ Content Content Type Taxonomy/ Vocabulary Block Module
The Ideas Behind Drupal 7
Fix things that always annoy you Add features that take Drupal Integrate useful contributed World domination!
to the next level
modules
Drupal 7 features
Easier to use More Flexible More Scalable Open Source
Usability
Contextual links Admin & Shortcut bar Dashboard Overlay Drag and drop Administrator role Vertical tabs
Tool bar/ Admin menu
User Short Cut bar
The quick link
Admin menu short cut and
Dashboard
Overlay
Also notice the Action Link
More Usability
Vertical Tabs
Contextual Link
Modules
Install modules and themes directly
Even modules update
Fields in content
Fields in user account
Fields in taxonomy
Fields Everywhere!
Multi Language Support
Local Start-up? Yes, please
Set you language detection
Multi Language Support
Import from community Easy and powerful
interface to manage
Multi Language Support
Contributors
Half there, we need more! Join
http://localize.drupal.org/translate/languages/id
Images!
Images!
Public & Private Files
S3? Flicker? No problemo!
Geek Stuff Alert!
THE NEXT GENERATION
DATABASE
The Next Generation
PHP Data Objects (PDO) database layer Support for ANY database! Built in support :
MySQL
SQLite
PostGreSQL
Including NoSQL!
Dynamic Query builder Transaction Support Master/ Slave replication
Static Select Queries
Direct SQL query:
<?php SELECTn.nid,n.title,n.createdFROMnodenWHEREn.uid= $uidLIMIT0,10; ?>
Drupal 7:
$result=db_query_range('SELECTn.nid,n.title,n.created FROM{node}nWHEREn.uid=:uid',0,10,array(':uid' =>$uid)); foreach($resultas$record){ //Performoperationson$node>title,etc.here. }
Dynamic Select Queries
Drupal 6: $result=pager_query(db_rewrite_sql('SELECTn.nidFROM {node}n WHEREn.promote=1ANDn.status=1ORDERBYn.sticky DESC, n.createdDESC'),variable_get('default_nodes_main',10)); Drupal 7: $select=db_select('node','n') >fields('n',array('nid')) >condition('promote',1) >condition('status',1) >orderBy('sticky','DESC') >orderBy('created','DESC') >extend('PagerDefault') >limit(variable_get('default_nodes_main',10)) >addTag('node_access');
Other Queries
Insert
$nid = db_insert('node') ->fields(array('title', 'uid')) ->values(array( 'title' => 'Example', 'uid' => 1, )) ->execute();
Delete
$num_deleted = db_delete('node') ->condition('nid', 5) ->execute();
Update
$num_updated = db_update('node') ->fields(array( 'uid' => 5, 'status' => 1, )) ->condition('created', REQUEST_TIME - 3600, '>=') ->execute();
Roles & Permissions
Need moderator? Just add it Then set what their do's and don'ts
More Geek Stuff...
WYSIWYG support Better performance Pluggable cache system RDF Simple test
What's next
Dries: RT @chx1975: WordPress is now approximately where Drupal was around Drupal 5 w/ content types. See you in 2015.
Dries: Agreed, and fair enough. RT @newoceans_en: @Dries Drupal 7 will hopefully be where WordPress was around 5 years ago regarding UX.
Drupal 7
Easier and more powerful then ever
Question?
This slides is inspired by : Angela webchick Byron, Drupalcon DC March 4, 2009 Gbor Hojtsy, DrupalCamp Prague November 1, 2009