45 minutes

Overview
The MySQL Server is a very widely used open source database system and often used as the storage backend for Drupal sites.
Creating backups and maintaining a secure installations are two very common tasks for any Drupal administrator.

In this talk, Lenz will provide useful hints and suggestions on how to improve the security of a MySQL installation and how to properly perform backups of the databases and tables. The session will cover both tools that are included in the MySQL server/distribution as well as common tools/facilities provided by the operating system (Linux in particular).

Agenda

• Improving MySQL Server security
  • On the server side
  • On the OS level
• MySQL Backup methods
  • Logical
  • Physical

Goals
Users attending this session should take home some useful hints on how to secure their MySQL installations and how to perform proper backup.

Overview

iwanttospeak.net is a worldwide language learning community. From the initial idea to its beta launch only a few weeks passed. This shows Drupals power and flexibility in "rapid prototyping". The goals were: Possible support of all world languages (managed by the community itself), Private messages, Custom User Profiles, easy but failsafe geographical tagging of users for a worldwide proximity search, ...

Agenda

* Rapid Prototyping to speed up developement
* Customizing Themes and Modules
* Multilingual support
* Geotagging of Users and worldwide proximity search
* Usability improvements

Goals

During this session we want to share our experience using Drupals army of contributed modules for „rapid prototyping“. We also would like to discuss, which contributed modules are essential for developing websites with Drupal. We think that knowing a number of contributed „keymodules“ is absolutely essential for developing websites with Drupal.

We will show how we used the Bio module for collecting all user related information during the registration process and storing this information as nodes.

A key feature of iwanttospeak.net is the worldwide proximity search for users. We will show how we used Googles API for the geospatial information and how we use this information to calculate the distance between users worldwide.

iwanttospeak.net is currently available in 9 languages (including Russian, Hungarian, German, Italian). All translations were contributed by members of the iwanttospeak.net language community with little technical knowledge and no Drupal experience. We will demonstrate how we used i18n module and a slightly modified version of the Localization client Module to let users directly translate the interface.

Resources

www.iwanttospeak.net

Overview

Drupal 7 will feature a newly rewritten database layer providing improved database abstraction, portability, and scalability features. This session will cover the thinking and architecture behind the new layer, with an eye toward understanding how it fits into the larger scheme of high-performance Drupal sites. There will be some discussion of code, as well as words of advice for others looking to revamp one of Drupal's core systems.

There will be some code in this session, but you should not need to be a hard-core coder to follow it. This session will also serve as a lead-in to this code track session, which is aimed more at programmers.

Agenda

* Database abstraction: Why it's hard and even an unsolvable problem.
* The old Drupal approach, and why it's not good.
* The new Drupal approach, and why it's awesome.
* Leveraging the database on your own deployments.
* Request for feedback on some of the more big-iron-targeted parts of the new feature set.
* Recommendations for other core developers on how to (not) revamp Drupal subsystems.

Goals

After attending this session, you should have a good idea of ways to leverage the new, modernized database system for your own sites as well as how to go about making major changes to Drupal's infrastructure.

Resources

Knowing the basics of SQL servers before attending would be a good idea, for context.

Overview

I am planning on heading up a documentation sprint during the August 31 "code" sprint. I'd like to get like-minded folks together to help organize for sprint day so we can make sure there are clear tasks to be done and that we have resources to help people get started. This planning session is open to EVERYONE interested in helping with documentation.

Agenda
- Make a list of groups of docs tasks that people can choose from according to their interests.
- Get volunteers to help out. ;-)
- Figure out how to coordinate the live sprint with an online sprint so folks that aren't there can pitch in too.

Note to organizers: if this could be scheduled earlier in the week rather than later, that would be great.

Overview:

Imagefield Gallery is a module that's been around since shortly before Drupalcon Boston. I created it with the intent of making gallery management for an existing site easy for single nodes. Since that time others have used it for their own sites, and have extended it to work with proprietary gallery types that have not been contributed back. I would like very much to introduce the drupal community at large to imagefield gallery and encourage them to help develop it in a direction that could be beneficial for ALL of drupal, not just a small subset.

As stated above, imagefield gallery's primary purpose is to create galleries on a node from an existing imagefield. The new 2.x version cleans up the admin, and is striving to squash some old bugs, and add new features. In development is the ability to do node references, as well as a new gallery type. Imagefield Gallery makes creating new gallery types pretty easy and straight-forward. These gallery types are re-usable in a large number of instances and allow the site administrator to customize gallery types per content type.

Agenda

• Current Capabilities
• What I'd like to see donated by the community
• What about D6?
• What could the future hold?

Goals

Ultimately the objective of this session is to introduce Drupal at large to the Imagefield Gallery module, and show them what it can do for them. With some help I believe imagefield gallery can fill a significant void in the current Drupal codescape and give Drupal a varied and significant gallery system upon which to draw.

Resources

Project Page:
http://drupal.org/project/imagefield_gallery

Development/News Blog:
http://www.worxco.com/blog-categories/imagefieldgallery

UPDATE: The knitting charts have been uploaded to the internets! Finally! More info at: Drupal Knitting Charts.

Crafters, show thyself! I'm sure there are lots of crafters in the Drupal community. Pack your crafts and bring them to DrupalCon! Want to learn how to knit? Of course you do! Want to learn how to knit The Drupal Socks?! zOMG YES! This BoF will teach craft wannabes how to embellish just about any piece of fabric with simple hand stitching techniques. It will also be useful to knitters and crocheters who want to know the secret of The Socks. No experience required!

Y'know...The Drupal Socks:

(now walkah's socks.)

Ask the group about:
- colour-work in knitting (useful for making socks)
- colour-work in crochet (useful for making Drupal toys)
- applique (cut and sew fabric)
- duplicate stitching, cross stitch and embroidery (stitching colour onto fabric)

The materials, as requested by a craft newbie...

The simple list of materials:
Szeged has 180,000 people. It will have at least one yarn shop. Bring money, we will find you materials and support the local economy. It will be a beautiful thing.

Complicated list of materials:
Yarn is good for knitting and crochet. You will also need pointy things to expertly tie the yarn into intentional knot^H^H^H stitches. If you want to knit you will need "needles" if you want to crochet you will need "a hook." Go to the place where they sell yarn. Choose the right colours (suggestions below). Look at the paper wrapper on the yarn. It will tell you the size of pointy things you need for that particular yarn. If you want to start with a simple scarf or toque* project, choose thicker yarn and corresponding thicker needles. If you're ready to launch into socks choose a thinner yarn (fingering or sport for normal socks; or worsted for super thick bed socks). Socks are typically knit as tubes. You will need "double pointed needles" or "circular needles." Ask your local yarn shop for suggestions.

Internet-solutions
If you (think you) don't have a local yarn store, here is information for purchasing yarn on-line. The Original Drupal Socks were made from three different yarns: "Gems Sport Weight" by Louet in Cream, Caribbean Blue and Neptune. You will need one of each (I had less than 5 yards left of the Carribean Blue, you might want to buy two units of the darker blue to be on the safe side). These can be ordered on-line from:
http://www.shopatron.com/index/378.0.10974.20411.0.0.0
If the price of yarn makes you very afraid, you should also try Knit Picks. It looks like their Swish Worsted Yarn in Deep Ocean and Capri might be a good match. Don't forget the natural white too! You will also need to get needles. This can be overwhelming. I knit The Drupal Socks on 3mm (US size 2) double pointed needles. If you are buying worsted weight yarn you probably want 4mm needles (US size 6). Ping me if you need more help choosing needles.

If you are interested in cross stitch and cuss words, I recommend getting one of the deluxe kits from: http://www.subversivecrossstitch.com/ You will not get the right shades of blue from this Web site. Chances are very good there is somewhere in your town to buy "embroidery floss." I will also bring some extra with me if you ask nicely.

If you are interested in embroidery (a little more free-form than cross stitch): http://sublimestitching.com/lapetitekit.html Also buy up some t-shirt stabilizer if you want to embroider Druplicon onto a t-shirt. http://sublimestitching.com/tools.html You will not get the right shades of blue from this Web site. Chances are very good there is somewhere in your town to buy "embroidery floss." I will also bring some extra with me if you ask nicely.

Interested in quilting? Me too. If you're even remotely interested in sewing the chances are good you already know where you can buy fabric supplies....ping me if you need more help on this one.

If you are flying (especially from North America): DO NOT PUT SCISSORS IN YOUR CARRY-ON! They will be taken from you. Knitting needles and crochet hooks are fine within North America, but I don't know about Hungary. Please check with your airline.

* toque: a Canadian winter hat

PS I make no apologies for the amount of craft supplies you will purchase over the rest of your lifetime now that you're addicted to crafts. While I'm pretty sure it is slightly cheaper than buying crack, I can't actually confirm this is true.

Making a Digg/Reddit/Propeller clone with drupal

Today user submitted story sites are very popular.some examples are digg/reddit/propeller etc.In this session i am going to show how to create such site with using drupal and available modules.

Agenda

* Architecure of social site.
* How to use drupal?
* Available modules.
* Customization of modules to achieve the needed functionality.

Goals

In the end attendee will have knowledge on drupal and its module which a user can use to build such sites and can create their own.

Resources

none.

Overview

This is a round-table session, gathering those who are interested in collaborating on a Drupal Certification program.
As Drupal grows, the need for Drupal training grows as well, and so - more companies offer Drupal training and courses.
Training people to Drupal, has many benefits:

• It helps customers make a better use of their websites or Drupal-based web applications
• It increases the offer of Drupal savvys in the jobs market, whether as webmasters, developers or designers
• It creates another channel for people to get to know Drupal, and as such... (see next bullet)
• It helps the community grow

It is important therefore, that all those who are involved in this area, collaborate, in order to achieve a coherent, collaborative Drupal training curriculum. There is an ongoing effort to achieve that on g.d.o, but it doesn't prove to be the right platform. In this round table we will try to find the best way for us to collaborate and share over this matter.

Agenda

Some key issues that will be discussed (not necessarily in this order):

• What is a Drupal certification at all? Can there be ONE certification?
• Who is allowed to certify anyone to Drupal?
• What are the implications of not collaborating over a certification program?
• Does the Drupal association have to take the control over certifications?
• What impact will Acquia's certification program have on other Drupal training programs? (see this discussion on g.d.o.)
• How should the collaborative platform look like? How should it behave?

See this g.d.o. wiki page for more background (feel free to participate): Associations, ideas, and possible questions, that comes to your mind, when talking about...

Goals

At the end of the session we should have a clearer picture about the Drupal's certification program, and about the ways to achieve collaboration from all those who are involved in the area.

Resources

Here (Szeged 2008 related sessions)

• The Alexandria Project (seems to have dropped)

Groups.Drupal.Org

• Curriculum and Training group
• A brainstorming wiki page in preparation on this session
• Drupal training syllabus
• What impact Acquia new Training and Certification project will have on Drupal community ? (comments are interesting)

Acquia.com

• Yellow Jersey
• A skeptic plans a certification program
• A Certification Success Story

Overview

Drupal is often compared with other CMS products, but the true power of the platform is realised when you compare with web application development frameworks. Drupal, as a set of APIs, is a viable choice as a framework for developing powerful web apps.

Agenda

* Web Framework features overview
* Drupal APIs and Modules for Web Application development
* Case studies: present two web apps developed using Drupal

Goals

Explore Drupal as a framework for Web Application development with a couple of Case Studies.

Overview

The Knight Drupal Initiative (KDI) is an ongoing, open grant funding process for the Drupal open source project. We want to enable more people to enter the digital conversation by lowering the technical barriers to entry. We will provide powerful tools for digital publication, free and open to all. Our goal is to encourage people to improve their communities by supporting the free exchange of information and ideas.

Agenda

* Introduction to the KDI
* Program goals
* How to apply for a grant
* How you can help the KDI
* Project brainstorming and questions

Goals

We want everyone to participate in the KDI, in order to increase funding for the goals of the Drupal project. This session will let you know how you can get involved.

Resources

* KDI group
* Frequently asked questions
* KDI flyer [pdf]