Home

MySQL

MySQL

The most widely used open source SQL product

 

Bike Temple

Tue, 06/29/2010 - 12:13pm — hunter
http://www.bike-temple.org
Launch Date(s): 
Jun 7 2010

Bike Temple is a University-wide program to promote bicycle use by Temple students, faculty, and staff.  The overall goal of the program is to enable more people to travel on a bike and to do so safely, to build a great bike culture at Temple that supports the University’s commitment to sustainability and reputation for innovative, green programs. 

This project was an end-to-end effort.  I came in and worked with the stakeholders to create a long run vision for the site. Some of the duties included:

  • Information Architecture
  • Work with student workers to develop a graphical theme
  • Implement the graphics on Drupal
  • Implement all features
  • Setup a LAMP stack.
    • Memcache
    • Varnish
    • APC
    • PHP 5.2
    • MySQL 5.1
More features to come.

Migrate from SMF Forum to Drupal

Sun, 02/14/2010 - 8:48pm — hunter

Recently I needed to do a migration from the Simple Machines Forum (SMF) to the Drupal Native Forum. I think most people by this point have heard of Drupal, and if you're reading this, chances are you're in a similar situation. If you want to migrate from SMF to Drupal, there is no direct route beyond writing your own Migration software from scratch in PHP. In this project I'm migrating from a Bridged Joomla and SMF site that has roughly 16,000 posts and about 1100 users.

Acquia: Best Practices for Scaling Drupal

Thu, 01/21/2010 - 8:49pm — hunter

This is a fantastic primer for scaling LAMP architecture.

 

Wysiyg API and Input_formats quick start

Sun, 01/17/2010 - 2:15pm — hunter 

-- phpMyAdmin SQL Dump

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `chrihu3_port112209`
--

-- --------------------------------------------------------

--
-- Table structure for table `filters`
--

DROP TABLE IF EXISTS `filters`;
CREATE TABLE IF NOT EXISTS `filters` (
  `fid` int(11) NOT NULL auto_increment,
  `format` int(11) NOT NULL default '0',
  `module` varchar(64) NOT NULL default '',
  `delta` tinyint(4) NOT NULL default '0',
  `weight` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`

{syntaxhighlighter brush: css;fontsize: 100; first-line: 1; }-- phpMyAdmin SQL Dump SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `chrihu3_port112209` -- -- -------------------------------------------------------- -- -- Table structure for table `filters` -- DROP TABLE IF EXISTS `filters`; CREATE TABLE IF NOT EXISTS `filters` ( `fid` int(11) NOT NULL auto_increment, `format` int(11) NOT NULL default '0', `module` varchar(64) NOT NULL default '', `delta` tinyint(4) NOT NULL default '0', `weight` tinyint(4) NOT NULL default '0', PRIMARY KEY (`fid

Some imagacache presets

Sun, 01/17/2010 - 1:58pm — hunter

I use the following SQL to get some quick presets up and rolling.  I know this can be cleaner, but it works for many smaller sites I do.  Just dump this into an SQL statement in Phpmyadmin or from the command line.

Syndicate content