Did it tell you about Sequel Pro?

You can use it to connect to your local MAMP and also to remote LAMP mysql servers (via SSH). Why is this so awesome?

Well, not only is it 100 times faster than that phpMyAdmin, but you can edit your DB super easily, like a spreadsheet. It is a snap to filter/search/order a table for viewing and editing.

Caveat emptor: what I am about to show you can do tremendous damage. You can accidentally kill your entire application, so BACK YOUR DATABASES UP! Test on a copy first. Continue reading ‘Sequel Pro: look at the nerdy things I can do at 1 AM’

My presentation on Device Art and My Time for TEDxSoMa on January 22 has been put up online. The event was lots of fun and a great experience.

I’ve been told that the organizers that about 100,000 people tuned in to the live stream (though not simultaneously), which kinda turned upside down my whole perception of the event and my experience with audience.

Other artists in the presentation: Machiko Kusahara, Ryota Kuwakubo, Toshio Iwai, Theo Jansen, Sachiko Kodama, Maywa Denki.

I finally got around to putting together video documentation of the Off World installation!

Off World is a 24-hour, month-long interactive public installation part of the 2009 Contact Toronto Photography Festival. It is an exhibition of photographs and video by filmmaker Mateo Guez and commissioned by curator Sanaz Mazinani, realized in situ as a 24-hour interactive public installation by me, Andrew Mallis.

The exhibition ran all of May 2009 at CAMERA, an extension of the Stephen Bulger Gallery, located at 1028 Queen Street West, in Toronto, Canada.

the video is intended to be played vertically. Just tilt your head.

Using the Processing language, an image of da Vinci’s La Jaconde – the most reproduced image in the world – is corrupted over time. With each conversion between image formats, a frame is recorded. The title coyly references Marcel Duchamp’s 1919 readymade.

Continue reading ‘LHOOQ HD’

Users often require a limited set of stylistic controls over content on their site. We implement this in Drupal using the wysiwg module and TinyMCE.

Commonly, users need to create subheadings in their posts. Markup should always be privileged over wrapping content in classes. For example, it is much better, both from a structural and a maintenance perspective, to use an h2 tag to create a title, rather than adding a class of, say, .title to a paragraph tag, then forcing the paragraph to look like an h2. It will make a mess of your stylesheet, plus render your site less accessible to screen readers and search engines.

Continue reading ‘Configuring TinyMCE to handle a subset of styles’

Net Change is a week-long event designed to explore how social technology can bolster social change, presented by the Social Innovation Generation team at MaRS.

I heard about an art competition over email, entered, and ended up winning. I really don’t think they should have called it an “Art Show”, as it ended up being more of a branding experience for the event. Nevertheless, it was really nice to be associated with such a great event, many of whose participants are also my colleagues at the CSI.

Read about the art competition on netchangeweek.ca

Back ups are important. Like brushing your teeth, it’s something you should do routinely. And, as you’d brush before important events, like going out on a date, so should you too backup before upgrading software.

I’m going to show you how to use phpMyAdmin to back up and restore MySQL databases. In my next post, I’ll show you how to graduate to doing the same thing using the command line.

I use MAMP to develop websites locally. I’ve written about this before here. The examples I’ll be showing come from the phpMyAdmin packaged with MAMP, but apply just as well to any other environment. Continue reading ‘how to back up databases using phpMyAdmin’

There is a really prominent article about Off World in Eye this week that is quite favourable – honouring us with 4 stars. You can read it HERE.

Just in time for the closing party this Sat, May 30 7-9 @ Camera Bar. Come by one and all.

I put up a page of other press itemss on the offworld site; let me know if you spot anything else out there.

http://thespringweddingshow.com

An innovative project conceived as a walk in the park. (Pulling it off was another story). Working with Brooklyn-based designers Mélngerie, and Toronto-based animators 3Di, and featuring a soundscape by composer Nicholas Longstaff, the project is a time-limited online wedding tradeshow.

The interface promotes exploration and discovery by creating a whimsical lanscape, while simultaneously making quickly accessible information to those seeking it.

A Drupal 6 site with a  Flash-based front-end + Drupal back-end, featuring Lightbox2/Thickbox implementations. I’m proud of how un-drupal this drupal site is.

Screenshots don’t do this project justice. The innovative interface, and animations set this project apart. I’m going to try to post a video showing the site navigation soon.

Off World is an exhibition part of the 2009 Contact Toronto Photography Festival.

It is a street-level public installation that runs 24/7 during the month of May.

The project is the result of a collaboration between filmmaker Mateo Guez, myself, Sanaz Mazinani’s curatorial efforts via the Stephen Bulger Gallery, and with funding from Motorola Canada.

The installation features 11 looped videos playing on cell phones, accompanied by an illuminated text panel. While watching the videos, images are sent directly to your cell phone, either via Bluetooth or email.

It was very important to me that the technology not get in the way of experience the work, but rather enhance the user experience and deepen the reading of the work. The presentation is, formally, designed to provide an intimate experience in video viewing – highlighting the personal connection that we have with our mobile devices. The arrangement of the screens brings people shoulder to shoulder, in turn drawing onlookers who, in the act of waiting are presented with affordances that encourage them to read instructions for, and engage with, the interactive component of the piece.

Continue reading ‘Off World’

I’ve been working with the firm JMA Consulting for a good number of months now. The firm does a lot of work for non-profits in the areas of citizen engagement and relationship management. They do a lot of work for the Ontario NDP, and organizations in the environmental and educational fields too.

I’ve been doing work implementing and configuring  CiviCRM. Joe, the principal JMA, is on the advisory board, and many of his clients leverage this solution to manage their constituents.

I’ve also been doing a lot of sysadmin work: Linux server administration, Subversion repository managment, etc. Generally, I figure things out; make things work. I’m enjoying not being the lead on every project I work on, and it’s helping me achieve more balance in my life, I think.

I’ve been working with a really fantastic organization, Techsoup Canada, on helping them launch their new site. They do really amazing work connecting non-profits and Charities to technologies that they might otherwise not afford.

Techsoup Global was founded in 1987 by a couple of guys in a station wagon, who went around collecting all the freebee software sent to publication for review and re-allocating it to organizations in need. These robin hoods of silicon valley eventually grew the organization to the point where, in 2008, they were receiving annually tech donation worth 312$ Million.

The real beauty here is that Techsoup has become more than just a great enabler – connecting organizations to a myriad of corporate donation programs in a centrally administered repository. Their success has mad them an important advocate for the non-profit sector.

For years, Techsoup has served the needs of Canadian NGO’s and NFP’s through their San Francisco office. Establishing a Toronto base of operations will allow the organization to better administer the intricacies of Canadian donation programs, and to support the language needs of French Canada. Techsoup Canada is the result of a collaboration between the Centre for Social Innovation,  the Information Technology Association of Canada, and the Trillium Foundation.

Working on the website has posed numerous challenges. Namely, coordinating workflows between a development team in Poland, the San Fransico office, and Toronto. Drupal has always been challenged when facing the dev-staging-production workflow, but I haven’t faced butted up against it this much before. The Drupal community desperately needs to smartly seperate database content from configuration, and develop better logging and migration toolkits.

As of November, I’m a tenant at the Centre for Social Innovation, located at 215 Spadina Avene. It is a really great organization with which I’ve felt an affinity for a while now. After my residency at the CFC Media Lab, I decided to freelance, encapsulating my consultancy as the entity Ideograph. Working from home was nice for a while, but lonely.

I really love it here. The people are really, educated, and passionate. Some are dedicated to the solvency of our relationship with the environment, others committed to the realization of our political aspirations as citizens. Humanitarians, scholars, do-gooders unite!

The CSI is an open-concept work environment. We share amenities, and through proximity that is the result of space planning, ideas. I continue to work with many another tenants, and am stimulated and validated in the work that I do daily.

As an art-maker, it is challenging enough finding the right motivation to face the void out of which summon my creations. The network I am a part of at CSI has helped structure more the business side of my identity. That isn’t to say that Andrew Mallis the artist is never present at the CSI. Indeed, there are many arts organizations present in the space, and even a few CFC grads too.

Amenities are great. Meeting rooms, kitchen, mailbox: I like. I even more so enjoy the bicycle parking in the basement and the rooftop garden.

MYTIME was recently featured on SPACETV’s The Circuit. Many people have reported difficulty viewing the show online, so I’ve pulled the stream down and re-encoded it here for convenience. You can download the video in .mov format or watch it here.

[display_podcast]

theRetailSaver.com was built and deployed on Drupal 5.x. When I started development, I think Drupal was at 5.4, but with the flurry of recent updates, we’re up to 5.10 as of this writing.

The site is a business listings site, intended to partner with a mail print product put out by Exposure Marketing Solutions. Listing pages incorporate google Maps, a Lightbox photo gallery. The site makes heavy use of hook_form_alter via a custom module.

The basic content type is a business listing, to which can be attached one or multiple coupons. Coupons can be printed individually and brought into the stores. A listing can be sold as a “featured business”, thereby appearing in the sidebar, and at the top of search results.

Anonymous users can submit a basic listing. The site admin is then notified to approve the listing, and can offer the client a photo or video gallery, or featured business for a fee. Businesses awaiting approval appear in a custom block for the site admin, to facilitate editing.

The site makes heavy use of imagefield and imagecache – two modules that aren’t yet production-ready for Drupal 6.

modules used:
nodewords, globalredirect, update_status, forward, ad, xmlsitemap, workflow_ng, workflow, views_fastsearch, views, token, tinymce, theretailsaver, suggestedterms, site_map, relativity, print, phone, pathauto, nodeteaser, mimedetect, location, link, lightbox2, jstools, jquery_update, javascript_aggregator, imce, imagefield, imagecache, imageapi, google_analytics, gmap, filefield, embedded video field, email, diff, date, countries_api, contemplate, cck, admin_menu, action