Saturday, July 11, 2015

IFTTT Service descriptions with Google Search

Disclaimer: pure hack,  don't judge on my coding skills ;)

I have been trying to make use of some channels in IFTTT, and obviously the channel doesn't say what each logo means, just wrote some code to pull up all the service names in IFTTT

and came up with google search for each descriptions

IFTTT service listing in chrome console:

var sm=new Array();$.each($('.channel-grid-item__title'),function(){sm.push($(this).html());})

They have IFTTT may be useful feed, but as I said pure hack this is.

Gist to generate your own:

Here is the list,

Amazon Echo: Always Ready, Connected, and Fast.:Echo connects to Alexa, a cloud-based voice service, to provide information, answer questions, play music, read the news, check sports scores or the weather,  ...

11 Tips to Boost Your Android Phone's Battery Life | 1, 2014 ... But there's much more to poor battery life results than that. Fortunately, there's plenty you can do to stem the flow of juice from your Android ...

Beeminder:Answer with your number when Beeminder asks — or connect a device/app below to auto-report — and we'll show your progress and a Yellow Brick Road to  ... Recipes, Menus, Cooking Articles & Food Guides:Recipes from Gourmet and Bon Appetit plus web only content and a recipe archive.

GE Appliances - Kitchen Appliances, Refrigerator, Dishwasher:The official site of GE Appliances - offering information on our full appliance line including our Energy Star qualified appliances, stainless steel options, service ...

Inoreader - The content reader for power users who want to save time.:Inoreader is the content reader built especially for power users who want to save time. Using a content reader helps you keep up with your top information ...

Instawell - Let's get well together:Feeling lonely? Meet new helpers everyday. Talk about your problems anonymously or sign up and help others feel better today. No judgement and always ...

IntesisHome: Home:What can IntesisHome do? › Daikin Fuji Electric Fujitsu General LG Mitsubishi Panasonic Samsung Toshiba. And many other brands. Discover the compatibility  ...

Kyber - Make it happen | Messenger, Reminder, shared Calendar ...:2 days ago ... Read reviews, get customer ratings, see screenshots, and learn more about Kyber - Make it happen | Messenger, Reminder, shared Calendar, ...

Lifelog - Android Apps on Google Play:This is the official Lifelog app from Sony. With Lifelog you can view information about your communications, entertainment and physical activity - you can also set ...

Maker Studios:Maker is a talent-first, technology driven media company and the #1 producer and distributor of online content reaching millennials in the U.S..

openHAB - empowering the smart home:openHAB - The open Home Automation Bus. ... Welcome to openHAB - a vendor and technology agnostic open source automation software for your home.

Pinterest: Discover and save creative ideas:Pinterest is a visual discovery tool that you can use to find ideas for all your projects and interests.

Qapital - Save small. Live large.:The Qapital Visa Debit card helps you use your everyday purchases to boost your savings even more, and in real time. Coming in the second half of 2015.

Sensibo:Give your old air conditioner a brain. Meet Sensibo. A device that turns any a/c smart and reduces its energy consumption. Buy Now. Play video ...

Trello:Infinitely flexible. Incredibly easy to use. Great mobile apps. It's free. Trello keeps track of everything, from the big picture to the minute details.

Independence Day (United States) - Wikipedia, the free encyclopedia:Independence Day of the United States, also referred to as Fourth of July or July Fourth in the U.S., is a federal holiday commemorating the adoption of the ...

Weebly Website Builder: Create a Free Website, Store or Blog:Weebly makes it surprisingly easy to create a high-quality website, blog or online store. Over 25 million people use Weebly to bring their unique ideas to life.

Android Device Manager - Google:Android Device Manager makes it easy to locate, ring, or wipe your device from the web.

android.location | Android Developers:The Google Location Services API, part of Google Play services, is the preferred way to add location-awareness to your app. It offers a simpler API, higher ...

Notifications | Android Developers:A notification is a message you can display to the user outside of your application's normal UI. When you tell the system to issue a notification, it first appears as ...

How to make a phone call in android and come back to my activity ...:I am launching an activity to make a phone call, but when I pressed the 'end ... use a PhoneStateListener to see when the call is ended. you will most likely need to ...

Google Photos - Android Apps on Google Play:Google Photos is the home for all your photos and videos, searchable and organized by the people, places, and things that matter. • VISUAL SEARCH: Your  ...

The top 5 text message replacement apps for ... - Android Central:Sep 29, 2014 ... Textra is definitely a handsome-looking SMS app, especially since it received its Sept. 3 Material Design-inspired update. I like the look quite a ...

Android Wear:A watch for every style. Wear the watch that best represents you. Round or square, traditional or modern. Wear it for fashion, fitness, or fun. Buy Now ...

Blogger:Free weblog publishing tool from Google, for sharing text, photos and video.

Tumblr: Sign up:Post anything (from anywhere!), customize everything, and find and follow what you love. Create your own Tumblr blog today. Create a free website or blog:Create a free website or easily build a blog on Hundreds of free, customizable, mobile-ready designs and themes. Free hosting and support.

Box | Secure Content & Online File Sharing for Businesses:Box offers secure content management and collaboration for individuals, teams and businesses, enabling secure file sharing and access to your files online.

Campfire: Business group chat, file sharing, group decision making:Campfire is a simple web-based real-time group chat tool for business. It makes real-time communication with 2-60 people as simple as visiting a web page.

DocSend - Simple, intelligent, modern document sending:DocSend helps you communicate more effectively by telling you what happens to documents after you send them and letting you keep control in real time.

Gumroad:Sell music, comics, software, books, and films directly to your audience.

Harvest: Simple Online Time Tracking Software:Simple time tracking, fast online invoicing, and powerful reporting software. Simplify employee timesheets and billing. Get started for free.

KATO USA : Precision Railroad Models:Featured video: Get a sneak peak at the upcoming FEF-3 and GS-4 Combination Heavy Steam Sound Card for the Kato Soundbox on our Youtube channel!

LinkedIn: World's Largest Professional Network:300 million+ members | Manage your professional identity. Build and engage with your professional network. Access knowledge, insights and opportunities.

Quip:Or use Quip with your friends and family. Already have an account? Sign In · Documents Spreadsheets Lists Chat · The insanely great mobile productivity suite.

Chatter - Enterprise Social Network ... - every employee with the files, data and experts they need--anywhere, any time with Salesforce Chatter collaboration software solution. Productivity.

Slack: Be less busy:Slack brings all your communication together in one place. It's real-time messaging, archiving and search for modern teams.

Square: Credit Card Processing & Business Solutions:Square is one service for your entire business, from secure credit card processing - including Apple Pay & EMV - to point of sale solutions. Sign up today!

Stock Market Data - Dow Jones, Nasdaq, S&P 500 - CNNMoney:Complete stock market coverage with breaking news, analysis, stock quotes, before & after hours market data, research and earnings.

Yammer Business Collaboration Software:Take on any business challenge. Yammer provides collaborative software that empowers employees to be more productive and successful.

AppZapp - Deine Community rund um iPhone & iPad Apps:Deine Community rund um iPhone Apps aus den deutschsprachigen AppStores. Mit AppZapp behältst Du stets den Überblick über Preisänderungen,Updates ...

Best Buy: Expert Service. Unbeatable Price.:Shop Best Buy for electronics, computers, appliances, cell phones, video games & more new tech. In-store pickup & free shipping on thousands of products.

Chain: Bitcoin API:Chain is a powerful block chain API that makes it easy to build Bitcoin applications.

craigslist > sites:List of all international online classifieds sites.

eBay: Electronics, Cars, Fashion, Collectibles, Coupons and More:Buy and sell electronics, cars, fashion apparel, collectibles, sporting goods, digital cameras, baby items, coupons, and everything else on eBay, the world's ...

Etsy - Your place to buy and sell all things handmade, vintage, and ...:Buy and sell handmade or vintage items, art and supplies on Etsy, the world's most vibrant handmade marketplace. Share stories through millions of items from  ...

Fiverr: The marketplace for creative & professional services:Fiverr: Graphics, marketing, fun, and more online services, on budget and on time .

Semantics3 - APIs for Products, UPCs and Prices:The Semantics3 product API provides access to a database of normalized e- commerce product, UPC, and pricing data for apps and analytics. Online shopping for Electronics, Movies, Music ...:ShopYourWay is a great place to discover new products from the community, read reviews written by your friends and stay updated with hot trends.

Slice - Track Your Stuff (Packages, Purchases, Price Drops, Recalls):Where's your stuff? Find out with the best online shopping app for Android & iOS that tracks all your packages, purchases, price drops and product recalls.

Stripe:Stripe is a suite of APIs that powers commerce for businesses of all sizes.

TrackIf: Price Tracking, Sale and Deal Alerts:TrackIf is your personal web tracker, keeping you in the know if anything changes on the sites you want. Track price drops, stock availability, special offers and ...

Automatic: Connect Your Car to Your Digital Life:The Automatic app and plug-in car adapter turns just about any car into a connected car. Diagnose check engine codes, get driving feedback, mileage tracking ...

DASH | – is a one stop contemporary women's boutique for the confident, captivating, and charismatic women of today with an eye for fashion and style.

Mojio - Your Connected Car:Mojio and its connected car apps give you peace of mind about the health and status of your car. Saving you time, money, and unexpected trips to the mechanic.

Zubie | Making Driving Easier, Safer and Less Expensive.:Make Driving Safer, Easier & Less Expensive The Zubie™ Key connects with your car to deliver safety features, vehicle diagnostics and driving insights - Right  ...

blink(1) | the USB RGB LED notification light:blink(1) is the world's best indicator light, designed to give you glanceable notice of anything on your computer or the internet. blink(1) makes it easy to connect ...

The bttn - the simplest user interface in the world:The bttn communicates with the powerful servers in the cloud. They dispatch messages and actions to almost any internet services so that what you want ...

Smart WiFi Thermostats by ecobee |:ecobee thermostats use thousands of data points to automatically make intelligent, and personalized heating and cooling decisions to save you money on ...

Mi|Home Range - Energenie:The Mi|Home App has an integrated QR code reader which enables you to set up the Gateway with a single scan… it couldn't be easier! The Mi|Home Adapter ...

Garageio - Turn your smartphone into your garage door opener:Garageio is the simple and secure way to control and monitor your garage door from anywhere in the world, all without needing to replace your existing opener.

Greenwave Systems - Helping You Make All The Right Connections:Greenwave Systems accelerates Internet of Things with a software and services platform that enables managed services simply, affordably and at scale.

Harmony Remotes - Choose your Harmony Remote - Logitech:Shop for Harmony Remotes. Compare features and find the right Harmony Remote for you. Learn more now.

Homeboy: the world's most accessible home security system:Homeboy is the world's most accessible security system, featuring intuitive mobile apps and the world's first wire-free, long-life, Wi-Fi security camera.

HomeControl Flex - Telguard:HomeControl Flex™, available with all Telguard universal communicators, is an addition to the existing Telguard HomeControl home automation platform.

HomeSeer Home Automation Systems - Home:HomeSeer is the #1 Rated Home Automation System by We Offer a Complete Line of Home Automation Products for Every Need ...

Multi Zone Thermostat - evohome | Get Connected - Honeywell:At its heart is the evohome controller, your simple to use control panel that lets you set the temperature in every room in your home - from anywhere in your home ...

Single Zone Thermostat | Get Connected - Honeywell:Single Zone Thermostat lets you control your heating via your smartphone or tablet ... With no wires connecting your boiler and your thermostat, you can place it ...

HP ePrintCenter | Printers:What is a Web-connected printer? Many of the newest printers from HP connect to the Internet, enabling these key benefits: ePrint – Use this HP feature to print ...

iSmartAlarm - Protect Your Home Intelligently:2 days ago ... iSmartAlarm - Take control of your home security and home automation with a sleek, DIY, wireless, easy-to-use system controlled from your ...

LIFX | Live a more illuminated life.:LIFX - Original Wi-Fi enabled LED smart bulb with no hub. Control your lights via iPhone and Android devices. Colored LEDs. Tunable white LEDs. Works with ...

littleBits: DIY Electronics For Prototyping and Learning:littleBits puts the power of electronics in the hands of everyone. Make your own electronic creations with no soldering, wiring, or programming required.

Caséta Wireless - Lutron:Control your lights, shades and temperature from anywhere – whether you're home or away. Caséta Wireless dimmers and switches install in minutes, work with ...

Manything | Monitor Anything with Manything:Turn your iPhone, iPod or iPad into a sophisticated monitoring camera with Manything. With live feeds, unlimited recording, motion detection, clip sharing and ...

Myfox: Alarm, Security Cameras & Smart Home Solutions:Discover all our smart home solutions: alarms, video surveillance, anti intrusion, home security, …

Meet Nest Protect | Nest:Be informed. Not alarmed. The Nest Protect: Smoke + Carbon Monoxide detector. Nest Protect thinks before it speaks, and can be monitored from your ...

Meet the Nest Thermostat | Nest:Meet the Nest Learning Thermostat. The Nest thermostat learns the temps you like, turns itself down when you're away, and has remote control through Wi-Fi.

The Netatmo Weather Station, the weather station designed for ...:The Personal Weather Station with Air quality sensors, made for iPhone and Android, to monitor and track your environment.

ORBneXt - Your World at a Glance.:ORBneXt is an always-on, realtime desktop data display device. It connects to your home or work internet via Wi-Fi and allows you to track a virtually endless ...

Parrot - Flower Power - intelligent wireless sensor for your plants:Parrot - Flower Power, Parrot brings the Internet of Things to the garden. Parrot Flower Power, the first intelligent wireless sensor.

Particle - Wikipedia, the free encyclopedia:A particle is a minute fragment or quantity of matter. In the physical sciences, the word is used to describe a small localized object to which can be ascribed ...

Meet hue | en-US:Meet hue. Our homes have changed radically over the past century. So why do we still use lighting that's based on 19th century technology? Philips hue lighting  ...

Rachio - Smart WiFi Sprinkler Controller - Automate Your Watering:Rachio Iro. The smart sprinkler .... Rachio saves most users over 30% on outdoor water usage when compared to standard controllers. Saving you money.

Revolv:For existing customers, the service will continue to be available and we will continue to offer customer support. However, Revolv will not be made available to ...

Scout Alarm:Scout is a self-installed, wireless home security system. No-contract, affordable smart home security. Great for renters and homeowners alike.

Sighthound Video Surveillance Software:Sighthound Video is free video surveillance software for home and business that is easy to use and works on PC, Mac, iPhone and Android.

Discover smappee - Smappee:Smappee Energy Monitor. Save money now. Measure your electrical energy consumption and solar production.

SmartThings | Smart Home. Intelligent Living.:SmartThings turns your ordinary home into a smart home. Easily monitor and control lights, locks, temperature, and more from anywhere in the world using your ...

ThermoSmart - de slimme wifi thermostaat:ThermoSmart - de slimme wifi thermostaat: ervaar het gebruiksgemak thuis en op afstand. Zelflerend. Energie besparen was nog nooit zo eenvoudig!

Ubi -The Voice Of The Internet:The Ubi is a WiFi connected, voice operated computer that allows for handsfree voice interaction in the home. You can send messages, play music, control ...

Wally | Smart Home Sensing & Moisture Detection:Bring Wally home. With Wally, you won't worry. Buy Now. Wally · About Us · Jobs · Press · Trade · Legal · Support · My Story · Contact · Developer · Try the Demo ...

WeMo® Insight Switch - Belkin:The Wi-Fi enabled WeMo Insight Switch connects your home appliances and electronic devices to your Wi-Fi network, allowing you to turn devices on or off, ...

WeMo® Light Switch - Belkin:The Wi-Fi® enabled WeMo Light Switch allows you to turn lights on and off from anywhere--from across the house, from the backyard, or from the other side of ...

WeMo® LED Lighting Starter Set - Belkin:Apr 10, 2014 ... The WeMo LED Lighting Starter Set lets you access and control your WeMo Smart LED Bulbs from anywhere, using your existing home Wi-Fi ...

Buy the WeMo Maker™ Now! - Belkin:The WeMo Maker is a fun and easy tool for hobbyists and tinkerers who love taking things apart, figuring out how they work, and customizing low voltage ...

WeMo® Switch + Motion - Belkin:The Belkin Wi-Fi enabled WeMo Switch and WeMo Motion Kit gives you wireless control of your home appliances and electronics, turning devices of your choice ...

WeMo® Switch - Belkin:The Belkin Wi-Fi enabled WeMo Switch lets you turn electronic devices on or off from anywhere. The WeMo Switch uses your existing home Wi-Fi network to ...

Aros | Quirky:Mar 27, 2014 ... Ditch your dumb window A/C for Aros, because Aros is smart. ... What's more, it can be controlled from anywhere using the Wink app on your ... Egg Minder Wink App-Enabled Smart Egg Tray ...:Egg Minder Wink App-Enabled Smart Egg Tray, +, GE Link, Wireless A19 Smart Connected LED Light Bulb, Soft White (2700K) ...

Nimbus | Quirky:Nimbus is a highly customizable 4-dial dashboard that tracks what's important to you. Personalize each gauge using your mobile device to keep an array of info ...

Pivot Power Genius | Quirky:Pivot Power Genius is an app-enabled version of our best-selling power strip. Like the original, it bends to fit every sized plug or adapter without wasting a single ...

Porkfolio | Quirky:Porkfolio is the world's smartest piggy bank. It wirelessly connects to the Wink app on your mobile device so you can track your balance and set financial goals  ...

Wink: Shortcuts connects with the apps you love - IFTTT:A simpler way to a smarter home. Wink brings all of your favorite smart products together in a single app. Wink Shortcuts allow you to control multiple smart ...

Spotter | Quirky:Spotter keeps you updated on what's going on at home—no matter where you are. Monitor motion, sound, light, temperature, and humidity all from your mobile  ...

Wireless Sensor Tags: Monitor and Find Everything from the Internet:Wireless WiFi sensors for locating items, logging and monitoring presence, temperature, humidity and motion events from anywhere with Internet access, ...

Fitbit Official Site for Activity Trackers & More:Find your fit with Fitbit's family of fitness products that help you stay motivated and improve your health by tracking your activity, exercise, food, weight and sleep.

Google Glass:Thanks for exploring with us. The journey doesn't end here. You'll start to see future versions of Glass when they're ready (for now, no peeking).

Misfit | Wearables, Activity Trackers, Fitness and Sleep Monitors:Misfit invents and manufactures premium wearable computing products, such as the Shine and Flash.

Log in - Nike+:NIKE+ GEAR · PLACES · WHAT IS NIKEFUEL? *Your Email or ... TOP FAQS. 1. Setup the Nike+ FuelBand · 2. Getting Started with the Nike+ SportWatch GPS.

UP by Jawbone | A Smarter Activity Tracker For A Fitter You:Discover new ways to get fit, lose weight and stay active. The UP® system with Smart Coach helps you form healthier habits and achieve your fitness goals.

Whistle: Activity monitor and GPS pet tracker for dogs:Whistle Activity Monitor and GPS Pet Tracker provide insights into your dog's behavior by tracking daily activities, health trends, and location.

Withings:Withings Home. Security is a beautiful thing. Discover ... Withings Health Institute. Visit. Follow us. Visit our blog · Press About Withings Jobs Works with Withings ...

iOS Contacts connects with the apps you love - IFTTT:IFTTT is the easiest way to connect iOS Contacts to the apps you love most. Put the internet to work for you.

Getting the User's Location - Apple Developer:If your iOS app requires location services to function properly, include the UIRequiredDeviceCapabilities key in the app's Info.plist file. The App Store uses the ...

Local and Push Notifications for Developers - Apple Developer:Find the essential documentation and sample code for using local and push notifications in your iOS apps and Mac apps.

Apple - iOS 8 - Photos:Every photo, every edit, every album now lives in your iCloud Photo Library, easily viewable and consistent on all your iOS devices. Automatically.

How to set up and use Reading Lists in Safari for iPhone and iPad ...:Nov 18, 2014 ... Since Safari Reading List can save stories from almost any site, it's also perfect for recipes, ... How to use the Shared Links in iOS 7 SafariiOS.

Create and use Reminders on your iPhone and iPad - Apple Support:Feb 4, 2015 ... Reminders lets you keep track of all the things you need to know like due dates and locations.

Time and Date:Lots of time and date related information, such as yearly and monthly calendars, counters, countdown, and the world clock which shows the current time in cities ...

IFTTT: Connect the apps you love:IFTTT puts the internet to work for you. Create simple connections between the products you use every day.

Is it Christmas?:An answer.

popSLATE | The Second Screen for Your iPhone:"a super cool idea that actually works, is pretty damn easy, and unique in the market". Press Logo. "…popping is the way of the future". Press Logo ...

Space and NASA News – Universe and Deep Space Information:Get the latest outer space and science news, NASA information, watch space flight videos at View exclusive solar system Images, latest astronomy  ...

SURFLINE.COM | Global Surf Reports, Surf Forecasts, Live Surf ...:The most accurate and trusted surf reports and forecasts and coastal weather. Surfers from around the world choose Surfline for dependable and up to date ...

National and Local Weather Forecast, Hurricane, Radar and Report:The Weather Channel and provide a national and local weather forecast for cities, as well as weather radar, report and hurricane coverage. - Listen to free music and watch videos with the largest ...:The world's largest online music catalogue, powered by your scrobbles. Free listening, videos, photos, stats, charts, biographies and concerts.

MixRadio | Home Page:MixRadio is your personal music service. It learns about the music you like to play and suggests similar artists to who you love. You can discover thousands of  ...

SoundCloud – Hear the world's sounds:Feb 27, 2014 ... Explore the largest community of artists, bands, podcasters and creators of music & audio.

BuzzFeed:See 27 Amazing Works Of Art From The Met Museum On Snapchat. Everyone has their ~muse.~ Follow BuzzFeed on Snapchat today! Rebecca Aguilera.

Digg - What the Internet is talking about right now:Digg is the homepage of the internet, featuring the best articles, videos, and original content that the web is talking about right now.

Entertainment Weekly's | Entertainment News | TV News ...:Online version of the print magazine includes entertainment news, interviews, reviews of music, film, TV and books, and a special area for magazine subscribers.

ESPN: The Worldwide Leader in Sports:Visit ESPN to get up-to-the-minute sports news coverage, scores, highlights and commentary for NFL, MLB, NBA, College Football, NCAA Basketball and more.


feedly. Read more, know more.:feedly: organize, read and share what matters to you.

Beauty Tips, Celebrity Style and Fashion Advice from InStyle ...:InStyle is the leading site for celebrity style. See expert fashion advice, star hairstyles, beauty tips, how-to videos and real-time red carpet coverage.

NewsBlur:NewsBlur is a personal news reader bringing people together to talk ... NewsBlur is free on the web, iPad, iPhone, and Android. By subscribing to a premium ... : Celebrity News, Celebrity Photos, Exclusives and Star ...:Get your fix of the hottest celebrity news, celebrity photos, style and videos from PEOPLE Magazine.

ReadingPack - Share and Read Articles Recommended by People ...:Follow reading lists of people with similar interests and read the most recommended articles.

reddit: the front page of the internet:User-generated news links. Votes promote stories to the front page.

Sports News, Scores and Highlights from Sports Illustrated - - sports news, scores, photos, columns and expert analysis from the world of sports including NFL, NBA, NHL, MLB, NASCAR, college basketball, college ...

Sunlight Foundation:Claims to make U.S. government data accessible to the public.

The New York Times - Breaking News, World News & Multimedia:The New York Times: Find breaking news, multimedia, reviews & opinion on Washington, business, sports, movies, travel, books, jobs, education, real estate,  ...

TIME - Current & Breaking News | National & World Updates:Breaking news and analysis from Politics, world news, photos, video, tech reviews, health, science and entertainment news.

Fantasy Sports - Yahoo Sports:Comprehensive Fantasy news, scores, standings, fantasy games, rumors, and more on Yahoo Sports.

The Premier Photography Community / 500px:Find the perfect royalty-free photos on 500px Prime. ... 500px is a photo community for discovering, sharing, buying and selling inspiring photography powered ...

dailymotion:Metal Gear Solid 5: The Phantom Pain Graphical Downgrade Claims & Black Ops 3 Beta Release - IGN Daily Fix. by IGN. Staff picks ...

WiFi SD Cards: Eyefi Memory Cards: Wireless Photo and Video ...:Eyefi Wireless SD Cards with built-in WiFi - make your camera wireless. Upload photos and videos wirelessly to your computer and to the web. Works in over ...

FFFFOUND!:FFFFOUND! image bookmarking. iFOUND! | iPhone application for FFFFOUND comes back to App Store!!! Top · About; Sign in; Screensaver · iPhone; Register.

Flickr, a Yahoo company | Flickr - Photo Sharing!:Picture galleries available with social networking, chat, groups, and photo ratings .

Giphy: Search Animated GIFs on the Web:Giphy is how you search, share, and discover GIFs.

Instagram:Capture and Share the World's Moments. Instagram is a free and simple way to share your life and keep up with other people. Take a picture or video, then ...

Printhug:With the Printhug channel on IFTTT you can now start printing your beautiful photos from Instagram, Facebook, Flickr, iOS and many more! To get started, here ...

Stockimo: the mobile phone photo app that makes money:Cash in on your creativity! Download the Stockimo mobile phone photo app. Upload your best images and we'll sell them on Alamy, the world's largest stock ...

Vimeo, Your Videos Belong Here:Vimeo is the home for high-quality videos and the people who love them.

YouTube:Share your videos with friends, family, and the world.

Bitly:Bitly Brand Tools: Own, understand and activate your best audience through the power of the link.

Boxcar 2 on the App Store on iTunes - Apple:Jun 27, 2015 ... Read reviews, get customer ratings, see screenshots, and learn more about Boxcar 2 on the App Store. Download Boxcar 2 and enjoy it on ...

Boxoh universal package tracking: UPS, FedEx, USPS, and DHL ...:Please click here if you are not redirected within a few seconds. Boxoh. Track. Terms | © 2005 - 2015. Follow us on Twitter!

Buffer - A Smarter Way to Share on Social Media:Buffer makes it super easy to share any page you're reading. Keep your Buffer topped up and we automagically share them for you through the day.

Delicious:Keep, share, and discover the best of the Web using Delicious, the world's leading social bookmarking service.

Diigo - Better reading and research with annotation, highlighter ...:Diigo is a powerful research tool and a knowledge-sharing community.

Dropbox:Dropbox is a service that keeps your files safe, synced, and easy to share. Bring your photos, docs, and videos anywhere and never lose a file again.

Gmail - Google:Google-owned, web-based email service provides details of storage, options and links to related services.

Email Digest connects with the apps you love - IFTTT:IFTTT is the easiest way to connect Email Digest to the apps you love most. Put the internet to work for you.

Evernote: The workspace for your life's work:Bring your life's work together in one digital workspace. Evernote is the place to collect inspirational ideas, write meaningful words, and move your important ... | Email Tracking and Reminders for Business People:Get Free Email Reminders today! Easy Email Reminder System. FollowUp creates reminders from your inbox! Schedule emails for event, meetings and ...

Gmail - Google:Google-owned, web-based email service provides details of storage, options and links to related services.

Google Calendar:With Google's free online calendar, it's easy to keep track of life's important events all in one place.

Google Drive - Cloud Storage & File Backup for Photos, Docs & More:Get access to files anywhere through secure cloud storage and file backup for your photos, videos, files and more with Google Drive.

Instapaper:A simple tool for saving web pages to read later on your iPhone, iPad, Android, computer, or Kindle.

Instapush - Instant Notifications for Important Transactions:Instant Notifications for the transactions you care about.

Contrast | Launch Center Pro:Launch Center Pro. Launch actions, not just apps. It's like speed dial for everyday tasks. Launch Center Pro saves you time by launching complex actions in a ... - Connected Mind:The Connected Mind. is an interactive virtual assistant which allows you to perform different actions with the Internet of Things by simply asking Moni.

Nimbus - Nimbus Note:Capture any information. Save your ideas, notes, images, Web pages and any other type of information! Access from Anywhere. Nimbus Note works with a ...

Numerous: Life's most important numbers available at a glance:Numerous: Life's most important numbers available at a glance.

Microsoft OneDrive:Download OneDrive on all your devices to access your photos and files from almost anywhere, store them, and share them.

Microsoft OneNote | The digital note-taking app for your devices:Get the OneNote app for free on your tablet, phone, and computer, so you can capture your ideas and to-do lists in one place wherever you are. Or try OneNote  ...

Make calls from Gmail - Chat Help - Google Help:You can make a call from your Gmail account from your Google Chat list or your email. Make a call using ... Learn more on how to call a phone using Hangouts.

Pinboard: social bookmarking for introverts:Pinboard is a fast, no-nonsense bookmarking site for people who value privacy and speed. There are no ads and no third-party tracking. You pay a small annual  ...

Pocket:When you find something you want to view later, put it in Pocket.

Pryv | Personal & health logging solutions:We also offer Pryv as a service for individual users — Learn more. Your sensitive data management, sorted out. Now focus on your medical tr|. medical_grade ...

Pushalot:Pushalot is a platform for receiving custom push notifications to connected devices running Windows Phone or Windows 8. Custom means that those push ...

Pushbullet - Your devices working better together:Pushbullet connects your devices, making them feel like one. Sign up with Google Sign up with Facebook. Android iOS Chrome Firefox Safari Opera Windows ...

Pushover: Simple Notifications for Android, iOS, and Desktop:Dozens of applications and web services already have Pushover integration to quickly get you started. Just supply your Pushover user key or your Pushover ...

QualityTime - My Digital Diet - Android Apps on Google Play:QualityTime 2.0 is here!QualityTime is a fun, visually engaging and easy-to-use Android app that allows you to monitor and get real time reports on how much ...

A Free Web & Mobile App for Reading Comfortably — Readability:Readability is a web and mobile app that zaps online clutter and saves web articles in a comfortable reading view.

Short Message Service - Wikipedia, the free encyclopedia:Short Message Service (SMS) is a text messaging service component of phone, Web, or mobile communication systems. It uses standardized communications ...

Todoist: To-do list and task manager. Free, easy, online and mobile:Trusted by millions, Todoist is the best online task management app and to-do list . For Web, iPhone, iPad, Android, Chrome, Outlook and many more!

Toodledo : A productivity tool to manage your tasks, to-dos, notes ...:Toodledo is one of the most popular online productivity tools. Use it to manage your to-do list, take notes, organize ideas into outlines and make custom ...

Join account. Many applications. Get instant access to hundreds of great social apps on iPhone, iPad, Android and more. Learn more. Create a free account in ...

Welcome to Facebook - Log In, Sign Up or Learn More:Facebook is a social utility that connects people with friends and others who work , study and live around them. People use Facebook to keep up with...

Introducing New Facebook Pages | Facebook:Your Facebook Page will help people find you on Facebook and on the web. See examples on other Pages: Subway. 25,940,246 likes · 42,847 talking about ...

Foursquare:Foursquare helps you find the perfect places to go with friends. Discover the best food, nightlife, and entertainment in your area.

GitHub · Build software better, together.:Online project hosting using Git. Includes source-code browser, in-line editing, wikis, and ticketing. Free for public open-source code. Commercial closed source  ...

GroupMe | Group text messaging with GroupMe:GroupMe brings group text messaging to every phone. Group message with the people in your life that are important to you.

Life360 - The New Family Circle:Welcome to the new family circle. Life360 is a family locator, messaging tool and communication app all in one.

微博-随时随地发现新鲜事:... Android · Windows Phone · Other Mobile client · Weibo Desktop · 关于微博| Help| 微博发现| Feedback| Verification & Cooperation| API| Careers| Sina Sitemap|.

Twitter:Connect with your friends — and other fascinating people. Get in-the-moment updates on the things that interest you. And watch events unfold, in real time, from ...

Just Yo:Yo. It's that simple. Download for your device. Get the app! Download for your device. Contact Us · Yo Store · Yo Dashboard · Blog · Jobs · Terms · Privacy.

Sunday, March 08, 2015

Hibernate queries are slow ! SQL Server's are not my type ? - Here is what you need to know!

  "Hibernate is one of most  cited culprit for slower queries !", though I am kind of victim of this thought for sometime until I "understood" the true wisdom of lame excuses :)

Though sometimes this epic comic reflects my mental turbulence during the performance improvement katas... I learned not to go by hunches, but on real hard facts and truths. One interesting problem I found recently pretty annoying me for days (actually months sparingly) was slow query performance of the total application I was working on. Though the problem is itself is pretty basics, but the process of tuning and troubleshooting is what I thought is interesting.

To give a background, I was running Hibernate/Java/Spring Stack SQL Server 2008 as my DB (it's out of choice unquestionably) but I don't mind and stick to one technology so opportunity to try new / old things are always good.

  Here is the graph of the actual output of the query through my application, a long spike is in CPU for the period of that query running. Initially looking for something to blame I thought the common culprit being the Hibernate (being innocent)  and thought removing it would be improving the query performance. Quickly changing the HQL to Native Queries, got response times around 2ms , WOW! just WOW!, so is the Hibernate being dumb? or some other thing! at least up to this point its just all pointing to Hibernate.

 So giving benefit of the doubt for Hibernate this time and not insanely changing all the app stack to just native queries or different ORM framework, just to keep my sanity and my application's , thought of venturing the journey of true wisdom, and let me take through the journey of findings.

Suspect No. 1 Hibernate

 Though initially I tried with few different common measures, checking out the queries and doing proper indexes, running load tests it's pretty annoying that just with 10 million records it took laborious 187 ms just to run a simple query without even joins !!

 Quickly bringing back the HQL queries and adding a second level cache just for enhancing the user experience, made the problem go away (Temporarily). I was also interested to find out what actual query is being sent by the Hibernate and what would be the Query plan for that query and why it's taking too long!

 So used the SQL Profiler to log the queries being sent to the server and to my surprise the queries are actually sent as stored procedures.

Hibernate Query:

select c.col1,c.col2 from customer c where like @param1 and like @param2

Actual Driver Sent Query:

@param1=somevalue, @param2=somevalue 
declar sp .... select c.col1,c.col2 from customer c where like @param1 and like @param2 

Enabling stats for Hibernate, clearly prints the proper HQL transformed queries, so we are good there, so Hibernate is out of the picture now.

Suspect No 2 JDBC Driver

I was actually using Microsoft JDBC Type 4 Driver.

Ok let's go back and see what is happening on the driver front. Little bit analysis from the documentation it's pretty clear that SQL Server caches the query plan efficiently for stored procedures, so driver is doing the right thing! , so who is the culprit here now ?

SQL Server ?!!! - I hate to say that it's not , it's being clever tries to cache the query, but having one caveat to it "Parameter Sniffing" , in short it's the sql server way to cache the queries and make the parameters dynamic to enable effective query plans, but the queries being sent with @param1 ... so there has to be common problem across.

One option is to stop the driver to send out the stored procedure or make adjustments to queries or remodel the schema to take advantage of the parameter sniffing (though it requires extensive analysis of the application running in prod. with time crunch of existing releases, though i like this way), but hastily I tried to find options to stop sending the stored procedures out of the app, it seems the driver is of no use in handling these through config, shopping around I found JTDS  claiming to be the fastest SQL driver available, so wanted to try this first as it has this parameter prepareSQL=false, which would disable the stored procedure queries

 This made a greater improvement from 180ms to around 90ms. Wait what?  remember 2ms query time ? that's the baseline to reach for, so under the hood, I see the queries being sent like

Select * from customer c where like **N**'somename' and**N**'somevalue'

what is this cryptic 'N' before the value ? oh yea Nvarchar, wait... what? why nvarchar for my varchar type, in short supporting UTF-8 chars, oh but my query is a userId and it's a hashed string, so why need a UTF-8, there is a parameter to disable it to sendUnicode=false pretty cool huh??. This did the trick, no type conversions were done and the query was running around the baseline we established before.

So now the application is back into business, but wait the app is not yet supporting under staging environments with even 1000 req, under load balanced env. two servers behind it, so what's happening initially the thread dumps points to the apache to tomcat connector AJP threads being waiting, ok so that's not acceptable

Ok digging it again, oh yea pretty lame bug in the jdbc url, there was a parameter in the url instance=SQL2008 why for a sql server 2012 R2? due to this setting the driver was trying to optimize the db connections as SQL2008 and 2012 server was so slow in establishing them. and the initial connections are taking too long to warm up the connection pool. So threads are actually waiting on the next set of connection pools to support extra load, initialSize being defaulted to 50, so changing and playing the params, finally fixed the problem just by removing the instance=SQL2008, param from the URL.

 Sigh of relief now, pretty much the environment is able to scale up and handle larger loads, having a proper basic setup ready and established baselines, now we have pretty good application setup to work with.
One thing to remind you, there will be more journey in the future, but would be interesting and rewarding  too...

 One final Thought
 @bpoetz: "programming is awesome if you like feeling dumb and then eventually feeling less dumb but then feeling dumb about something else pretty soon"

See you till the next post!

Thursday, January 09, 2014

Quick Maven Archetypes and Project Setup

If we need to re-use the maven based project as base for future projects, then we can create an archetype which can generate the skeleton for the future project. It applies to both single-module and multi-module maven projects
  1. Go to project root directory
  2. mvn archetype:create-from-project
      - This generates a target folder with generated-resource directory , find archetype-metadata.xml for the details about the file inclusions and module setup
  3. Got to target/generated-sources/archetype/ 
    mvn install 
      - This installs the current archetype into maven repo

[INFO] project created from Archetype in dir: kitchensink\target\generated-sources\archetype\target\test-classes\projects\basic\project\basic
[INFO] No post-archetype-generation goals to invoke.
[INFO] --- maven-install-plugin:2.5.1:install (default-install) @ kitchensink-archetype ---

 --- maven-archetype-plugin:2.2:update-local-catalog (default-update-local-catalog) @ kitchensink-archetype ---

  • Archetype gets created from above shown archetype location, this will be available in the default-update-local-catalog or local catalog

 Using the Archetype: (Eclipse)

  • New -> Maven -> Maven Projects
  • select local catalog , if nothing displays , make sure to check  "Include Snapshot Archetypes" option
  • Then click finish , project is created 

MySql Enable Logs for Queries , Expert Way!

show variables like 'general_log%'

| Variable_name    | Value
| general_log      | OFF
| general_log_file | C:\ProgramData\MySQL\MySQL Server 5.5\Data\pixomachine.log

 set GLOBAL general_log='ON';

C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld, Version: 5.5.25a (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: MySQL
Time                 Id Command    Argument
130310  1:09:40    1 Query select * from users

Git 2 Minutes



Eclipse: E-git

Clone Repository:

git clone git_url
 Clones the git repository in the local

GIT Configuration:

git config --list
   Check the git configuration
git config --global --edit
  Edit the git config


Ignoring files during commit
 Get the attached file and put in the GIT HOME Directory..gitignore_global

Git Changes

git status 
  List the current changes

Git Pull

git pull
   Get the contents of remote repository changes into local

Git Add:

git add
 Adds the specified file for commit
 git add -u
 Adds all the files marked 'Untracked' to commit
git add .
 Add all the files tracked, untracked for commit

Removing file from cache:

 Not yet ready to commit some file just remove them from the commit cache
  git rm --cached filename


git checkout  
 To switch branches and to create new branches in the local
git branch -a 
 List all the branches including remote branch
git branch -r 
  List remote branches only
git branch
  Display the current branch
git branch new_branch 
 Create a new branch or switch branches

Push to remote branch

git push -u origin new_branch

Intermediate commits: Stashing

When you middle of something and want to work on some fix, don't want to commit it yet then stash it.
git stash
  Stacks up the current changes, does not commit it) , you can also do
git stash stash_name
  Stash name reference if you want refer in the future


git commit 'commit msg'
  Commits all the changes under commit label


git push
  Push the contents to the remote git repository

GIT Changes

Want to generate a report of recent changes then log it
git log -p > filepath
    To get code differences
git log > filepath
   To get commit differences