A recommended reading list, as someone requested of me today —
A recommended reading list, as someone requested of me today —
This is a rant: Apparently 10 years as a customer and over $1000/day in deposits doesn’t make me valuable enough to hold an ATM card at PNC Bank.
The debit card that came with my business checking account expired in March. I realized that when I tried to deposit a check at a drive-up ATM and it spit the card back out at me saying that it was expired. I figured I must have accidentally thrown out the replacement card as junk mail at some point, and called the number on the back of the card for the business support line.
The friendly CSR on the other end couldn’t find a debit card attached to my account. He eventually found the expired one, and a note that it was not reissued because there were no charges on the card in the last few months.
I guess that’s the standard now. Not what the contract says. Not what PNC’s website continues to say (“Free PNC Bank Visa Business Debit Card” as a feature of every business checking account). Don’t charge expenses to the card? You don’t get to use ATMs. Not worth the $1.11 in plastic and $0.49 in postage every 3-5 years.
Tomorrow, when I can visit a branch, as they all close at 5PM and it’s already 5:30, I’m supposed to beg a manager to personally order a card for my account. I’m tempted to close it instead.
I have a 10 inch tablet mounted on a wall near the entryway of my house that controls the first floor lights, doors, garage and temperature. It monitors motion sensors to automatically lock up for the night when I head to sleep.
A little node.js server runs on the tablet to talk to the Vera’s API to poll and control all the various devices.
It’s fun stuff to play with if you can afford all the pieces. The other colored buttons along the bottom switch views to various business dashboards.
Improvely‘s growing up. It’s now lovingly used by hundreds of marketing agencies and small businesses, with subscription revenue doubling every few months. Billions of website visits, ad clicks, leads and sales have been tracked. Dozens of new features have been added over the nearly two years since its launch.
The design, however, has remained the same since summer 2012. Over the long holiday weekend, I decided to tackle a design refresh of the entire app, with a few simple goals:
I managed to get everything done and tested in 4 afternoons, including a trip to Best Buy to steal a few minutes on their iPads for testing the responsive breakpoints. While there’s still room for improvement, everything looks a bit cleaner, brighter, and more consistent now, as well as adding room for a few new metrics on the overview and traffic performance reports.
P.S. A customer sent along this great link describing why revenue per person is a great metric for companies to keep an eye on. Improvely keeps track of it automatically for every single ad and other traffic source.
W3Counter is turning 10 years old.
Of the dozens of sites I put together in 2004 and 2005 from my college dorm, W3Counter’s the only one still around aside from this blog. It’s rather popular still — with around 70,000 users acquired completely organically and billions of page views being tracked — despite the explosion of competitors in the now enormous analytics industry. I’m sometimes asked why Google Analytics didn’t kill it — I think that has a lot to do with the fact that “easy” and “fun” are rarely used to describe GA, but I hear them used to describe W3Counter all the time. There’s a high school teacher that has his entire class sign up for accounts every year after creating their own webpages — they get a kick out of seeing the counters, and it’s easy enough to set up that it takes most people just a minute or two.
Every 2-3 years I’ve given the site some needed attention to keep up with the times. The architecture’s gone through several major revisions — from running on a single VPS to several servers, to a short stint running in Amazon’s Elastic Compute Cloud, then back to bare metal servers at SoftLayer. 2014’s users demand two things, at least if I care to keep some portion of them upgrading for the paid perks — real-time dashboards, and a mobile site.
Handling even a few thousand concurrent visitors pinging the service every few seconds with their current activity to run these dashboards necessitates something a little more efficient than the way W3Counter was originally programmed — a traditional PHP MVC application, with the Symfony framework on one or more frontend servers, talking to one or more backend database servers that store data about page loads from which the reports are generated. All that framework overhead and database communication can take 40-50ms to finish.
The code that collects data for the dashboards cuts that down to under one millisecond. It’s a node.js application, which bypasses all the overhead of the PHP framework. Redis, an in-memory key-value store is the first thing that code talks to. Redis caches information I’d otherwise need a database lookup to get. While MySQL has its own query cache, using it would still require a round-trip to the remote database server, and having the spare RAM on the database servers to dedicate to that.
The information on what all those active visitors are doing still sits in a MySQL database, but an entirely in-memory one on the front-end servers using the MEMORY storage engine. Unlike the database servers, my front-end web servers typically use less than 25% of their available RAM — they’re CPU-limited rather than memory-limited in their capacity — so keeping the ephemeral data for these dashboards there is just using otherwise unused resources.
By keeping the code efficient and only storing data in memory, one relatively low-end server can serve several thousand concurrent active visitors with negligible load. The only problem I actually ran into was the raw number of TCP connections. They came in faster than nginx was accepting them — I needed to increase its
worker_connections parameters to handle more. There were still more than the OS was happy to handle, complaining through the messages log that I was under a SYN flood attack — no, it’s not an attack — until I increased the available local port range and SYN backlog size. I quickly became friends with the
I’m a fan of dashboards myself. W3Counter’s Pulse Dashboard for Improvely runs in a rotation on a screen in my living room along with dashboards from Geckoboard, New Relic and my self-built home automation system for controlling lights, locks and temperature in my home. I’ll have to write about building that some day.
I was also, a bit reluctantly, forced by increasing mobile use to finally learn responsive web design. I still haven’t got it quite perfect, but W3Counter’s now usable on any screen size between your 4″ smart phone and 30″ monitor without half the screen being whitespace, like some vertical equivalent of the black bars on a 4:3 TV watching a letterboxed movie.
Various reports switch from multi-column to single-column layouts at smaller screen sizes, and menus disappear into a touch-friendly button-activated dropdown at the top of the page.
Most of the credit goes to Bootstrap 3’s responsive grid and “collapsible” plugin, along with a smattering of hand-written media queries that even work on IE8 thanks to Respond.js. Nobody’s running IE8 on their phones, but without that library, it shows the mobile version of the site which doesn’t look so great on a 20″ monitor.
I also redesigned the marketing site for W3Counter to match the new look — responsive, mostly flat aesthetic, using the same two shades of blue (#c1deef and #e1f3fd) as I’ve used with W3Counter since around 2006.
I found that most pages of the old site were rarely if ever viewed, so why have them at all? I trimmed it down to just 3 — a homepage with a giant image showing off the reports and signup button, the monthly browser & OS market share report that gets quoted in news at least a few times a month, and a signup form.
So far so good — I published the new design three days ago. Only one user wrote in with a note that they didn’t like something I changed. The daily signup rate has doubled. Several of them upgraded to paid accounts within minutes of signing up. 2014 should be another good year for W3Counter.
When Walker put the objects, along with their accompanying stories, up for sale on eBay, the results were astonishing. On average, the value of the objects rose 2,700%. That’s not a typo: 2,700%. A miniature jar of mayonnaise he had purchased for less than a dollar sold for $51.00. A cracked ceramic horse head purchased for $1.29 sold for $46.00. The value of these formerly abandoned or forsaken objects suddenly and mysteriously skyrocketed when they were accompanied by a story.
Spreedly is one of my favorite companies because they’ve solved the problem of payment processor lock-in for my business. Their service is a very affordable, independent payment information “vault” — a secure, PCI-DSS compliant place to store customers’ data, and later charge it using whatever payment processor I want.
Spreedly is built for developers — it is a set of APIs that my software can communicate with to store payment information or tell Spreedly to do things with it, like charging some amount or deleting some information when a customer cancels their subscription. There’s no way to look at what’s been stored in an account other than writing code. That’s why I created Vault Viewer, a small PHP application that lets you look into your account and see, search and delete your stored payment gateways, payment methods and transactions.
The code is open source and free to use, and installation is typically just a matter of dropping the whole thing into a web server document root configured to serve PHP. There’s a Live Demo Here if you’d like to try before installing. I recommend only using the demo if your account only contains test data, as it’s not on an SSL-secured domain.
My date range picker component for Twitter Bootstrap has been updated with the much-requested ability to choose times as well. You could use it in an app to schedule meetings, choose flight departure/arrival times, etc. Enjoy.
P.S. Yes, it works with the upcoming Bootstrap 3 as well.