23 Apr '12, 12pm

5 subtle ways you’re using MySQL as a queue, and why it’ll bite you | Engine Yard Blog

Finally, it’s also really easy to avoid the one-big-table syndrome. Just create a separate table for new emails, and when you’re done processing them, INSERT them into long-term storage and then DELETE them from the queue table. The table of new emails will typically stay very small and operations on it will be fast. And if you do the INSERT before the DELETE, and use INSERT IGNORE or REPLACE, you don’t even need to worry about using a transaction across the two tables, in case your app crashes between. That further reduces locking and other overhead. If you fail to execute the DELETE, you can just have a regular cleanup task retry and purge the orphaned row. (Hmm, sounds like another job queue, no?) You can do much the same thing for any type of queue. For example, articles or comments that are pending approval can go into a separate table. This is really required on a la...

Full article: http://www.engineyard.com/blog/2011/5-subtle-ways-youre-u...

Tweets

#cra

engineyard.com 22 Apr '12, 8am

A life coach can help with many areas of your life and improve your psychological well-being. Perhaps you are at a crossro...

5 Creative Ways to Connect Our Kids (And Yourself) to Nature

5 Creative Ways to Connect Our Kids (And Yourse...

treehugger.com 23 Apr '12, 9am

This is a guest post from Richard Louv, author of The Nature Principle: Reconnecting to Life in a Virtual World and Last C...

RailsCasts Episode 344: Queue Classic

railscasts.com 24 Apr '12, 7am

PostgreSQL can act as a worker queue which can replace the need for a separate process to manage the background jobs. Here...

The 5 Most Easy And Cheapest Ways To Get From S...

angryangmo.com 26 Apr '12, 12pm

- Get your ferry tickets, the operator is “Blue Water Express “, from their little sales counter just in front of the main...

Compiling Ruby: From Text to Bytecode | Engine ...

engineyard.com 21 Apr '12, 10am

The business of executing Ruby code is booming; with so many Ruby environments in development, there are just as many diff...

JS Interjection | Engine Yard Blog

engineyard.com 17 Apr '12, 10pm

Attending the JS Summit a couple of weeks ago here in San Francisco was a blast! I met many very smart people and came bac...

5 “Local” Search Engines You Should Be Targeting

5 “Local” Search Engines You Should Be Targeting

searchengineland.com 23 Apr '12, 5pm

We usually hyperfocus on Google Place search and Maps results, since they have such large market share. But there are good...

5 Ways to Speed Up Your Rails App | Union Station:

engineyard.com 02 May '12, 4am

Ruby is a fast language, and a great one in so many ways, but nothing in this world is truly free. It’s very easy to do th...

4 Ways to Help Consumers Discover Your Mobile App

4 Ways to Help Consumers Discover Your Mobile App

searchenginewatch.com 23 Apr '12, 9am

There are nearly 1 million apps available in the app store and 1 billion of them are being downloaded every month. This ma...

New in Rails Edge: Queue

rubyflow.com 28 Apr '12, 9am

New in Rails Edge: Queue Posted by oscardb on April 28, 2012 — 0 comments I'm launching a new rails edge series, here's th...

Lie detector using Arduino

Lie detector using Arduino

arduino.cc 24 Apr '12, 10am

The next time you want to find out which of your little cousins ate the cookie from your jar, you can use your Arduino and...

via twiterfee Chef | Engine Yard Ruby on Rails ...

engineyard.com 15 Apr '12, 10am

Yesterday we announced Engine Yard Solo which is our new Engine Yard on AWS platform. If you haven’t yet watched the scree...

Control your dreams using DIY goggles

Control your dreams using DIY goggles

arduino.cc 24 Apr '12, 12pm

Control your dreams using DIY goggles Lucid dream is a state in which you can control what you dream. Be it winning a mill...

5 Microblogging Sites That Aren’t Twitter:

searchengineland.com 21 Apr '12, 5am

While Twitter is getting the lion’s share of all the social media and micro-blogging sites from the press and the blogosph...

5 Ways to Reuse or Recycle Yoga Mats | Care2 Healthy Living

5 Ways to Reuse or Recycle Yoga Mats | Care2 He...

care2.com 21 Apr '12, 11pm

By Jill Lawson for DietsInReview.com It is estimated that more than 15 million people practice yoga. While 15 million seem...