There is a great article that shows how all of the Acquia sites are architected. In that article, it is mentioned that Services is used quite a bit to power REST endpoints. Here is a really, really, useful tidbit that I don't want to forget which comes from that article.

"Feeds Crawler is a Feeds fetcher plugin for paging through a site or a feed. It is useful for building powerful web scrapers using Feeds"

Schedule a time when a particular revision should go live.

Edit 2013 Aug 26: This may have recently been solved in core. Anyone know?

Have you ever had the contextual links overlap? Here's a quick fix. It probably works for other themes but, for the record, I did this on the Poultry theme, a Zen subtheme (used in RedHen CRM).

See: http://dev.mysql.com/doc/refman/5.0/en/group-by-extensions.html

Do a SELECT with a GROUP BY clause. Let's say name is the column you want to find duplicates in:

Here's how to use Apache's rewrite rules to serve files from a remote server. This comes in handy when you have a large /sites/*/files directory. There are modules that can do this (Stage File Proxy) and probably a million other solutions but this one is simple and efficient.

Sometimes it's necessary to get data from databases other than the default. Here's an example of how I do a simple SELECT query on the non-default database named 'MyOtherDb'.

Here's a couple of classes that I wrote to connect and retrieve an array of file paths, names, and sizes from a Windows FTP server. There is high npath/cyclomatic complexity in getFileList() but it is left that way for easy reading of code and for performance, as this method may run (recursively) thousands or more times per request, depending on how many files and directories exist.

Lets you use tokens to embed video and have the ability to add a button to the WYSIWYG for easily adding a video (for those to0 lazy to type).

This is by far the coolest and easiest way to do complex migrations. Once you learn this, you will be able to migrate just about anything into Drupal including old Drupal sites where using the core updater doesn't work right because of whatever complexity the old site had.

Soon, I'll be writing up an article on using this great module... For now, here's an article that I found which is a great read for anyone who may need to use this